Creating a stacked chart in Zendesk Explore involves a few steps to enhance the readability of your data. First, navigate to Explore and click the Queries icon, then select New report. Choose the dataset containing your ticket data, such as Support - Tickets, and start your report.
Add your metrics, like the number of tickets created, and apply them. Then, add attributes to the Columns panel, such as Time - Ticket solved by Year. In the Rows panel, add attributes like Customer satisfaction > Ticket satisfaction rating. Finally, configure the chart to be stacked by selecting Stacked from the Chart configuration menu. This will group the rating columns together, creating a cleaner stacked column chart.
A stacked chart is a type of chart that breaks down each bar or column into subsections of the total. This is particularly useful for visualizing which items have the most influence on a category total. For example, in a column chart displaying…
Zendesk Explore offers several advanced settings for stacked charts to customize your data visualization. In the Chart configuration menu, you can access options like turning stacking on or off, aggregating values, displaying percentages, and…
Yes, you can display total values above bars without stacking them in Zendesk Explore. To do this, open the configuration menu and select 'Display Values'. Then, click the box at the top to change it to 'Show'. This setting allows you to see the…
Yes, you can create a 100% stacked chart in Zendesk Explore to display data as percentages of the total. First, display your data in a table as percentages using Result manipulation → Result path calculation. Then, switch the visualization type to…
Unfortunately, sorting stacked chart elements by quantity is not currently available in Zendesk Explore. Sorting results is only possible in Table Visualization. If this feature is important for your use case, consider creating a Community post to…