|Announced on||Rollout on|
|July 14, 2021||July 26, 2021|
On July 26, 2021, we’ll be releasing a new query interaction called drill in. This feature provides a flexible yet consistent tool for digging into your data, enabling you to easily discover trends, investigate spikes, and more.
The new drill in feature replaces the drillthrough and decompose query interactions. Not only does drill in consolidate the functionality of drillthrough and decompose, it also eliminates certain limitations of those legacy query interactions.
How does drill in work?
Drill in can be enabled in the Chart configuration ( ) menu of Query builder. When creating a report, the report editor can choose which attributes should be available in the drill in feature by default, as well as choose whether to allow report viewers to add additional drill in attributes later on.
For more information on configuring and using the drill in feature, see Using drill in to refine your queries.
What makes drill in better?
The drill in query interaction gives you greater reporting power and flexibility when compared to the legacy drillthrough and decompose interactions. Specifically, drill in:
- Includes clickable links for tickets, users, organizations, and more for easy reference.
- Can be easily applied on all visualizations, including KPIs and line charts.
- Always opens in a separate window, not inside of the widget (no more widget size restriction).
- Can be applied on any type of metric, including calculated metrics.
- Can include any type of attribute, including calculated attributes.
- Displays data that can be easily copied or exported in CSV or Excel format.
- Enables viewers to add and remove attributes without having to update their query.
How does this impact me?
The following interactions will be removed and replaced by the new drill in feature:
- Filter others
- Filter others only
What action do I need to take?
If you’ve configured drillthrough or decompose in any of your queries, the attributes you used in those legacy interactions will automatically be mapped to the new drill in interaction. In the majority of cases, we anticipate that you won’t need to take any action and can simply use drill in instead of drillthrough or decompose going forward.
However, it’s possible that the automatic mapping won’t cover all of your use cases. We recommend reviewing your most important reports that used drillthrough or decompose functionality to ensure that the most appropriate drill in configuration is set.
To reproduce focus, filter others, and filter others only functionality, see the next section.
Additionally, you might need to proactively enable the drill in feature on certain dashboards. This applies only to dashboards where you’ve previously disabled other query interactions (including drillthrough, decompose, filter others, filter others only, or focus).
- Open your dashboard for editing.
- Click Tab options > Interaction options ().
- Select Enable drill in.
How can I achieve the same functionality as the legacy interactions?
Drillthrough: Use the Selected attributes feature in the Drill in panel to select the attributes that you want to appear by default in the drill in table.
Decompose and focus. Use the Enable adding attributes feature in the Drill in panel to select the additional attributes that viewers should be able to choose from.
- Filter others and filter others only. These interactions were available only within dashboards and can be replaced with additional filters added to the dashboard itself. Using dashboard filters is the best way to let viewers dynamically narrow results.
Questions or feedback?
If you have any questions, feel free to leave a comment below. If you have suggested improvements for the drill in feature, or if you’ve identified missing functionality in the current implementation, create a new post or comment in our user community.