Hi!
I have planned to make a heatmap as part of a dashboard. This is the dashboard as of now:
The dashboard should view the data each day, counting between the hours of 5 and 23. However, in this sample, there seems to be missing hours within that data (particularly between 17-20).
I am unsure of what to do by then, but after researching, there was a particular function of showing "empty rows". However, this happens instead:
I want to ask if there is any formidable way to show EVERY HOUR regardless of the missing values per minute. If not, then is there any alternative so that I can specifically focus on minutes that have an actual value?
(Do note that there is a chance values outside of the 5-minute interval appears; e.g., minutes 1, 6, 16, 36)
PS: Upon checking another chart, I have found out that in between 17-20, there are basically missing/"special" data. These data is labelled as 0:
Hi @Chris Geatch !
No need to find a solution, I have already solved the issue I have! For those who wants to know:
- Create a new Custom Date of Timestamp, and use "Exact Date" as the Detail [name it as e.g., Time for Min] .
- Afterwards I made use of the new Timestamp and right-click and drop in under Columns, as "Minute (Time for Min)".
- Then, using the first Timestamp, right-click and drop in Rows, as "Hour (Timestamp)"
- Lastly, proceed to right click the blue pill "Hour (Timestamp)" and enable "Show Missing Values".
