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, select one or more attributes and choose if they should be placed On columns or On rows. Additionally, you can check Keep original element on the axis to keep the original attributes in the frame. As the result, the selected data points will be sliced by the new attributes you have selected. If you have chosen to hide the original elements those attributes become filters.
For example, if you’re measuring number of Tickets by Ticket Solved - Year, and you select to decompose the 2018 year data point by Ticket Solved - Month on Columns, your query frame would resemble the image below.
By default, decompose allows viewers to select any attribute in your dataset. You can restrict the available attributes or set a Decompose path in Chart configuration > Decompose type.
The example below uses decompose to examine the number of tickets created by channel each quarter. You can replicate these steps using any metrics and attributes.
- Select the bar of the quarter you want to view. This example uses the first quarter.
- Click Decompose.
- Select the Ticket Channel attribute.
- Select On columns.
- Click Ok.
You will see results for each channel 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 attributes and metrics that relate to the data selected in the query. Drillthrough first filters data based on the values you click or multi-select and then slices it by every attribute you have selected in drillthrough. For time attributes, the most granular level will be used.
>To make sure that the drillthrough table meets your needs and is easy to navigate you can choose which attributes and metrics will be displayed in the table. To select the necessary elements go to Chart configuration > Drillthrough.
For more information about drillthrough, and solutions to common problems, see Using Drillthrough.
>In the drillthrough below, the selected data point is the last month and selected attributes are Ticket ID, Ticket Group and Ticket Created - Timestamp.
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 monthly ticket resolutions chart above, you can focus into the specific month to have a closer look at the data.
The focus results will resemble the image below:
Disabling interaction options
You might want to turn off query interaction options depending on your needs.
- Click the chart configuration icon ().
- In the chart configuration menu, select Interactions.
- Uncheck the options you don't want to use.
- Save the query.
The Filter others and Filter others only query interactions can be used when the query is placed on the dashboard alongside with other queries.
Filter others allows selecting a value from a chart to be a filter for all dashboard charts, including itself. For example, if a user selects the Open Tickets Status value on a chart, and clicks the Filter others interaction, all charts will show results for only open tickets.
Filter others only acts in a similar way, the only difference is the chart where the value was selected is not be filtered.