- Drill in: Enables the report viewer to break a data point down by additional attributes.
- Decompose: Enables the report viewer to slice the report results with another attribute they choose.
You perform these interactions by selecting a data point on a table or chart or by clicking and dragging across multiple data points. After you click, a drop-down list appears displaying the available interaction options.
Use the following topics to learn about the interaction options and how to use them:
The drill in interaction breaks down the data points by additional attributes. For more on drill in, see Using drill in to refine your reports.
The decompose interaction slices the data points you selected by additional attributes.
To decompose a report
- In your report, select one or more data points and then click Decompose.
- On the next page, choose one or more attributes to slice the selected data points.
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.
- If you want the new attributes to be placed in the Columns panel, click On columns or if you want them in the Rows panel, click On rows.
- If you want to keep your original attribute in the report, select Keep original element on the axis.
- When you are finished, click Ok.
The selected data points will be sliced by the new attributes you have selected. If you have chosen not to keep the original elements those attributes are added to the Filters panel.
You’re measuring the number of Tickets by Ticket solved - Year, and you decompose the 2018 year data point by Ticket solved - Month on columns. Your results would resemble the image below.
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.
- Click the bar of the quarter you want to view.
- Click Decompose.
- Choose the Ticket channel attribute.
- Click On columns.
- Click Ok.
The bar for Q1 is decomposed to show the ticket channels used in the Q1 period.
- Click the chart configuration icon ().
- In the chart configuration menu, select Interactions.
- Clear the Allow decompose option.
- Save the report.
Copy (tables only)
In tables only, you can select one or more data points and then click Copy to add the data to your computer clipboard. You can only copy the result data points, not the attribute names.
Reverting interaction options
After you've used a drill in or decompose operation to dig into your data, you can use this procedure to revert to your initial report results.
To revert an interaction option
- In the report builder, click the undo button.
The report results revert to their previous state. Depending on how many report interactions you performed, you might need to click undo more than once.
So it seems like once you've done an interaction and gone past the point where you can just Undo to go back, for example, I Focused, made some other changes, then saved and closed the Query, you can then never undo your interaction, and have to completely rebuild that Query?
Hi Melissa, while the query is still open, you can indeed undo to go back, but once you save it, the undo history is no longer stored.
If you'd like to see this work differently, please open a feedback request at https://support.zendesk.com/hc/en-us/community/topics/360001200913 Thanks!
I seem to be having the same issue as a few other people here: after I use Decompose on a Query on a Dashboard, how do I make this "Actions: Initial > Decompose" line go away (the default view)?
There was previously no line between "Agent public/internal comments" and the legend with the dot colors.
I'll need to take a closer look into your dashboard so I can properly provide you a better resolution for your concern. I've gone ahead and created a ticket on your behalf so I can take a look at the dashboard for you. Looking forward to hearing from you. Cheers! :)
I'm having trouble with my queries when I'm trying to use both Decompose and Drill In.
When I decompose one set of metrics, I then try to Drill In the results, however, it's not opening up any new window.
When I Drill In to the original data, it works fine, it's only when I attempt to decompose and drill in afterwards. Does it not work that way?
Hey @...! In order to troubleshoot your issues, I'd like to take a closer look at your specific query, so I've opened a ticket on your behalf.
Does the decompose function still work in dashboards? We've been able to decompose right in the dashboard before, but now only the drill-in function is available even though I have the "allow decompose" option checked in the query settings.
Yes, you should still be able to use Decompose in dashboards. If Allow decompose is already selected in Interactions, then it's possible that Decompose type is set to none. Just head over to Chart configuration → Decompose type → and select any of the other values.
You should then see the option Decompose values in your reports.
Thank you for your answer. Unfortunately, it did not help. :( I tried both choosing all attributes and selected ones but it does not allow me to decompose in my dashboard. I have "Drill in" and "Copy" options only. Any other tips that may help?
Is the Decompose option not available on 'Sum' or 'Totals' in a report? or in a dashboard?
After I drill in or decompose and save, it's stuck. It won't revert to the original report.
Overall, these are wonky solutions.
Drill in and decompose shouldn't change the actual report without a confirmation to do so - and there should be a revert button to get back to the original report.
Yes, that right, that is the expected behavior. I'm afraid once you hit save, you won't be able to click on the Undo button to revert back to previous states. The Undo option only works for unsaved changes. Decompose essentially transforms your report, the same as manually adding attributes under Columns or Rows. And hitting Save after doing a Decompose saves the current state of the report with those additional attributes under Rows/Columns.
I didn't find an ongoing discussion yet on changing this behavior, but if you have time, I would suggest to start a thread in our Product Feedback topic in our Community, with the Product team regularly monitors, to engage with other users with the same needs.
Thank you, Flair!
I'm just wondering what would be the correct criteria for me to have the data for Time Chat Ended. The option to select Chat Started hour is available on decompose but not sure what will the criteria for Timestamp Chat Ended. Appreciate your assistance. Cheers!
There's no specific attribute for the chat ended timestamp, but you may try using the Chat updated - Timestamp attribute as an alternative. This attribute pulls the timestamp of the last update/event on the chat session – the Chat updated - Timestamp of a chat session that has already ended should give you the time the session was terminated/completed.
Please sign in to leave a comment.