How to set up a Form Duration Report

Anne Ramey
Report Writers
Knowledge of how to use Domo reporting tool

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.cclosedAt} in LastFullMonth and ({services.cformSlug} = "catering-request" or {services.cformSlug} = "cleaning" or {services.cformSlug} = "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

  • 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 csubmittedAt and the cclosedAt Duration
    • Duration: A function to convert the Seconds into Days, Hours, Minutes, and Seconds Seconds