topic Creating a heatmap using hourly time values in App Development

Creating a heatmap using hourly time values

SET_Padawan — Mon, 31 Jul 2023 08:02:05 GMT

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?

Re: Creating a heatmap using hourly time values

justISO — Mon, 31 Jul 2023 08:50:51 GMT

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

Re: Creating a heatmap using hourly time values

SET_Padawan — Fri, 04 Aug 2023 03:46:47 GMT

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

Re: Creating a heatmap using hourly time values

SET_Padawan — Fri, 04 Aug 2023 06:26:44 GMT

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.