Recent searches


No recent searches

Creating a 100% Stacked Bar Chart

Answered


Posted Apr 16, 2019

Hello,

I'm trying to set up a stacked bar chart where every column/row adds up to 100%, in order to visualize proportions. I want to compare the percentage of tickets we get by Product Module (custom field of ours). However, I can't find any options to do so, neither in x-axis nor y-axis options in the Chart Configuration sidebar. See below for an example.

Any help would be appreciated!


0

6

6 comments

Official

Hi Chen

Check that all the results for the attributes you have on rows are selected - otherwise you might be missing one or two! This can happen if new results appear in the dataset after the query is set up and the selection made. You can fix it in the chart configuration menu, row selector section, where you can show and hide the selector, and also specify that you always want it to show all values using the 'selected position' menu. 

Hope that helps - if it doesn't explain the situation, send us in a ticket so we can have a look at what is going on.

Philippa

0


image avatar

Greg Katechis

Zendesk Developer Advocacy

Hi Josue!

You can do this by going to the Chart Configuration icon (it's a paintbrush) and then select "Chart" and set the values like this:

 

After you've done that, you'll go to "Display values" and set it like this:

After you've set up your date values as a column and your ticket field as a row (along with your metric), you should have something that looks like this:

Note that I had a very low volume of tickets that showed useful numbers, but hopefully this is what you're looking for!

0


I'm also experiencing this issue when looking at % one-touch tickets, % two-touch tickets, % multi-touch tickets by week. I'm not seeing a way to have this be a 100% stacked chart as it's showing the weekly ticket count as the X axis. Any ideas? 

0


Is there a way to get the total figure inside the metric so it says 24 Tickets for e.g. ?

As you can see this looks rubbish unless im doing something wrong

 

0


image avatar

Eugene Orman

Zendesk Product Manager

@Carolyn, I suggest to use the Tickets solved metric with the Agent replies brackets attribute instead of the % metrics for your set up. It will allow creating a chart like this: 
Demo: https://cl.ly/82d547114a38  

@Jeremy, it is not possible to adjust the position of the total values yet. That's why white is not the best color for the values if you are using the totals option. Try using another color. 

 

0


Hi Josue

You can change the presentation of numbers, eg from number of tickets to % of total, using a result path calculation, from our result manipulation menu

In your example, you would set the query up with the product on 'rows', so you need to specify this as the 'path' in the settings - see screenshot. 

Philippa

 

 

 

2


Post is closed for comments.

Didn't find what you're looking for?

New post