If you are analyzing how your individual values equate to the total result, Explore offers visualization that can help you easily display your data. For example, you can use these charts to evaluate which groups are solving the most tickets or what combination of values is producing the highest numbers.
Pie chart
Pie charts can be constructed in two ways:
- A metric broken down by category results (attributes).
- Multiple metrics making up a natural whole combined metric. For example, percentage share and an overall total.
Pie charts work best when displaying a relatively small number of results, but you can still display several results in a simple way using the available customization options.
One option is to add a color legend in Chart configuration > Displayed values, then select Display color legend. The color legend will display all of your added attribute values, and enable you to view individual value results by hovering over the label.
You can also apply a top/bottom filter to limit results to the largest ones. This filter can also combine smaller results into a single segment, so your percentage share and total figures will remain in the same view.
If you would like to see several results at the same time, a treemap or bar chart might be a better approach.
- In Chart, you can check Combined metric to create a doughnut view. A doughnut view segments your pie chart, so all metrics are divided by every value. An empty circle will appear in the middle of the chart.
- In Colors, you can change the background and chart colors.
- If you want to display your results as percentages, you can change your value options in Display format > Edit displayed values. You can also change label position, style, and display a color legend in Displayed values.
Sunburst chart
A sunburst chart is a combination of a pie chart and a treemap. Results are segmented by category and displayed in a hierarchy. If you have several results, the labels for smaller values might not appear on your chart. Like a pie chart, the top/bottom filter can be used to aggregate these smaller results.
- In Colors, you can select a predefined color palette to represent your categories and subcategories.
- In Chart, you can select whether to show or hide metric aggregators in your datatips, by toggling the Show aggregators check box.
8 Comments
None of the examples in this article show percentage over time. I just want to say "this percentage of support tickets were flagged by the technician as feature requests or bugs or general support over time".
Something like the following comes to mind:
https://kb.tableau.com/articles/howto/stacked-100-percent-bar-chart
But I'm open to other ways too.
Hi Angela,
I'm going to create a ticket on your behalf and send through some detailed steps on how you might go about achieving this.
I'll be in contact very shortly within the ticket and we can continue from there!
I need to have the data label in the pie chart and not on a legend. Explore makes the legend scrollable which I can't use because when I export it to a pdf the legend is cut off. Apparently if there are too many data points this is what happens in a Dashboard.
How can I do this?
Hello Larry!
To achieve this, you may use the sunburst chart, which is a combination of a pie chart and a treemap. Results are segmented by category and displayed in a hierarchy. For more information, please refer to https://support.zendesk.com/hc/en-us/articles/360022184074#1.
Have a nice day!
In a Pie Chart, the answer to my question is actually to de-select "Display color legend" in Displayed Values. Then choose "Label position" as "Inside".
Hello Larry!
Thank you for this tip and I apologize for misunderstanding your inquiry, however, if you need more information regarding chat configuration, please refer to this article:
Customizing queries
Have a wonderful day!
Option to display data labels in the chart should be available in all charts. Especially on pie charts, etc. Asking people to use sunburst is a really bad workaround. I thought that Zendesk can do more. In comparison to other reporting tools, its cumbersome and incomplete.
Hi Jiri Kanicky thanks for this great feedback. Please would you consider posting this in our feedback section at https://support.zendesk.com/hc/en-us/community/topics/360001200913
That way, it will be surfaced to members of the product team and other Explore users can vote for it. Thank you!
Please sign in to leave a comment.