Skip to main content
Kinetic Community

Form Activity Report - Kinetic Request CE

Overview

The Form Activity report will provide a count of the number of form submissions that were Created in the Last Month, Closed in the Last Month, and Currently Open broken down by the Form name.  

Action Enabled

The action enabled by this report will allow you to establish an Activity baseline and will show you if your current resources are able to keep up with the Submissions of each Form.

Sample Report

Report Definition

Database Table:

services

Search Criteria:  

IsNull({services.c_closedAt}) or {services.c_submittedAt} in LastFullMonth or {services.c_closedAt} in LastFullMonth

Fields Displayed:

Form - c_formSlug

Calculated Fields:

Submitted - To display the count of Submitted records I built a conditional count function:

Closed - To display the count of Closed records I built a conditional count function:

*NOTE - As the submission might not be "Closed" I need to set the count to 0 if the c_closedAt field is NULL.

Currently Open - To display the count of Currently Open records I built a conditional count function:

 

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