Insights recipe: Ticket creation heatmap Follow

Comments

8 comments

  • Avatar
    David Ykema

    I found that the values needed to be .0# rather then 0.0#.

  • Avatar
    Erin Willis (Edited )

    For the How attributes, I have the Day of Week (Mon-Sun) (Ticket Created) but I do not see any attribute for Created at Hour. Is that a custom attribute? 

     *Edit: 

    I think it might actually be called Hour Ticket Created instead of Created at Hour?

  • Avatar
    William Macken

    Hi Erin,

    Sorry for the delay-- you are correct that Hour Ticket Created would be the correct replacement for the Created at Hour attribute listed currently. I'll make a note about updating the article. Thanks for pointing that out!

     

  • Avatar
    Erin Willis

    All good, William! Thanks for updating  😄

  • Avatar
    Justin Lentz

    This is a very useful heatmap, however I have received requests to also show the number of tickets that were created for each hour as well. I can add # Tickets to the What portion of the report, however that puts the ticket numbers in a separate column, thereby making the heatmap much harder to digest. Is there a way to have the colored heatmap with the number of tickets showing up in the colors themselves? 

  • Avatar
    Eugene Orman

    @ Justin, 

    If you don't want to add additional metrics to the report you can make the percentage visible, now it is hidden because the font color is set to the same color as the background. You can update this in the number format editor. 

     

    For example,  if you want to set the font as white use this color coding: 

    [>=.011][backgroundcolor=0A1F33][color=000000]#%;
    [>=.01][backgroundcolor=143D66][color=000000]#%;
    [>=.009][backgroundcolor=1F5C99][color=000000]#%;
    [>=.008][backgroundcolor=297ACC][color=000000]#%;
    [>=.007][backgroundcolor=3399FF][color=000000]#%;
    [>=.006][backgroundcolor=5CADFF][color=000000]#%;
    [>=.005][backgroundcolor=85C2FF][color=000000]#%;
    [>=.004][backgroundcolor=ADD6FF][color=000000]#%;
    [>=.003][backgroundcolor=D6EBFF][color=000000]#%;
    [>=.002][backgroundcolor=EBF5FF][color=000000]#%;
    [<.002][backgroundcolor=ffffff][white]0;
    [=Null][backgroundcolor=ffffff][white]0

     

    Screenshots: 

    The repot will look  like this:

     

    However, there is no way to display a number of tickets instead of the percentage via the same metric. 

  • Avatar
    Miriam Rothschild

    Hi, I am trying to make this report, however the color portion is not working. No matter what the number is, it is the same color. Do you have any suggestions? Thank you!

  • Avatar
    Kayla Schmidt

    Hi Miriam! Are you using both Day of Week (Sun-Sat) (Ticket Created) and Hour Ticket Created for your attributes? If you've followed the article instructions and are still not seeing what you expect, send us a ticket directly with a link to your specific report so we can check out your account and have a look. :)

Please sign in to leave a comment.

Powered by Zendesk