"Indexed values"

[flemmingbj]

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)) 

[chrismarlow · Accepted solution]

Hi,

Maybe try a total in the denominator? So;

 (count(distinct Id)) / Count(total distinct if(YearMonth='jan.-2019', Id)) 

Cheers,

Chris.

[flemmingbj]

Yes, that works! Thanks! I tried it, but I must have misplaced the "total" 🙂