Just like your dashboards, queries contain interactive tools to help you and your users view more detailed results of your data.
This article contains the following sections:
Interacting with queries
There are multiple interactivity features you can use with your queries. You can perform any of the available interactions by selecting a data point or clicking and dragging across a data range.
A drop-down list will appear with the following interaction options:
You can use the decompose interaction to slice only a selected data range by additional attributes.
To slice your data range, decompose adds an axis of analysis. The attributes you select as your axis of analysis will replace your existing attributes. The original attributes move to Filters, and your results are filtered by the values in your selected data range. For example, if your selected data range is located in the Accessories value of the attribute Category, all results will be filtered to Accessories.
If you do not want your attributes to move to Filters, you can check Keep original element on axis. Your attributes remain in their original positions with only the values from the data range selected.
By default viewers can select any attribute in your dataset as the axis of analysis. You can restrict the available attributes in Chart configuration > Decompose type.
You can use decompose for example, to look further into a quarterly revenue chart.
- Select the columns of the quarter you would like to view. The chart below examines the first quarter.
- Select Day for the axis of analysis.
- Select the On columns option.
- Click Ok, and you will see the results of each day in your quarter.
If you are looking for a more in-depth view of your data, you can use the drillthrough interaction. Drillthrough provides you with a table of all of your underlying results based on your selected data range. Drillthrough first filters results by the attribute values of your selected data range, then displays each metric sliced by every attribute. If you are using any attributes with a category and subcategory, like date, the most granular level will be used.
In the drillthough below, the data point is located in the Austria value of the Country attribute.
By default, all attributes and metrics are displayed in the imported order. You can deselect elements and edit their order in Chart configuration > Drillthrough.
For a more simple interaction option, you can use focus to zoom in to one data point or a data range. If your chart has several data points grouped together, focus can be useful for calling out a specific area. For example in the first quarter revenue chart above, you can focus into the first four days.
The focus results will resemble the image below:
Disabling interaction options
If interaction options are enabled, you might not be able to publish your dashboard without sharing with viewer groups. You will need to turn off interaction options to share your dashboard.
- Click the Chart configuration icon ().
- In the Chart configuration menu, select Interactions.
- Uncheck any relevant boxes.
- Save your query.