Add high-level review and approval information with KPIs and Charts
You can view high-level information about document approvals with KPIs and charts. Drill-down information is not currently available in the beta.
KPIs
Pending approvals
-
Create a dashboard as described in the section above.
-
In the KPI card, click Add.
-
Type Pending in the KPI Title textbox.
-
Type Pending approvals in the KPI Caption textbox. This text describes what the KPI is showing.
-
At the top of the page, click Select KPI Field.
-
Scroll down and find the Document Approval folder.
-
Choose Status, then select Count from the drop-down menu.
-
Click Edit Filter > Add condition.
- Click into the empty condition filter, click Pick a Field, then choose Status.
- Leave the operator as Equal, and type pending review in the textbox.
-
Click Done in the top-right corner of the screen.
Overdue approvals
-
Create a dashboard as described in the section above.
-
In the KPI card, click Add.
-
Type Overdue in the KPI Title textbox.
-
Type Approval Stage Deadline in the Past in the KPI Caption textbox. This text describes what the KPI is showing.
-
At the top of the page, click Select KPI Field.
-
Scroll down and find the Document Approval folder.
-
Choose Status, then select Count from the drop-down menu.
-
Click Edit Filter > Add condition:
- Click into the empty condition filter, click Pick a Field, then choose Deadline.
- Change the operator to Less Than, and toggle Relative date On, then type $$TODAY in the textbox.
-
Click Add condition:
- Click into the empty condition filter, click Pick a Field, then choose Status.
- Change the operator to Not Contains, then type approved in the textbox.
-
Click Done in the top-right corner of the screen.
Completed approvals
-
Create a dashboard as described in the section above.
-
In the KPI card, click Add.
-
Type Completed in the KPI Title textbox.
-
Type Approval Status Count in the KPI Caption textbox. This text describes what the KPI is showing.
-
At the top of the page, click Select KPI Field.
-
Scroll down and find the Document Approval folder.
-
Choose Status, then select Count from the drop-down menu.
-
Click Edit Filter > Add condition:
- Click into the empty condition filter, click Pick a Field, then choose Status.
- Change the operator to Contains, and type approved in the textbox.
-
Click Add condition:
- Click And to change it to Or.
- Click into the empty condition filter, click Pick a Field, then choose Status.
- Change the operator to Equals, then type reviewed in the textbox.
-
Click Done in the top-right corner of the screen.
Abandoned approvals
-
Create a dashboard as described in the section above.
-
In the KPI card, click Add.
-
Type Abandoned in the KPI Title textbox.
-
Type Approval deadline over 2 weeks past in the KPI Caption textbox. This text describes what the KPI is showing.
-
At the top of the page, click Select KPI Field.
-
Scroll down and find the Document Approval Stage folder.
-
Choose Deadline, then select Count from the drop-down menu.
-
Click Edit Filter > Add condition:
- Click into the empty condition filter, click Pick a Field, then choose Status.
- Change the operator to Not Contains, and type approved in the textbox.
-
Click Add condition:
- Click into the empty condition filter, click Pick a Field, then choose Deadline.
- Change the operator to Less Than, then toggle Relative date On, then type $$TODAY-2w in the textbox.
-
Click Done in the top-right corner of the screen.
Charts
Approvals by decision bar chart
-
Create a dashboard as described in the section above.
-
In the Chart card, click Add.
-
Type Approvals by decision in the Name textbox.
-
(Optional) Type a description in the Description textbox. This text displays as a tooltip next to the chart name.
-
Click Open chart details.
-
In the Chart type drop-down menu, leave Bar Chart selected.
-
In the Bar type drop-down menu, leave Simple selected.
-
Click Update field for the Bottom (X) axis, and choose the first Document Approval folder then Status.
-
Set the Aggregation type to Count.
-
Click Update field for the Left (Y) axis, and choose the first Document Approval option then Status.
-
Click on the Filter tab
-
Click Edit Filter > Add condition:
- Click into the empty condition filter, click Pick a Field, then choose Document Version Version.
- Change the operator to Is Not Null.
-
Click Done in the top-right corner of the screen.
Revisions bar chart
-
Create a dashboard as described in the section above.
-
In the Chart card, click Add.
-
Type Revisions in the Name textbox.
-
Type Number of revisions for documents with incomplete decisions planned before the end of this month in the Description textbox. This text displays as a tooltip next to the chart name.
-
Click Open chart details.
-
In the Chart type drop-down menu, leave Bar Chart selected.
-
In the Bar type drop-down menu, leave Simple selected.
-
Click Update field for the Bottom (X) axis, and choose the first Document Approval folder then Document Version > Version.
-
Set the Aggregation type to Count.
-
Click Update field for the Left (Y) axis, and choose the first Document Approval option then Document Version > Document > Name.
-
Click the Filter tab
-
Click Edit Filter > Add condition:
- Click into the empty condition filter, click Pick a Field, then choose Approval Stage Participants Decision Date.
- Change the operator to Is Null.
-
Click Edit Filter > Add condition:
- Click into the empty condition filter, click Pick a Field, then choose Approval Stage deadline.
- Change the operator to Less Than or Equal, then toggle Set relative date On and type $$TODAYem in the textbox.
-
Click Done in the top-right corner of the screen.