Explore recipe: Ticket creation heatmap

Have more questions? Submit a request

17 Comments

  • Ed Soria
    Comment actions Permalink

    Hi Philippa,

     

    Just curious, is there a way to hide the the Count of Tickets values by making the font color the same as the heatmap colors? 

    Thanks

    0
  • Ed Soria
    Comment actions Permalink

    Made a very short just under 4 minute demo to illustrate a similar heatmap recipe for those that would like a video demo.

     

    Zendesk Explore Heatmap recipe demo

     

    1
  • Beth Yoder
    Comment actions Permalink

    How can I show the hours in a format that our agents can more quickly understand? Thanks!

     

    0
  • Shera Esquivel
    Comment actions Permalink

    Hello Beth!

    From the Time - Ticket Created section, add Ticket Created - Hour and click Apply. For more information, please refer to https://explore.zendesk.com/hc/en-us/articles/360002058067-Explore-recipe-Tickets-by-time-of-day-created.

    0
  • Brett - Community Manager
    Comment actions Permalink

    Hi Beth,

    It looks like Shera replied to your post here: https://explore.zendesk.com/hc/en-us/articles/360002062067?page=1#comment_360001556153

    Can you confirm you're able to view this?

    Let me know!

    0
  • Beth Yoder
    Comment actions Permalink

    Shera and Brett, 

    What I meant was that the hours (0-23) are not in a format that is suitable for our agents to quickly understand. I ended up creating a renamed set and an ordered set to display the times in the conventional 12 hour am/pm format. 

    Thank you

    0
  • Brett - Community Manager
    Comment actions Permalink

    Thanks for sharing Beth :)

    Let us know if you have any other questions!

    0
  • Fiona
    Comment actions Permalink

    Hi there

    My results aren't sorted by actual time. As a newbie, how can I order them by time in the left-hand column, and change it into time (10am or something identifiable).

    Thanks!

    Fiona

    0
  • Rob Stack
    Comment actions Permalink

    Hi Fiona, I'm a little surprised that your Ticket created - Hour metric isn't automatically sorting. However, you should be able to go to the result manipulation menu on the right hand side and select Sort.

    One way of getting the time to show in a more friendly manner is to create a renamed set. You do this from the Calculations menu on the right hand side and select Renamed set.

    Give the set a name like "Custom Ticket created - hour attribute"

    Under "Computed from", select the Ticket Created - Hour attribute, You'll see in the menu that you can type a new value for each attribute value (for example, "2" could be changed to "2am")

    Save when you are done, then use your new attribute instead of the "Ticket created - Hour" attribute.

    That's a bit of a lightning run through, but if you want to read more, take a look at https://support.zendesk.com/hc/en-us/articles/360022184334-Organizing-values-by-groups-and-sets

    I hope this helps!

    0
  • Fiona
    Comment actions Permalink

    Edit: I made a custom ordered set with the times I renamed. They are working for one of my heatmaps but not for the other. I tried to also sort that one by A-Z and it still puts 10am first, then 9am, 11am, 1pm, 2pm... If I choose Z-A though, it shows correctly but backwards.

     

    Thanks, Rob. I have made the renamed set as you suggested. However, I tried all the sort options and none of them make a difference to the table. I'm not sure what I'm doing wrong...

     

    0
  • Rob Stack
    Comment actions Permalink

    Thanks for the update Fiona. The ordered set was indeed the right way to go, but I'm unsure of why you're getting the behavior on one of your tables. If you can't find a way around it, I'd suggest you consider opening a ticket so someone can investigate this with you. Thanks!

    0
  • Fiona
    Comment actions Permalink

    Thanks, Rob, for your help. I'll make a ticket as I'm not sure what I'm missing. Thanks!

    Fiona

    0
  • Beno Siebenmann
    Comment actions Permalink

    Is there a way to customise RAG these heatmaps with values? Eg like insights

    https://support.zendesk.com/hc/en-us/articles/206381328-Insights-recipe-Ticket-creation-heatmap

    Cheers
    Beno

     

     

    0
  • Brett - Community Manager
    Comment actions Permalink

    Hey Beno,

    I'm a little confused on what values you're trying to customize. Can you provide some additional information on what you're trying to accomplish?

    Thanks in advance!

    0
  • Beno Siebenmann
    Comment actions Permalink

    Hey Brett,

     

    No worries,

     

    I'm after the ability to use these types of rules, where you can set different colour values per % value. and you can choose your hex colour values etc.

     

    E.g if 95% make it Green if 10% make it Red

    Below is an example of the gradient scheme that insight would allow you to use.

     

    • [>=.011][backgroundcolor=660011][color=660011]#%; [>=.01][backgroundcolor=99001A][color=99001A]#%; [>=.009][backgroundcolor=CC0022][color=CC0022]#%; [>=.008][backgroundcolor=FF002B][color=FF002B]#%; [>=.007][backgroundcolor=FF3355][color=FF3355]#%; [>=.006][backgroundcolor=FF667F][color=FF667F]#%; [>=.005][backgroundcolor=FF99AA][color=FF99AA]#%; [>=.004][backgroundcolor=FFCCD5][color=FFCCD5]#%; [>=.003][backgroundcolor=F7D4DA][color=F7D4DA]#%; [>=.002][backgroundcolor=F0DBDF][color=F0DBDF]#%; [<.002][backgroundcolor=ffffff][white]0; [=Null][backgroundcolor=ffffff][white]0

    0
  • Brett - Community Manager
    Comment actions Permalink

    Hey Beno,

    I contacted our Explore experts to see if this same functionality is possible with Explore. I'll keep you post on what I find out!

    0
  • Brett - Community Manager
    Comment actions Permalink

    Hey Beno,

    It looks like you can get similar functionality by using the chart configuration option mentioned here: Customizing your chart

    Hope this points you in the right direction!

    0

Please sign in to leave a comment.

Powered by Zendesk