date -1

[zied_ahmed1]

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 

[tresesco · Accepted solution]

Try using rank parameter in max(), like:

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