Grid chart evaluate per dimension

Jonathan_Alm — Tue, 12 Sep 2023 06:25:08 GMT

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

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

topic Grid chart evaluate per dimension in App Development