Skip to main content
Nigel Smith 님이 #Tableau Desktop & Web Authoring에 질문했습니다

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개
  1. 2024년 2월 5일 오후 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.