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.
9 comments
Kai Schmitte
How can I show the name / label of the datapoint in the pie chart? Like showing the datatip for each segment permanently?
As soon as I need to show the data in a slide deck or similar, I can't use the datatip function to show more detail. And the legend is often too small and the colors are too similar to have a self-explanatory chart.
Currently I need to export to Excel and go from there. This seems like a really bad detour...
Thanks for your help.
0
Dane
Are you pertaining to this kind of format?
If yes, you can just remove the legend by going to Chat configuration > Displayed Values > Deselect "Display color legend".
Hope this helps!
2
Kai Schmitte
Dane:
Thanks for the help! Works.
Nice would be to have both options - the color legend + the callout text.
Best in the same way I can configure the mouseover datatips.
0
NIkita Kadri
Hi Team
We customized the pie chat colors from the Colors section, however it is not being picked in the chat legend. The Legend shows different colors. Is there a way to correct this?
0
Dane
I have created a ticket for you to look into this further. Please wait for my email and let's continue from there.
0
Denise von femSense
I am trying to figure out how to display the percentage of tickets with a certain tag. But everytime I select this individual tag, it just shows this tag as 100%.
It works when I add "ticket tag" as attribute, but as soon as I select an individual tag (for example "united_states") it adjusts the circle so, that this tag is used as 100%.
0
Nicole Jacobs
Is it possible to change the name of the label. For example in the first chart change the names of Task, Problem, Incident and Question. I am able to do this in the color legend but not when i disable the color legend and try to make changes to the names in the chart itself.
0
Lisa
To change the attribute labels in your pie chart, you could create a renamed set. You can do this by clicking on Calculations > Renamed Set and selecting your attribute under 'Computed from'. Enter the new name for each attribute value on the right. Replace the existing attribute with the new (renamed set) attribute in your report.
I hope this helps!
0
Jules Chan
Is it possible for "Column" Visualization Type to assign different colors per value? For example, I want to compare number of tickets for Service and Incidents per month. But upon using this Column Vis Type, it only shows 1 color for both Service and Incident counts. I wanted to show all Service with color blue, then Incidents would be red. Is it possible? It is showing me 1 selection of color only, based on SLA tickets metric. I can do it on other Visualization type.
0