How to set up a Form Duration Report

The Form Duration report will display the Average Duration time it takes for a Submission to be Closed by each Form.

Note: Click the images to see larger versions. You may then need to click to zoom in.

Action Enabled

The action enabled by this report will be to apply more resources to the Forms with the longest durations and reduce the fulfillment time.

Sample Report

Form DurationForm Duration

Report Definition

Database Table:


Search Criteria:

{services.c_closedAt} in LastFullMonth and ({services.c_formSlug} = "catering-request" or {services.c_formSlug} = "cleaning" or {services.c_formSlug} = "general-it-request")

Fields Displayed:

  • Form: c_formSlug

Calculated Fields:

  • Confirmation #: To display the Confirmation # I built a Formula to display the last six characters of the c_id field

Confirmation %232Confirmation %232

  • Duration: To display the Duration I had to build two formulas, Seconds and Duration
    • Seconds: A function to find the DateDiff in Seconds between the c_submittedAt and the c_closedAt
    • Duration: A function to convert the Seconds into Days, Hours, Minutes, and Seconds

Did this page help you?