- Visualize and present data
Drilldowns and exploration
Mode's built-in charts include various tools for interacting with the data they display. Report viewers should feel free to explore at will: when a viewer uses any of the interactive features below, none of these changes will persist beyond that viewer's session, and the underlying report will not be affected.
To use interactive chart features, hover over a built-in chart. You'll see the following options:
Collapse: Increase or decrease the granularity of the chart data. Available when the chart's X-axis is a time-series and more granular data is available in the underlying query results.
Link: Generates a URL that other logged-in members of your Mode Workspace can use to view only that specific chart.
Forward: Undo and redo any exploratory modifications to the chart.
Explore: Launches a drag-and-drop interface that can be used to customize the chart or explore the data.
Within the overflow menu (an icon with 3 vertical dots), there are several additional options:
View Query: Navigates users within Mode to view the SQL syntax of the query that powers the chart you were just examining.
View Query Results: Navigates users within Mode to view the full query results that power the chart you were just examining.
Export chart data to CSV: Only for charts created in Mode's Visual Explorer, this option allows the export of aggregated, filtered chart summary data as a CSV.
Depending on the chart type and available data, viewers can click on an individual data point for additional options:
Explore: Launches a drag-and-drop interface that can be used to explore the data behind the chosen point.
View Data: Opens a display table containing the data behind the chosen point.
Drilldown: Increases granularity of the chart to display the detail behind the chosen point. Available when the chart's X-axis is a time-series and more granular data is available in the underlying query results.
You can disable these options for an individual chart by un-checking
Enable Drilldownsin the Format tab on the right side of the chart editor.
IMPORTANT:For security purposes, when viewing an embedded report, the
View Dataoption is not available, and the
Exploreoption is only available to logged-in Mode users with access to the underlying report.
Filters and parameters
Filters and Parameters let viewers customize a report's output without touching code or modifying its configuration.
Parameters:Dynamically modify the SQL code of the report before it is executed against the database. When a report viewer changes a parameter's value, the report must be re-run to see any changes to the results.
Filters:Modify the data presented in a report's built-in charts and visualizations. Filters are applied to the data visualized in the browser after all of the report's queries have finished running.
How to add filters to a report
- In the report builder, click
- You'll see a list of all columns from all queries in your report. Select one to filter and click
- The filter will appear on the right side of the report builder. Hover over the filter and click the
gearicon to customize.
- To set the default values for a report's filters, adjust them in the report builder and click
Set as Default.
NOTE:If the same column name appears in multiple queries in your report, applying a corresponding filter will filter all columns of that name across all queries.
Was this article helpful?