Comparing values to total results

Follow

If you would like to see how your individual values equate to the total result, there are chart types that can display the number or percentage each value contributes to the total attribute result. For example, you can use these charts to evaluate which categories are retrieving the highest number of sales or what combination of values is producing the highest numbers.

This article discusses the following chart types:

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 per segment 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 adding a color legend in Chart configuration > Displayed values, then selecting Display color legend. The color legend will display all of your added attributes' 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.

When you select a pie chart, you can edit the following options in the Chart configuration menu:
  • 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

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.

When you select a sunburst chart, you can change the following options in the Chart configuration menu:
  • 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 checkbox.

Chord chart

Chord charts can help you analyze the relationships between attributes and the results those relationships produce. In a chord chart your different attribute values are connected by arcs. You can use these arcs to determine the result when a metric is sliced by the two different values combined. For example, if you are measuring the sales from each of your products in all of their different colors, you could use a chord chart.

Note: Your metric results will be displayed in datatips. If you do not see datatips, you might have to check the Show datatip box in Chart configuration > Datatips.

You can hover over a value name to view all of the connecting arcs. If you would like to see how two values slice the metric together, you can hover over the arc. For example, the image below shows Revenue sliced by Gray Phones.

When you select a chord chart, you can edit the following customization options in the Chart configuration menu:
  • In Chart, you can change the amount of white space between the attribute values by entering a new number in Padding between groups. You can reorder how the arcs are listed in the Subgroup ordering drop-down list. You can also set the width of your arcs by entering a new number in Arcs thickness.
  • In Colors, you can edit the background color, line color surrounding each value box, and the colors representing each value.
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk