Insights recipe: Ticket creation heatmap

Have more questions? Submit a request

13 Comments

  • David Ykema
    Comment actions Permalink

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

    0
  • Erin Willis
    Comment actions Permalink

    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?

    0
  • Billy Macken
    Comment actions Permalink

    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!

     

    0
  • Erin Willis
    Comment actions Permalink

    All good, William! Thanks for updating  😄

    0
  • Justin Lentz
    Comment actions Permalink

    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? 

    0
  • Eugene Orman
    Comment actions Permalink

    @ 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. 

    0
  • Miriam Rothschild
    Comment actions Permalink

    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!

    0
  • Kayla Schmidt
    Comment actions Permalink

    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. :)

    0
  • Riah Lao
    Comment actions Permalink

    Hi, I added Sum and Average on the column. The color formatting is also applied to those...

    0
  • Jessie Schutz
    Comment actions Permalink

    Hi Riah!

    I'm not sure what you're asking. Is what you're seeing not what you expected?

    0
  • Riah Lao
    Comment actions Permalink

    Hi Jesse, I expect the color formatting to be only applied  to the main columns and not the Sum/Average columns

    0
  • Jessie Schutz
    Comment actions Permalink

    Thanks for clarifying, Riah!

    I believe what's happening here is that the heat map report format isn't built to to automatically exclude any additional columns from being colored. The assumption is that if you're adding a column to the heat map you want to see how those values compare to the other values in the report.

    Can you tell me more about why you want those values included but not colored in? There might be another solution.

    0
  • Riah Lao
    Comment actions Permalink

    Hi Jessie, because if I put in values for the range, the Sum will always be meeting the max value and it just looks off.

    0

Please sign in to leave a comment.

Powered by Zendesk