1 Reply Latest reply on Sep 27, 2012 8:06 AM by Mark Holtz

    group dates

    Bonnie Scahill

      New to Tableau and just found out you can't "create group" on dates if your using a cube.  Does anyone know an alternative?  I want to create a Pre vs. Post Event and compare.  I've done this using a sql table and it works fine but from a cube it is not an option.

       

      Any help would be greatly appreciated.

       

      Thanks, B.

        • 1. Re: group dates
          Mark Holtz

          It sounds like you could create a calculated field to categorize your records.

          Is your date fixed, or do you want the user to be able to choose the date?

           

          In the fixed case, you would make a field like such:

          IF [RecordDate] < #7/1/2012#

          THEN 'Pre-July 1'

          ELSE 'Post-July 1'

          END

           

          If you want, you could replace #7/1/2012# with a Parameter (date data type) and let the user set the date.

           

          Does this help?