Hi,
I am looking into creating a grid chart (heatmap) that will display products on the Y-axis and year-month on the X-axis. The measure is sales.
I would like the colors of the heatmap to only evaluate per product. Not the whole chart.
The chart will be used to see if any product has for example low/high sales, missing sales (due to problems with invoicing etc)
Example
| |
2023-04 |
2023-05 |
2023-06 |
2023-07 |
2023-08 |
2023-09 |
| Product A |
30 |
50 |
40 |
50 |
50 |
60 |
| Product B |
10 |
30 |
40 |
40 |
30 |
50 |
| Product C |
100 |
200 |
400 |
200 |
400 |
600 |
| Product D |
50 000 |
60 000 |
70 000 |
60 000 |
60 000 |
90 000 |
In this case 2023-04 that has the lowest sales (per product) and should have the same colour if I manage to make the chart evaluate per dimension.
Any idea of how to manipulate the chart to do this?
Kind regards Jonathan
