I have a date filter in my dashboard. I want to set the default start date to last Friday.
For e.g.
If today is Friday then start date should be = 7 days ago
If today is Saturday then start date should be = 8 days ago
If today is Sunday then start date should be = 9 days ago… an so on… x days ago
I am able to create a calculated field for ‘x’ days ago, but do not know how to use the calculated field to dynamically set the start date of the filter to default x days ago
You can try rolling date filter feature, In the date &time range filter, you are able to set a rolling before/after/between filter, with the date to be today, yesterday, start/end of this/previous/next year/quarter/month/day…
Maybe a workaround is to use a parameter with relative date>start of last week. In addition to this would have to set first day of the week to be a friday.
Otherwise can’t think of another way to define that default value on the control based on logic.
Ramon
Thanks @Ramon_Lopez and @niyati for replying!
@Ramon_Lopez - is it possible to set ‘Friday’ as the start of the week? I thought it’s Sunday by default and cannot be changed
Hi, yes, this was released last week.
