Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to make a chart, with YearMonth on the X-axis showing "indexed" values, that is the count per month compared with a baseline (in this example January 2019).
I use this formula to show the values per YearMonth:
count(distinct Id)
But when I try to compare all the values to January 2019 with the formula below, it only shows the value for January 2019 divided by the value for January 2019 - all the other YearMonth's are 0...!
(count(distinct Id)) / Count(distinct if(YearMonth='jan.-2019', Id))
Hi,
Maybe try a total in the denominator? So;
(count(distinct Id)) / Count(total distinct if(YearMonth='jan.-2019', Id))
Cheers,
Chris.
Hi,
Maybe try a total in the denominator? So;
(count(distinct Id)) / Count(total distinct if(YearMonth='jan.-2019', Id))
Cheers,
Chris.
Yes, that works! Thanks! I tried it, but I must have misplaced the "total" 🙂