6 Replies Latest reply on Oct 4, 2016 4:59 AM by Andrew Watson

    Sort date string

    Mikey Michaels

      Hello All,

      I have run into an odd issue. I have two date calculations. The first is "Fiscal Year", which is a string value since I needed to pull the left 4 characters from a long date string. And the second is a "Fiscal Quarter" calculation,  which is another string calculation. I put these two calculated fields together to get a string value that looks like this "Q12015". The problem is when I try and build my viz, Tableau groups all the Q1 dates together (e.g. "Q1 2015, Q1 2016, etc.) instead of "Q12015, Q22015, etc.)

       

      Is this because there are a string? I recently upgraded to 9.3 and quickly realized DATAPARSE is gone. How can I adjust my date string?

       

      Cheers,

      Mikey.