Top Filter of filtering date using calculated field

Q&A
, ,
1

How to add top filter of date in groups like ‘less than last 3 months’, ‘last 3-6 months’ and ‘greater than 6 months’ using calculated field

2

Hi @Shalini
you could create the field with ifelse and check if the date in your data is falling into one of the groups. You could then create a filter for the groups to select one or many.

Maybe you can use

And datediff with month or days

BR

3

so, how we select the date like less than 3 months etc in ifelse condition
like ifelse(Date< ??

4

Something like

Ifelse(dateDiff(date, now(), “MM”)<=3,“less than 3”, Ifelse(dateDiff(date, now(), “MM”)>=3 AND dateDiff(date, now(), “MM”)<=6,“last 3-6 months”,"greater than 6 months")