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 Duration

Report Definition

Database Table

services

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 %232