How to Set Up a Request by Month - Status Report

The Request by Month - Status report will display a bar graph of the that specific Request form's submissions broken down by Month and Status. For demonstration purposes, we are using the General Support Request.

Action Enabled

The action enabled by this report will allow you to determine if your specific Form has enough resources in order to complete the fulfillment process in a timely fashion.

Sample Report

General Support Request by Month - Status

Report Definition

Database Table:

general support request

Note: This will be the table name for whichever service/request you want to display.

Search Criteria:

'c_createdAt' >= "01/01/2017"

Fields Displayed:

  • Status: l_Status
  • Date: c_submittedAt