I have dates that are strings "20160101" etc under a dimension WeekEndDate. The data that i have is weekly level data. The data is from 1st week January to present. About 10 weeks of data.
What i wish to do is to group the dates and use it as a filter across my entire dashboard.
LW - Last Week
Jan - Combine all 4 weeks of Jan
Feb - Combine all 4 weeks of Feb
Mar- combine the 2 weeks available in March
STD - season to date combining all 10 weeks.
I want these 4 to be my overall dashboard filter.
Is there a way i can group these dates together?
Why don't you convert your string dates into actual dates? Use this calculation:
This will group the weeks into their months. Once you've done this you can use this new date field to filter your dashboard.