Skip to main content
Kinetic Community

Approval Process Report - Kinetic Request CE

Overview

The Approval Process report will show all Closed Submissions and displays the Form Name, Count of the Times Requested, Count of the Number of Approvals, the Approved Count, Denied Count, Denial % (Denied Count/Times Requested), Average Fulfillment Duration, and the Average Approval Duration.

Action Enabled

The action enabled by this report will allow you to review the Approval Process and determine how much time is spent in the Approval Process Vs the Fulfillment Duration.  You might see some trends that indicate that your Approval Process is causing a delay in your Fulfillment Process.  You might be able to make some decisions about your Approval Process too.  If all the Submissions are Approved, for the Software Request, but the Approval Duration is 5 days, it might be a good opportunity to remove the Approval Process and decrease the Fulfillment time by 5 days.  If all of the Submissions are Denied, for the DNS Change Request, you could work with the Approvers to ensure that all of the information that they require is being populated on the Form Submission.

Sample Report

Approval Process.png

 

Report Definition

Database Table:  

services + queue approval

Join Information:

Join Type - Left Outer - Include all rows from the Left input (services) and matching rows found in the Right input (queue approval)

Join Fields - services c_id --> queue approval c_originId

Left Outer.png

 

Search Criteria:  

'c_coreState' = "Closed"

Fields Displayed:  

Form - c_formSlug 

Calculated Fields:

Times Requested - Count of the c_id field from the services table:

Times Requested.png

Number of Approvals - Count of the c_id_1 (NOTE - Domo adds an _1 to the duplicated field names) field from the queue approval table:

Number of Approvals.png

Approved Count - Count when l_Decision = Approved

Approved Count.png

Denied Count - Count when l_Decision = Denied

Denied Count.png

Denial % - Denied Count / Times Requested *100

Denial %.png

Average Fulfillment Duration - Calculates the Average difference between the c_submittedAt and the c_closedAt (services table) per each form and display the results in Days, Hours, Mins, and Secs.  This calculation is complicated and took multiple steps: 

In order to make this calculation in Domo we had to convert the c_submittedAt and the c_closedAt date time fields into Decimals.  This action was performed during the creation of the services --> queue approval join:

To Decimal.png

Now that these fields are Decimals we performed a Domo Calculator function in order to calculate the difference between c_closedAt and c_submittedAt.  The results of this calculation are being stored in a column called Fulfillment Duration Seconds:

Fulfillment Duration Seconds.png

Now we can use the Fulfillment Duration Seconds calculation, in our Domo Card, in order to calculate and display the Average Fulfillment Duration in Days, Hours, Mins, and Secs:

Average Fulfillment Duration.png

Average Approval Duration - Calculates the Average difference between the c_createdAt (createdAt is used because we need to know when the application created the Approval record and NOT when it was Submitted by the Approver) and the c_closedAt (queue approval table) per each form and display the results in Days, Hours, Mins, and Secs.  This calculation is complicated and took multiple steps: 

In order to make this calculation in Domo we had to convert the c_createdAt and the c_closedAt date time fields into Decimals.  This action was performed during the creation of the services --> queue approval join:

To Decimal.png

Now that these fields are Decimals we performed a Domo Calculator function in order to calculate the difference between c_closedAt_1 and c_createdAt_1 (as these fields are from queue approval and because the field names are also in services Domo adds an _1 to the field name).  The results of this calculation are being stored in a column called Approval Duration Seconds:

Approval Duration Seconds.png

Now we can use the Approval Duration Seconds calculation, in our Domo Card, in order to calculate and display the Average Approval Duration in Days, Hours, Mins, and Secs:

Average Approval Duration.png

 

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