Recent searches


No recent searches

Using stacked charts to display results



image avatar

Rob Stack

Zendesk Documentation Team

Edited Jun 21, 2024


2

19

19 comments

Is there anyway to show the total value above the bars without stacking them?

 

0


image avatar

Chris Bulin

Community Moderator

Hi Darren Taylor! There is definitely a way to do this. You'll want to open the configuration menu and select "Display Values" and click the box at the very top to change it to "Show". It looks like this:

0


Perfect, thank you @... 

1


Hello! I am trying to get the chart to stack but I am not able to. I included screenshots below. Can you please see if I am setting anything up incorrectly?  I want our type of checks to all show on the same graph instead of the separate sheets. 

 

0


Hi LaReine Pia, you will see it stacked if you click on the attribute title of Type of Check, the above shows you are only looking at Manual Check.  You may want to scroll through the above comments for other hints as I had a similar question.  Hope that helps.

1


Is there a way to have stacked bars for multiple attributes? When adding the extra metric it is just making one huge stacked bar (second picture) instead of two side by side as desired (example in first picture)

0


image avatar

Gab Guinto

Zendesk Customer Care

Hi Adam,

I'm afraid there's no option to separate the two metrics into two bars in a stacked chart. If you select Stacked in your chat configuration, the metrics sliced by the row attribute will be stacked into a single column. Sorry about this, Adam.

0


Is there a way to do a stacked 100% chart? Where instead of seeing the total number you see the columns as a percentage to total? 

Ala: 

Week 1, A 50% of total B 50% of total

Week 2, A 60% of total B 40% of total

 

The goal would be to show relative percentages over time. Please view this article: https://exceljet.net/chart-type/100-stacked-column-chart

I have already tried stacked percentages, that is not the functionality I am looking for. 

 

0


image avatar

Gab Guinto

Zendesk Customer Care

Hi Nicole,

You can try displaying the data first in a table as percentages via Result manipulation → Result path calculation, with the following parameters.

You can then switch the visualization type to Columns and display it as stacked. The chart should be shown as stacked percentage values.

0


I'm after the same functionality as Nicole I think but struggling. 

This is my table with values:

I want to display the percentage totals of those values against each row. So if we take December, we can see we have 51 + 66 tickets in total (117). I want display the two numbers as percentage totals of 117. When I set the Result Path Calculation to '% of Total' and 'On Rows', Explore calculates each entry as a percentage against the total number of results in my entire query, leaving me with this (which tells me nothing):

It's driving me round the bend but I'm sure I'm missing something really obvious!

0


image avatar

Gab Guinto

Zendesk Customer Care

Hi James,
 
From your screenshot and based on your description, it sounds like the result path is based on whole result of the table. Can you check again the path selection? If you need the percentage displayed to be based on the total of the values for each column (example, for December row, 51/117 and 66/117) then Path must be set to On columns. Here's a sample:

0


Is there a way to sort the stacked elements by quantity? E.g. highest value in column is on the bottom, smallest value on the top

2


The very question I wanted to ask Ben Wright.

0


image avatar

Dane

Zendesk Engineering

Hi Ben and Larry,
 
I have tested it thoroughly on the Stacked Columns. As it turns out, sorting results is only available in Table Visualization. I'd recommend creating a Community post separately for that with your use case to help get more visibility and votes on the idea. Then, others can share their use cases to further drive demand for that feature. 
 
I hope this answered your inquiry.

0


Hi,

is it possible to insert the second decimal place to percentage of the stacked chart?

best regards

Carlotta

0


What is the meaning behind this bar in the example you provided? I use column charts a lot and it's not clear to me what the far left bar represents in the chart.

0


image avatar

Rob Stack

Zendesk Documentation Team

Hi, Allyson Luber. Thanks for pointing this out. The extra bar you were seeing was, in fact, an error. I've corrected it, and I've updated the screenshots. You'll need to refresh your browser to see the new screenshots.

1


Hi, Rob Stack. Thanks for your response! What does that extra bar represent? When I'm making charts I always see that same extra bar, usually with some sort of value, but with no clear representation of what it means.

0


image avatar

Rob Stack

Zendesk Documentation Team

Hi Allyson Luber I took a closer look at this. The extra bar, in this case, represents tickets that don't fall into any “Ticket solved - year” bucket (to all intents and purposes, unsolved tickets). For this report, I can remove that extra column by changing the metric to “COUNT(Solved tickets)”
Even then, you'll still see white space where the extra column was. You can remove that from the Result manipulation menu by selecting Hide part of your result, then hiding the first column.
I hope that helps, and happy holidays!

0


Please sign in to leave a comment.