Skip to main content

I have a table showing the number of changes taking place per day per "Change Area" as follows:

 

Maximum of daily count across entire table, rather than row 

imageI want to colour each cell, based on how the number of changes for that day / change area compares with the maximum daily change count for that change area.

 

I've created a calculated field PercentageMax:

COUNT([Change Reference])/WINDOW_MAX(COUNT([Change Reference]))

and am using this to colour code the cells, which is working to an extent, but the maximum being used is the maximum for that change area for that month only (a single row). What I need is the maximum for that change area for the whole year / table.

 

I've experimented with changing the calculation order for the table calculation, but nothing is giving me quite what I need.

 

Thanks in advance!

6 risposte
  1. 5 feb 2024, 12:14

    I think you just need to set the direction of your table calculation correctly. It should run along your two date fields, that will give you the maximum, across all dates, within each category.

    I think you just need to set the direction of your table calculation correctly. It should run along your two date fields, that will give you the maximum, across all dates, within each category.