Explore recipe: Working with stacked charts

Return to top

18 Comments

  • Perry

    I feel like an idiot, but my chart using a custom field won't stack! What might I be doing wrong?

    0
  • Dailymotion Support

    Hello Perry,

    Could you please try the following steps ? :

    • Go to Zendesk Explore et search for the query you would like to stack
    • Click on Edit configuration
    • Click on Chart
    • Tick the Stacked box

    It should work now :) Also, if you want to remove the Row selector, you can easily do it with these steps: 

    • Click on Edit configuration
    • Click on Row selector
    • untick the row selector box
    0
  • Perry

    Did that. No stack! I suspect it is my query setup not the mechanic of stacking.

    What I am trying to get is monthly bars showing the break-down by category as a stacked bar. I can get monthly with the breakdown unstacked, but nothing better.

    0
  • Dylan Tragjasi
    Zendesk Customer Care

    Hi Perry - I'm going to reach out to you directly in a ticket so we can take a closer look and see what might be going wrong here. We'll be in touch very shortly via email!

    0
  • Barbara Brauner

    Hi, is there a way to have the Row Selector select all of the options at all times? What happens in my queries is that when a new option is added (e.g. because new agent is added etc.) this option will not be automatically included in the Row Selector selection. Any solution for this?

    Thanks.

    0
  • Elaine
    Zendesk Customer Care
    Hi Barbara,
     
    Can you confirm what you meant about "when a new option is added"?
     
    Are you referring to a new field value being added in the actual ticket field and you expect that it would also be added automatically in the selection list?
     

     
    Or are you referring to an existing value in a custom ticket field and upon selecting/including this value, it does not show up automatically in a query?
     

    0
  • Barbara Brauner

    Hi Elaine,

    Thanks for your response.

    I'm referring to a variation of the first option: I've selected all "assignee names" in the row selector and when later on a new agent is added and also getting tickets assigned, they are showing up in the row selector, but not being automatically selected.

     

    0
  • Elaine
    Zendesk Customer Care
    Hi Barbara,
     
    Upon further checking, the reason why you're not seeing the newly added Assignee names in the Row Selector as automatically selected is that the Row selector's default option is the "Selected values".
     

     
    The reason behind the default option as "Selected values" and not "Select all" is to avoid slowing down the query in case there are a lot of values in an attribute that our customers would use in the Row section of the query and we think that it is the most appropriate for such cases.
     
    If you want more Assignee names to be selected as you go and edit this query, kindly go into Chart configuration > Row Selector, and under the Selected position, choose the Select all option manually. In that way, you'll see that the filtered-out Assignee names in the query are automatically selected moving forward.
     

     
    Don't forget to Save the query every after recent changes on the query. Hope this helps! Stay safe! (:
    1
  • Barbara Brauner

    Very helpful, thanks a lot Elaine!

    0
  • Ana-Alicia Siqueiros

    I am running into the same issue as Barry. Can you help me @...?

     

    0
  • Barbara Brauner

    Hi Ana-Alicia, if you've followed Giovanni's steps from above, you just need to click on "Ticket Channel" in the top left corner (below "Filters (1)"). That will show all channels stacked on top of each other.

    1
  • Ana-Alicia Siqueiros

    Amazing!! Thank you Barbara!

    0
  • Alfie Penfold

    Hello - I'm running into the same issue as Perry above: Selecting "stacked" as an option, but the chart remains unchanged.

    I have a custom "ticket type" field selected, but believe it should still work.

    Any help would be appreciated.

    0
  • Gab Guinto
    Zendesk Customer Care
    Hi Alfie,

    Can you check if all the values or if multiple values are selected under the row selector? Example:

    Selected values are highlighted in grey. If only one value is selected, the chart will not be displayed as stacked values.
    0
  • Lauren Tucci

    Mine also did not stack after following these directions. Wondering what I'm missing...

    0
  • Gabriel Manlapig
    Zendesk Customer Care
    Hi Lauren,

    Can you send us a sample screenshot of your report query? Also, please make sure that the option Chart configuration >> Row Selector >> Selected position is set to Select all.



    Since, If only one value is selected, the chart will not be displayed as stacked values.



    I hope that helps. Thanks!
     
    0
  • Namah Vyakarnam

    Is it possible to ONLY have the total number of all selected rows show at the top of the stack, and not have any of the other numbers show for each individual color?

    0
  • Gabriel Manlapig
    Zendesk Customer Care
    Hi Namah,
     
    Yes, this is possible. Please go to Chart Configuration >> Displayed Values >> Show value, and select Hide.
     
    For reference, please see the below screenshot.
     
     
    I hope that help. Thank you!
     
    0

Please sign in to leave a comment.

Powered by Zendesk