Track the Items involving each Attribute.
The Activity by Attribute Report lets you view the number of Items involving each Attribute Value.
Example of the Activity by Attribute Report in List view. For each Attribute Value, you can view key information about Items with that Attribute Value, including the total number of Items and 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 Attribute 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 number of Items involving each Attribute Value, the percentage of Items referenced by the Report that involve that Attribute Value, 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 number of Items involving each Attribute Value as a 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 Attribute Value.
- 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.
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.
- 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 Picker or Item Filter, the Originating, Responsible, and 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.
- Attribute: Expand the drop-down to choose which Attribute(s) should be included in this Report.
- If the selected Attribute has multiple associations, an additional Attribute Type drop-down will appear. Use this dropdown to specify whether you want to reference Items where the Attribute is used in the Item Work Panel, Impact, or AdHoc Field.
See a list of Items referenced by the Report
When in the List view:
- Click an Attribute Value's Total or Percent value to see a list of the referenced Items.
- Hover over a segment of an Attribute Value's status bar to open a tooltip that lists the number of Items it includes.
- Click a segment of an Attribute Value's status bar to open a list of all Items that it includes.
When in the Graph view:
- Hover over a bar or data point to open a tooltip that lists its exact value.
- Click a bar or data point to open a list of all Items contributing to that metric.
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 Attribute
Activity by Attribute Reports can also be added as a Card on Boards.
When adding an Activity by Attribute Report Card to a Board, 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 cause the Attribute Value used on the most Items to be listed first.