Skip to main content
Kinetic Community

Form Duration Report - Kinetic Request CE

Overview

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

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

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 #2.png

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:

 

Related

Topics
Kinetic Survey Customer Survey ER Diagram
An ER Diagram of the Kientic Survey submitted survey.
Kinetic Survey Template ER Diagram
An ER Diagram of Kinetic Survey.
Hitchhiker's Guide to the Request Data Galaxy
Kinetic Request: the final frontier. These are the voyages of the Kinetic Request data. Your mission: to explore strange new databases, to seek out new data and new information, to boldly build reports that no one has seen before.
Reporting with Kinetic Request CE
Reporting
This document will discuss Reporting in the Kinetic Request and Task Applications.  Below you will find information discussing Why Reports are Needed, the Out of the Box Reports, and also how you can Build your own Custom Reports.
Kinetic Request Customer Submission ER Diagram
An ER Diagram of the Kinetic Request Submission process
Kinetic Request Service Item ER Diagram
An ER Diagram of Kinetic Request
Business Objects Universe - Kinetic Request and Task
This page will help you determine which Kinetic Request and Kinetic Task forms can be used to build your Business Objects Universe.
Power Reporting With Kinetic Request And Kinetic Survey
Other