I have a date field in my dashboard. I want to filter the view for only the dates before than the last Friday. I have created a calculated field “Last Friday”, not sure how to add the filter.
Hi @Manu
is the caluclated field “last friday” a boolean or a date?
You could create a “boolean” field.
ifelse(date=last friday,1,0)
and filter on 1
BR
Hey @ErikG, thank you so much for replying!
So I want to add a date range filter on the dashboard, and the maximum value as “last friday” field that I calculated. Basically, I want to give the user the capability to toggle with the date, but only the dates before last friday. Would you know of a way to do that?
I used your suggestion, and data gets filtered as desired. But looking for a way where the filter on the dashboard also shows the last date applicable.
Hi @Manu
i guess as long as you use a date field/filter there is no option to limit the input.
Somehow you have to filter you date field before bringing it to the dataset and use a string date field to get lost of the calender.
BR