Just like with dashboards, queries contain interactivity tools to help you and your viewers analyze and modify results.
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 by clicking and dragging across multiple data points. When you do this, a drop-down list appears with the following interaction options:
Use the decompose interaction to slice only selected data points by additional attributes.
To decompose your data points, you will select an attribute to use as the axis of analysis. The results of your selected data point will be sliced by the axis of analysis. The axis of analysis attributes replace the attributes originally on your query frame. The original attributes become filters with the values of the data point selected.
For example, if you're measuring # Tickets per Year (Ticket Created), and you select to decompose the 2014 year data point by Requester Name, your query frame would resemble the image below.
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.
The example below uses decompose to examine the number of tickets created each day of a quarter. You can replicate these steps using any metrics and attributes.
- Select the columns of the quarter you want to view. This example uses the first quarter.
- Select Day for the axis of analysis.
- Select the On columns option.
- Click Ok.
You will see results for each day in the selected 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 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 year 2014.
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 decomposed quarterly results chart above, you can focus into the first three 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 the options you don't want to use.
- Save the query.