topic Re: "Indexed values" in App Development

"Indexed values"

flemmingbj — Tue, 30 Nov 2021 11:50:11 GMT

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

Re: "Indexed values"

chrismarlow — Tue, 30 Nov 2021 17:04:31 GMT

Hi,

Maybe try a total in the denominator? So;

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

Cheers,

Chris.

Re: "Indexed values"

flemmingbj — Tue, 30 Nov 2021 18:01:41 GMT

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