Heat Map from Matrix, using Months as Columns, across several years?

Responsive Resident

2 years ago

Hi Anonymous

Apologies for the belated reply. Here is some more detail. The two screenshots below both have three elements:

A small table of data, in this case simply showing dates and a count of contact_sk through time
A Matrix / heat map
A column chart showing the distribution of contact_sk over time

Both the matrix heat map and the column chart use the same data, but only the column chart shows it in a way that takes different years into account.

In the first screenshot, the time range is set to only 1 Jan 2023 to 31 Dec 2023, and both the column chart and heat map show results as I would expect. But when I expand the time range to include 2022 as well, on the bottom screenshot, only the column chart shows the desired result. The heat map condeses the months, so it sums the counts of contact_sk from January 2022 and January 2023, etc, and I cannot find a way to enable date hierarchy in the same was as I would in the column chart.

I hope the below screenshots explain my predicament:

Screenshot 1 - only 2023