Filter reports on a dashboard

Prev Next

Filter reports by timeseries, drill down node levels, filter on a specific person, account, or product.

Filter by timeseries

Filter all reports on a dashboard by a specified period of time.

  1. Go to Reports.

  2. Select the folder for the report you want to view.

  3. Find the dashboard you want to view.

  4. From the timeseries dropdown, select the the period of time you want to view report data for:

    Timeseries dropdown from a dashboard.

    1. Fiscal Year: Selected fiscal year.

    2. Trailing: Past number of days selected to the current date.

    3. To Date: Start of the last month, quarter, or year to the current date.

    4. This: Current month, quarter, or year.

    5. Last: Last month, quarter, or year.

    6. Next: Next month, quarter, or year (estimated).

    7. Custom: Select the date range to filter data on.

Filter on a person, account, or product node

Filter all reports on a dashboard by a person, account, or product. The filter options are determined by the data source for the dashboard (Teams, Products, Segments).

  1. Go to Reports.

  2. Select the folder for the report you want to view.

  3. Find the dashboard you want to view.

  4. From the (All People, All Accounts, All Products) dropdown, select the person, account, or product you want to filter reports on.

    Individual account filter dropdown from a Segment dashboard.

    Note

    If data is not available for a specific report on the dashboard it will display not available on that report.

Filter by node level

Select to filter individual reports by node level.

  1. Go to Reports.

  2. Select the folder for the report you want to view.

  3. Find the dashboard you want to view.

  4. Find the report you want to filter.

  5. Click the level filter dropdown and select one of the following:

    Level filter dropdown from a report.

    • All Child Levels: includes all child nodes under the top selected node.

    • Next Level Only: includes the next level from the selected node.

    • Selected Level (default): includes the selected node.

Table filters

Use the different filtering options on a table to customize your view of the data:

Use the column search field to filter table data by search terms.

  1. Click on the search field at the top of the column.

  2. Type your search criteria.

    Note

    The table dynamically filters data based on related letters as you type.

    Git showing the column search functionality.

Use the sort and arrange feature to organize the data in the transactions table, as needed.

  1. Click on the column title to sort the table by ascending ↑ or descending ↓ alphabetical order in the column.Gif showing the column sort functionality.

  2. Drag column headers in the order you want them to display in the table.

Use the group by feature to change how you view the transaction data based on selected groupings.

  1. Drag and drop column headers from the table to the group by field to group the data in the table based on the selected columns.Gif showing the group by functionality.

Use the Column Chooser to customize what column data displays in the transactions table.

  1. Click Column Chooser.

  2. Drag and drop column headers to and from table and the Column Chooser window.

    Example of moving columns between the table and the Column Chooser.

Use the refresh option to ensure you are viewing the latest data.

  1. Click Refresh.

    Note

    The table may take a few seconds to pull in the latest data and reload.