Forum Discussion
Automatic filter dashboard
I tell you that in a dashboard, I have a filter of days of the week. The problem is that I must be changing it on a daily basis.
If I have the current date using a current, could the filter be made to change automatically in relation to my current?
Best regards
5 Replies
Syndicate_Admin , you have create a column like this and use
Assume
Day of week = format([Date], "dddd")
Day of week type = if( weekday([Date] = weekday(today()), "Current WeekDay" , [Day of week])
Select current weekday and save the report
A question, in the filter shown above, applying this method will in the same way have available to select the other days of the week?
Hi Syndicate_Admin ,
Yes, you can . As mentioned by amitchandak, you create a new column based on today and other day of week. Put it in slicer and you can changethe filter by slicer.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
I have a problem, in the consultation, the day of the week (Monday-Tuesday-etc) is as text. Could you bring the current date as text, and make some kind of relationship to the query text? that way you filter what's in the current day.
Hi Syndicate_Admin ,
Not getting clear from your description. Would you please explain it with some sample data?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
