Hello Everyone,
I am facing an issue with distinct customer counts in a single value KPI tile when using period_over_period measures.
I have a measure for
Distinct customers (count_distinct)
LY customers using period_over_period
YoY % using period_over_period
This works correctly when I filter for a single month.
Problem : When I select multiple months (exp- full year)
Monthly distinct customers = ~1.5M
Expected yearly distinct = ~3M
But KPI shows = ~17M (sum of monthly distincts)
and If I remove date dimension - PoP breaks and produces fanout / incorrect results
Any recommended way to build a single KPI tile for Distinct customers? - For revenue, I think this is fine anyway, we want to have sum but for customer we would always want distinct.