Creating a heatmap using hourly time values

[SET_Padawan]

Hello! Would like to create a heatmap (using the grid visualization) that uses time values as a dimension. 

The first dimension (y-axis) would be a simple category, while the second dimension (x-axis) would be the hours of one day (so 0:00 to 24:00). 

Any ideas on how I could go about creating this? First thought that came to mind was I could create a calculated field to sort the timestamp field into the hourly buckets (if 13:45 then 13:00), but that might be inefficient. Thanks in advance for the help?

[justISO]

Hi, have you tried to represent your time just in hour format? Like: time(your_time_dim, 'hh')

[SET_Padawan]

Thanks for the suggestion! Didn't quite work unfortunately. I'm thinking I'm going to need a master time calendar or something. 

[SET_Padawan]

I was indeed able to make a "master calendar" work, although what I did was basically hard code numbers 0 to 23 in the load editor, created a calculated field on the fact table that was Hour(Timestamp), and named them both the same name so they would be associated. Not a great look honestly but whatever.