4 Replies Latest reply on Nov 26, 2012 6:02 PM by Shawn Wallwork

    Advice On Quarters.

    Shawn Wallwork

      Hi folks, I'm not new to Tableau, but I am new to using/dealing with date-quarters. Here's the structure of my data:

       

      Advice.PNG

       

      This is how the data comes to me. I'm going to use Andy's Excel reshaper (on cell E2), but before I do I'm trying to determine what's the best way to deal with the 'Months' date-string in column C. It's easy enough to pull out year into another column leaving the quarter/month range. But I'm wondering what's the most appropriate (efficient/beneficial) way of restating/transforming these strings as a real quarter/month dates before bringing them into Tableau?

       

      Thoughts? Suggestions?

       

      Thanks,

       

      --Shawn

       

      Richard Russell Andy