A stacked chart breaks down each bar or column in a chart into subsections of the total. For example, if you've created a column chart displaying tickets by ticket type, you could further break each column down by ticket priority. This can be particularly useful when you want to see a visual representation of which items are having the most influence on a category total.
Tickets by ticket type column chart
Tickets by ticket type column chart broken down by ticket priority
In this recipe, you'll learn how to create stacked charts and work through an example.
What you'll need
Skill level: Easy
Time Required: 5 minutes
- Zendesk Explore Professional
- Editor or Admin permissions (see Adding users to Explore)
- Ticket data in Zendesk Support
Creating a stacked chart
In this example, you'll create the stacked column chart from the introduction to this article. The chart shows the number of tickets by type (question, incident, problem, or task) and then breaks this down further by the ticket priority (low, normal, high, or urgent).
To create the stacked chart
- In Explore, click the query ( ) icon.
- In the Queries library, click New query.
- On the Choose a dataset page, select the dataset containing the ticket data you'll need to build the query; in this case Support: Tickets, then click New query.
Query Builder opens.
- Next, add your metrics, the things you want to measure; in this case, the number of tickets created. In the Metrics panel, click Add.
- From the list of metrics, choose Tickets > Tickets, then click Apply.
Explore displays the number of tickets in your Zendesk Support instance.
- In the Columns panel, click Add.
- From the list of attributes, choose Ticket > Ticket type, then click Apply.
Explore displays the number of tickets broken down by ticket type. If the chart is not displayed as a column chart, you can change this from the visualization type menu ( ).
- In the Rows panel, click Add.
- From the list of attributes, choose Ticket > Ticket priority, then click Apply.
Explore displays the number of tickets broken down by ticket type. Using the row selector, you can select which ticket priorities to display though often, you'll click the row selector heading to select all rows. Each priority displays as a separate column on the chart. Next, you'll group these priority columns together to create a cleaner looking stacked column chart.
- From the Chart configuration menu ( ) , click Chart.
- On the Chart page, select Stacked. Make sure the other options on this page are not selected.
Note: To find out more about the other stacking options, see Using stacked charts to display results.
Explore displays the column chart with the values for ticket priority stacked together.