I’m trying to create a sales heatmap using ORDER_DATE datetime field.
I want the Y axis to show the time of day (aggregated by hours) and the X axis to show the date part and the measure is the count of ORDER_NUMBER
the problem is that I can’t add the same field twice to the heatmap visual. As a workaround, I created a calculated field that returned the time part from ORDER_DATE and called it TIME:
I was able to add that to the visual and here is what I have got:
you can see here that the time dimension is not being truncated and this is why I got this diagonal regions:
What is the way to do it?