Listbox to select certain day of week

[#1]

Hi all,

I have a bunch of time-related data (daily over a year) and I want a listbox that will select a certain day of the week, for example I click 'Monday' and all the Monday's are selected.

Is this possible? My date format is DD/MM/YYYY

Thanks!

[rajat2392]

Hi O G,

Its Absolutely Possible, while loading the data, create a column for "Week Day" as below

WeekDay(Date) as WeekDay

Use this week day as filter in dashboard, as per the selection of WeekDay, dates associated will automatically get selected.

Regards

Rajat

[tresesco]

Create a new field like:

Weekday(date) as Weekday