Using stacked charts to display results

Return to top

15 Comments

  • Darren Taylor

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

     

    0
  • 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
  • Darren Taylor

    Perfect, thank you @... 

    1
  • LaReine Pia

    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
  • tina y

    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
  • Adam Hanna

    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
  • 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
  • Nicole

    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
  • 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
  • James Harris

    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
  • 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
  • Ben Wright

    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

    1
  • Larry Click

    The very question I wanted to ask Ben Wright.

    0
  • 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
  • Carlotta Bartoloni

    Hi,

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

    best regards

    Carlotta

    0

Please sign in to leave a comment.

Powered by Zendesk