Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Even I found a lot of examples here, nothing could solve my problem. Need the Count diffences from one month to previous month. Tried something like that (DatumId is my Date):
Count(Distinct {$<month(DatumId) = {$(=Max(month(DatumId)) -1), State={'aktiv'}}>} Key])
Instead to show the total number of Distinct Keys per Month, would like to show only the difference to previous month.
Hi,
Please try
Count(Distinct {$<month(DatumId) = {$(=Max(month(DatumId))), State={'aktiv'}}>} Key])
-
Above(Count(Distinct {$<month(DatumId) = {$(=Max(month(DatumId))), State={'aktiv'}}>} Key]))
Thanks for your help.
Did try, but doesn't look good. It shows only one month and the the chart is empty. Did also try with Monthend function: