Calendar Heat Map

Question & Answer
,
1

Hi community,

I want to create a calendar heatmap in Amazon QuickSight. The objective is to visualize the cumulative sum of a time-series data with 15-minute granularity. The heatmap should have columns representing weekdays, rows representing days of the month, and the value within each cell should display the sum of the data for that specific day and weekday combination. How can I achieve this in QuickSight?

Thank you

2

Hi @FDelca

QuickSight has heat map visual.
For your scenario, create two calculated fields

  1. Day of Month : extract(‘DD’, {Order Date})
  2. Week day : extract(‘WD’,{Order Date})

Create a visual with Heat map visual type and add fields as shown in example below

image
image843×112 5.54 KB

You can create heat map with Week Day and Day of month as shown below

image
image763×508 26.5 KB

You can further convert weekday number with Name using Ifelse.

3

Hi Ashok,

Thank you for your reply,

I solve the issue by using again tables with conditional formatting instead of heat maps because of axis issues (they disappeared when the visual size is not big enough). However, what I was looking for was a calendar heat map (for each month), so I calculated the week of the month and instead of using the day of the month I use that calculated field instead.