Reports

The Reports feature provides a structured way to present various metric values in a detailed and organized format. By using a table-based approach, reports allow for advanced customization, including filtering, grouping, and column customization, to ensure the most insightful data presentation.

With reports, you can visualize metric values flexibly, analyze data from different perspectives, and tailor dashboards to meet specific needs.

How to Add/Edit a Report

To create or modify a report, follow these steps:

1. Open Dashboard ↗ from the left-side menu.
2. Navigate to the dashboard where you want to add or modify a report.
3. Click Edit in the top-right corner to enable dashboard editing mode.

   Note: You must be an Editor or Owner of the dashboard to modify it. See the Dashboard Sharing article for more details.

4. Click + Add Table and select Report to create a new report, or click the Gear icon next to an existing report to edit it.
   
   

Configuring the Report

5. Select Metrics to display in the report:
   • Tip: Start typing the metric name to quickly find it in the list.
   • You can also add a custom Formula (see the Formulas article for more details).

6. Edit selected Metrics as needed:
   • Click on a metric name to enter edit mode.
   • Reorder metrics using drag-and-drop to change the column order.
   • Show/Hide a metric by clicking the eye icon.
   • Delete a metric by clicking the cross icon.
   • Duplicate a metric by clicking the duplicate icon.
   • Edit a metric by clicking the pencil icon, where you can:
     • Change the name of the metric column.
     • Adjust the date range (by default, it follows the dashboard date range, but you can override it).
     • If overridden, you can Reset to dashboard date range.
     • Apply filters to the metric.

7. Select Columns to structure data:
   • For example, selecting Employee › Name will break down metrics by employees (see example).

8. Set row Groupings (Optional):
   • Allows hierarchical structuring of data.
   • Example: Selecting Client and Project will group data first by Client, then by Project, displaying subtotals at each level (see example).

9. Set Column Groupings (Optional):
   • Allows for hierarchically grouping metric columns (see example).

10. Apply Filters (Optional):
    • Filters affect the entire report (all metrics).
    • The metrics can be filtered by various criteria (such as Client, Department, Project, etc.) to help narrow down and focus on the most relevant data.
    • If the dashboard already has filters, they will apply by default but can be toggled off.

11. Enter a Title for the report and Save it.

Columns vs. Row Grouping vs. Column Grouping

Different ways of structuring and displaying data:

Example 1: Using Columns

If we select the following Columns: Month, Project › Name, and Employee › Name. The report will display:

Example 2: Using Row Grouping

If set Grouping by Month, Project, and Employee, the report will be structured hierarchically displaying subtotals at each level:

Example 3: Using Column Grouping

If we apply Column Grouping: Month, the table will dynamically display metrics for each month side by side.

Actions You Can Perform on Reports

You can manage reports directly from the dashboard using the following actions:

• Edit a Report: Click the pencil icon next to the report title.
• Reorder Reports: Drag and drop to change the order of reports on the dashboard.
• Delete a Report: Click the trash icon next to the report title.
• Duplicate a Report: Click the duplicate icon next to the report title to create a copy.

With these tools, you can customize reports to fit your specific business needs and ensure clear, insightful data presentation.