I have a data set that contains a thousands of dates, associated days of the week, and an additional variable. Something like below:
I'd like to create 3 calculated fields Pk, Sh, Tr.
Pk = sum([Variable]) but I'd like to filter on DOW.
I'd like to filter on Day of Week separately for each of the three calculated fields and be able to include all, none, or any combination of weekdays.
To me it seems I need 3 separate filters for DOW but I can't get the filters to act independently of each other in the calculated fields.
That is, if I deselect, say, M for one calculated field, it affects all of them.
I'm kinda a Tableau noob.
Retrieving data ...