Why isn't my heat map data grouping by day of week?

jennih_acc
jennih_acc Member
in Charting

I am working on visualizing ticket data and created two fields: one returns the hour of the day and the other returns the day of the week. However, when I try to create a heat map, it's just listing days, and not combining them. How can I get it to combine the days of the week into columns so I can see which days and times are most common for ticket creation?

heat map.png

Best Answer

  • ColemenWilson
    ColemenWilson Coach
    edited September 12 Answer ✓

    Do you have any sorting applied to your card? Is your field set to some kind of aggregation like Count? It would be helpful if you could include a screenshot of your analyzer setup.

    If I solved your problem, please select "yes" above

Answers

  • ColemenWilson
    ColemenWilson Coach
    edited September 12 Answer ✓

    Do you have any sorting applied to your card? Is your field set to some kind of aggregation like Count? It would be helpful if you could include a screenshot of your analyzer setup.

    If I solved your problem, please select "yes" above

  • jennih_acc
    jennih_acc Member

    ooooh sorting! That fixed my problem, thanks so much!

Categories