date -1

zied_ahmed1 — Tue, 30 Mar 2021 07:53:41 GMT

Hello,

I have a field named date with two dates (for example 18/03/2021 and 15/02/2021)

I need to create a kpi with the value of every date

i used in the set analysis :

Count(distinct{<date= {"$(=max(date))"}>}name)

to retreive the value of 18/03/2021

But when i use max-1 it gives me 0 because max-1 for him is 17/03/2021

any suggestions please ?

Thanks

Re: date -1

tresB — Tue, 30 Mar 2021 07:57:25 GMT

Try using rank parameter in max(), like:

Count(distinct{<date= {"$(=max(date , 2))"}>}name)