Hi all,
We are calculating count of ID wrt frequency classification in low ,medium and high. (if less than 4 low, btw 4 to 14 medium and above 14 high). so there are 4 kpis where count of id in low, med and high freq must add upto Total freq kpi. now the ask is based upon the no of selection of month we need to classify the freq on the avg value of freq count for selected months and then count the ID distinctively. like if total is 10 then, low is 6 medium is 3 and high is 1
What should be the formula for this in chart level ?we are doing this calculation on the fly because user can choose any no of month.
below is the sample data
| ID | Month | freq class | Freq_Count | |
A | Jan | Med | 6 | |
A | Feb | High | 14 | |
A | Mar | High | 20 | |
B | Jan | Med | 10 | |
B | Feb | Med | 9 | |
B | Jun | Med | 7 | |
C | Jan | Low | 2 | |
C | Feb | Med | 5 | |
C | Apr | High | 15 | |
