Get the details of your organization's Template activity.
The Activity by Template Report lets you see which of your Templates are being used, how many Items of that Template are in the system, and what status those Items are in.
Example of an Activity by Template Report. For each Template in the Report, you can see its total number of Items and information about those Items, including a Status Bar.
Who can access this Report?
Anyone with the "View Report Data" permission will be able to see this Report.
This Report can be accessed under the Activity section of the Reports page. It can also be added as a Card on a Board.
Working with the Report
- Understand the Report's views
- Use filters to control which data are referenced by the Report
- See a list of Items referenced by the Report
- Share the Report
The views
This Report has two views. Click the name of the view you want to see to toggle between them.
- List: Shows the total number of Items of each Template, the number of those Items which resulted in a change, the percentage of those Items which resulted in a change, and a status bar showing the current status of each of those Items.
- Hover over a column's header and click the caret icon, then hover over Columns to add and remove columns from the list, or click Sort Ascending or Sort Descending to sort the list by that column in ascending or descending order.
- Graph: Displays the data as a bar graph.
- Display as Bar: Expand the drop-down to select the dataset that should be represented on the graph. By default, this Report will show the total number of Items per Template.
- Sort: Expand the drop-down to select by which criterion this dataset should be ordered.
- Max: Enter the number of data points that should be represented on this graph. By default, this Report will show 15 data points, but it can be configured to show 1-50.
- Show Values: When enabled, the value of each data point will be displayed on the graph.
Regardless of the view, you should look for:
- Templates with very few (or no) Items. These Templates are not being used, so you might consider making sure your users are utilizing them properly or reaching out to your Customer Success Manager to help you inactivate Templates that are no longer needed.
- Templates that don't often result in a change. If Resolutions are not enabled for such a Template, then there isn't a problem. But if Resolutions are enabled, it may be a sign that people need coaching on how best to utilize that Template.
The filters
Any relevant filters in use on the main Reports screen will be automatically applied to this Report but can still be configured as needed.
- There are two date-based drop-downs. First is the "Reference Date" drop-down and second is the "Range" drop-down.
- Reference Date: Expand the drop-down to choose which type of date should be referenced by the Report. For example, select "Created in" if you want the Report to reference only those Items that were created in the specified date range.
- Range: Expand the drop-down to choose the range of dates that should be included in the Report.
- All Time removes any date range parameters.
- Custom allows you to enter any date range you want.
- Past shows you a rolling date range that counts back from the current calendar date.
- Current shows you data for the current week, month, quarter, or year.
- Last shows you data for the previous week, month, quarter, or year.
Pro Tip: The Last YTD option helps you set a date range matching the current year-to-date period but for the previous year instead. For example, if it is March 15th, 2024, and you select Last YTD, your Report will cover data from January 1st, 2023, to March 15th, 2023. This logic is also true for the Last MTD and QTD options.
- Workflow: Expand the drop-down to choose which workflows should be listed in the Report.
- Template: Expand the drop-down to choose which Templates should be listed in the Report.
- Select Originating, Responsible, or Impact to decide whether the Report should reference Items from the Originating, Responsible, or Impact Location.
- Originating and Responsible will be the default selection.
- If Impact is selected, both Originating and Responsible will be toggled off.
-
- If no Location is selected in the Location Filter or Item Filter, the Originating, Responsible, Impact toggles will not affect Report data.
- Click the filter icon and the Item Filter window will open.
- Update the item filters to control which Items are included in the Report's metrics.
- Click Save.
- Click the Locations panel on the left side of the Report to expand it.
- Filter the Report by Location and only Items tied to the selected Locations will be included in the Report.
See a list of Items referenced by the Report
When in the List view:
- Click a Template's Total, Complete Change, or Change (%) values to see a list of all Items contributing to that metric.
- Hover over a segment of a Template's status bar to open a tooltip that lists the number of Items it includes.
- Click a segment of a Template's status bar to open a list of all Items that it includes.
When in the Graph view:
- Hover over a bar or bar segment to open a tooltip that lists its exact value.
- Click a bar or bar segment to open a list of all Items that it includes.
Share the Report
To share the Report, select the ellipsis icon. In the resulting drop-down menu, you can export the Report as a PDF, download it as an XLSX file, or copy it to a Board.
- Select Print/Save PDF to export the Report as a PDF. The "Print" window will open.
- Page Size: Expand the drop-down to choose your preferred page size.
- Scale: Expand the drop-down to choose the scale percentage. This allows you to fit more content on a single page. For example, selecting 50% doubles the amount of content you can fit on one page. Make sure to select "Fit to page" in your browser's print settings.
- Click either Portrait or Landscape to choose the PDF's orientation.
- Click Print.
The Location of the Report will appear on the exported PDF beneath the Report title.
- Select Save XLSX to export the Report as a spreadsheet document. This option is only available in the List view.
- Select Copy to Board to add the Report as a Card on a Board.
- In the resulting window, select a Board. All Boards that you have permission to edit will appear as options.
- Select Copy to add the Report to your selected Board. All filters and columns included on the Report will be carried over to the Card.
- The Report Card will appear at the Board's top left corner.
Activity by Template Report Card
Activity by Template Reports can also be added as a Card on Boards.
When creating an Activity by Template Report Card, you use the same filters discussed in this article to build the Report. However, you will have an additional Sort option when the Report is in List view.
- Sort: Use the drop-down to decide by which criteria the Report should be ordered. For example, sorting by Total will result in a list where the Template with the most Items is listed first.