Create a report dashboard for review and approvals
You can create a report dashboard in the Canvas Dashboards area to display both high-level and detailed information about reviews and approvals with Unified Approvals functionality.
Create a dashboard
-
Click the Main Menu icon
-
In the left panel, click Canvas Dashboards.
-
Click New Dashboard.
-
Name your dashboard.
-
(Optional) Add a description.
-
Click Create.
Once you create a dashboard, you can start adding KPIs, Charts, and Tables. See the following sections for more information:
Add high-level review and approval information with KPIs and Charts
You can view high-level information about document approvals with KPIs and charts.
For more information, see Build a KPI report and Build a chart report.
KPIs
Pending approvals
-
Create a dashboard as described in the section above.
-
In the top-right corner of the dashboard details page, click Add report.
-
In the Add report box, select Create report.
-
On the left side, select KPI.
-
In the upper-right corner, click Create report.
-
Follow the steps below to configure the Details section:
- Type Pending in the Name field.
- Type Pending approvals in the Description field. This displays as a caption below the KPI value.
-
Follow the steps below to configure the Build KPI section:
-
In the left panel, click the Build KPI
-
Click Select field.
-
Locate and select the Document approval folder.
-
Select Status.
-
In the Aggregation type drop-down, select Count.
-
-
Follow the steps below to configure the Filter section:
-
In the left panel, click the Filter
-
Select Edit filter.
-
Click Add condition.
-
Click into the empty condition filter, click Pick a Field, then choose Status.
-
Leave the operator as Equal, then type pending review in the textbox.
-
-
Click Save in the top-right corner of the screen.
Overdue approvals
-
Create a dashboard as described in the section above.
-
In the top-right corner of the dashboard details page, click Add report.
-
In the Add report box, select Create report.
-
On the left side, select KPI.
-
In the upper-right corner, click Create report.
-
Follow the steps below to configure the Details section:
- Type Overdue in the Name field.
- Type Approval Stage Deadline in the Past in the Description field. This description displays as a caption below the KPI value.
-
Follow the steps below to configure the Build KPI section:
-
In the left panel, click the Build KPI
-
Click Select field.
-
Locate and select the Document approval folder.
-
Select Status.
-
In the Aggregation type drop-down, select Count.
-
-
Follow the steps below to configure the Filter section:
-
In the left panel, click the Filter
-
Select Edit filter.
-
Click Add condition.
-
Click into the empty condition filter, then click Pick a Field.
-
Select Approval Stage > Deadline.
-
Change the operator to Less Than.
-
Toggle Set relative date to ON, then type $$TODAY in the textbox.
-
Click Add condition.
-
Click into the empty condition filter, then click Pick a Field.
-
Select Status.
-
Change the operator to Not Contains, then type approved in the textbox.
-
-
Click Save in the top-right corner of the screen.
Completed approvals
-
Create a dashboard as described in the section above.
-
In the top-right corner of the dashboard details page, click Add report.
-
In the Add report box, select Create report.
-
On the left side, select KPI.
-
In the upper-right corner, click Create report.
-
Follow the steps below to configure the Details section:
- Type Completed in the Name field.
- Type Approval Status Count in the Description field. This description displays as a caption below the KPI value.
-
Follow the steps below to configure the Build KPI section:
-
In the left panel, click the Build KPI
-
Click Select field.
-
Locate and select the Document approval folder.
-
Select Status.
-
In the Aggregation type drop-down, select Count.
-
-
Follow the steps below to configure the Filter section:
-
In the left panel, click the Filter
-
Select Edit filter.
-
Click Add condition.
-
Click into the empty condition filter, then click Pick a Field.
-
Select 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, then click Pick a Field.
-
Select Status.
-
Change the operator to Equal, then type reviewed in the textbox.
-
-
Click Save in the top-right corner of the screen.
Abandoned approvals
-
Create a dashboard as described in the section above.
-
In the top-right corner of the dashboard details page, click Add report.
-
In the Add report box, select Create report.
-
On the left side, select KPI.
-
In the upper-right corner, click Create report.
-
Follow the steps below to configure the Details section:
- Type Abandoned in the Name field.
- Type Approval deadline over 2 weeks past in the Description field. This description displays as a caption below the KPI value.
-
Follow the steps below to configure the Build KPI section:
-
In the left panel, click the Build KPI
-
Click Select field.
-
Locate and select the Document approval stage folder.
-
Select Deadline.
-
In the Aggregation type drop-down, select Count.
-
-
Follow the steps below to configure the Filter section:
-
In the left panel, click the Filter
-
Select Edit filter.
-
Click Add condition.
-
Click into the empty condition filter, click Pick a Field.
-
Select Status.
-
Change the operator to Not Contains, and type approved in the textbox.
-
Click Add condition.
-
Click into the empty condition filter, then click Pick a Field.
-
Select Deadline.
-
Change the operator to Less Than, then toggle Set relative date to ON.
-
Type $$TODAY-2w in the textbox.
-
-
Click Save 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 top-right corner of the dashboard details page, click Add report.
-
In the Add report box, select Create report.
-
On the left side, select Chart.
-
In the upper-right corner, click Create report.
-
Follow the steps below to configure the Details section:
- Type Approvals by decision in the Name field.
- (Optional) Type a description in the Description field. This text displays as a tooltip next to the chart name.
-
Follow the steps below to configure the Build chart section:
-
In the left panel, click the Build chart
-
In the Chart type drop-down menu, leave Bar selected.
-
In the Bar type drop-down menu, leave Simple selected.
-
Click Update field for the Bottom (X) axis, then select Document Approval > Status.
-
Set the Aggregation type to Count.
-
Click Update field for the Left (Y) axis, then select Status.
-
-
Follow the steps below to configure the Filter section:
- In the left panel, click the Filter
- Click Edit Filter, then Add condition.
- Click into the empty condition filter, then click Pick a Field.
- Select Document Version > Version.
- Change the operator to Is Not Null.
- In the left panel, click the Filter
-
Click Save in the top-right corner of the screen.
Revisions bar chart
-
Create a dashboard as described in the section above.
-
In the top-right corner of the dashboard details page, click Add report.
-
In the Add report box, select Create report.
-
On the left side, select Chart.
-
In the upper-right corner, click Create report.
-
Follow the steps below to configure the Details section:
- Type Revisions in the Name field.
- Type Number of revisions for documents with incomplete decisions planned before the end of this month in the Description field. This text displays as a tooltip next to the chart name.
-
Follow the steps below to configure the Build chart section:
-
In the left panel, click the Build chart
-
In the Chart type drop-down menu, leave Bar selected.
-
In the Bar type drop-down menu, leave Simple selected.
-
Click Update field for the Bottom (X) axis, then select Document Approval > Document Version > Version.
-
Set the Aggregation type to Count.
-
Click Update field for the Left (Y) axis, then select Document Approval > Document Version > Document > Name.
-
-
Follow the steps below to configure the Filter section:
-
In the left panel, click the Filter
-
Click Edit Filter, then Add condition.
-
Click into the empty condition filter, then click Pick a Field.
-
Select Approval stage > Approval stage participants > Decision Date.
-
Change the operator to Is Null.
-
Click Add condition.
-
Click into the empty condition filter, then click Pick a Field.
-
Select Approval stage > Deadline.
-
Change the operator to Less Than or Equal, then toggle Set relative date to ON.
-
Type $$TODAYem in the textbox.
-
-
Click Save in the top-right corner of the screen.
Add detailed review and approval information with Tables
For more information on building a table report, see Build a table report.
Pending approvals list
-
Create a dashboard as described in the section above.
-
In the top-right corner of the dashboard details page, click Add report.
-
In the Add report box, select Create report.
-
On the left side, select Table.
-
In the upper-right corner, click Create report.
-
Follow the steps below to configure the Details section:
- Type Pending approvals in the Name field.
- Type a description in the Description field. This text displays as a tooltip next to the chart name.
-
Follow the steps below to configure the Build table section:
- In the left panel, click the Table columns
- Click Add column.
- Scroll down and select Document Approvals > Status.
- Add the following columns:
table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2 6-row-2 html-authored no-header Project name Document Version > Document > Project > Name Document name Document Version > Document > type Name in the search box. Document version Document Version > Document > Version Deadline Document Approval > Approval Stage > Deadline Requested by Document Approval > Approval Stage > Approval Stage Participants* > Requester > type Name in the search box. Requested date Document Approval > Approval Stage > Approval Stage Participants* > Created at Approver Document Approval > Approval Stage > Approval Stage Participants* > Participant User > type Name in the search box. *Approval Stage Participants is truncated to Approval Stage Pa…
- In the left panel, click the Table columns
-
Follow the steps below to configure the Filter section:
- In the left panel, click the Filter
- Click Edit Filter, then Add condition.
- Click into the empty condition filter, then click Pick a Field.
- Select Status.
- Change the operator to Equal, then type pending approval in the textbox.
- (Optional) Add additional filters as described in the Optional filters section below.
- In the left panel, click the Filter
-
Click Save in the top-right corner of the screen.
Optional filters
To view more specific information depending on your use case, you can add additional filter conditions. You may want to recreate the table and add new filter conditions per use case.
My Projects
-
Click Edit Filter > Add condition:
- Click into the empty condition filter, then click Pick a Field.
- Select Document version > Document > Project > Owner > type Name in the search box.
- Change the operator to Equal, then choose Me (Logged in user) to display projects in Workfront where you are marked as the project owner.
-
Click Save in the top-right corner of the screen.
Approvals I’ve submitted
-
Click Edit Filter > Add condition:
- Click into the empty condition filter, click Pick a Field.
- Select Approval Stage > Approval Stage Participants > Requester > type Name in the search box.
- Change the operator to Equal, then choose Me (Logged in user) to display projects in Workfront where you are marked as the project owner.
-
Click Save in the top-right corner of the screen.
Overdue approvals list
-
Create a dashboard as described in the section above.
-
In the top-right corner of the dashboard details page, click Add report.
-
In the Add report box, select Create report.
-
On the left side, select Table.
-
In the upper-right corner, click Create report.
-
Follow the steps below to configure the Details section:
- Type Overdue approvals in the Name field.
- (Optional) Type a description in the Description field. This text displays as a tooltip next to the chart name.
-
Follow the steps below to configure the Build table section:
-
In the left panel, click the Table columns
-
Click Add column.
-
Scroll down and select Document Approvals > Status.
-
Add the following columns:
table 0-row-2 1-row-2 2-row-2 3-row-2 4-row-2 5-row-2 6-row-2 html-authored no-header Project name Document Version > Document > Project > Name Document name Document Version > Document > type Name in the search box. Document version Document Version > Document > Version Deadline Document > Approval Stage > Deadline Requested by Document > Approval Stage > Approval Stage Participants* > Requester > type Name in the search box. Requested date Document > Approval Stage > Approval Stage Participants* > Created at Approver Document > Approval Stage > Approval Stage Participants* > Participant User > type Name in the search box. *Approval Stage Participants is truncated to Approval Stage Pa…
-
-
Follow the steps below to configure the Filter section:
- In the left panel, click the Filter
- Click Edit Filter, then Add condition.
- Click into the empty condition filter, then click Pick a Field.
- Select Approval Stage > Deadline.
- Change the operator to Less than, then toggle Set relative date to ON.
- Type $$TODAY in the text field.
- (Optional) Add additional filters as described in the Optional filters section below.
- In the left panel, click the Filter
-
Click Save in the top-right corner of the screen.
Optional filters
To view more specific information depending on your use case, you can add additional filter conditions. You may want to recreate the table, and add new, optional filter conditions per use case.
My Projects
-
Click Edit Filter > Add condition:
- Click into the empty condition filter, click Pick a Field.
- Select Document version > Document > Project > Owner > type Name in the search box.
- Change the operator to Equal, then choose Me (Logged in User) to display projects in Workfront in which you are marked as the project owner.
-
Click Save in the top-right corner of the screen.
Approvals I’ve submitted
-
Click Edit Filter > Add condition:
- Click into the empty condition filter, click Pick a Field.
- Select Approval Stage > Approval Stage Participants > Requester > type Name in the search box.
- Change the operator to Equal, then choose Me (Logged in User) to display projects in Workfront in which you are marked as the project owner.
-
Click Save in the top-right corner of the screen.
My team
-
Click Edit Filter > Add condition:
- Click into the empty condition filter, click Pick a Field.
- Select Approval Stage > Approval Stage Participants > Participant Team > type Name in the search box.
- Change the operator to Equal, then choose My default teams (Logged in User) or My other teams (Logged in User) to display projects assigned to either your default team or other teams you are on.
-
Click Save in the top-right corner of the screen.