Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I'm trying to calculate the difference between the number of customers at the min date of the selected period, and the number of customers at the max date of the selected period.
My idea is to perform an operation like this (but not sure it is a good solution): count(customers at max date) - count(customers at min date)
I've tried :
count({<Month={'=max(Month)'}>}distinct CustomerID) ...
and
FirstSortedValue(Aggr(count(distinct CustomerID),Month),-Month) ...
But it doesn't work.
Any idea?
Thanks!
hi
Are you using this in a text box or a chart?
Regards
Pratyush
hi
in a KPI
There's no problem with the method you're using, can you plz share a sample KPI.
Regards
Pratyush
Hi Julien,
Please try below one:
count({<Month={'=max(Month)'}>}distinct CustomerID) -count({<Month={'=Min(Month)'}>}distinct CustomerID)
Thanks,
Arvind Patil
I've already tested that
count({<Month={'=max(Month)'}>}distinct CustomerID) don't give the correct value
Regards