Activity by Attribute Report

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 three 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-53.
  • Show Values: When enabled, the value of each data point will be displayed on the graph.
• Over Time: This view displays Item count data by Attribute Value across various time frames. Based on your selected reference date, the table will display the number of Items that were created, started, due, or completed within each time frame.
  • Column Totals: Select this checkbox to include a total for each column. This will display all Attribute Values' combined Item count for each time frame. 
  • Row Totals: Select this checkbox to include a total for each Attribute Value. This will display theAttribute Value's total Item count for the report's entire date range.

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. 

• • Interval: This option will be available when your Report is in Over Time view. Use this drop-down to select how the report's time frames are divided—by month, quarter, or year. For example, choosing "Month" will display data for each month within your selected date range.

• 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.

• 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 additional options when the Report is in List view. 

• Edit Columns: Use the Edit Columns window to select which columns appear on the Card when the Report is in List view. These selections will persist the next time you view the Board.
• 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.