1 Reply Latest reply on Mar 16, 2016 4:47 AM by Stephen Lavery

    Grouping String Dates in Tableau

    Sunil Rai

      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?

       

      Cheers,

      Sunil