3 Replies Latest reply on Jan 13, 2013 5:39 PM by Alex Kerin

    Converting mmm-yy to grouped date format

    Paul Carysforth

      Wonder if anyone can help?

       

      I have data in an excel sheet that relates to individual stores specifically revenue performance by month from Jan 11 to Dec 12. The column headers for monthly revenue are 'mmm-yy' so Jan-11 etc. The remaining data I have relates to the attributes of the individual stores.

       

      My issue is that in Tableau the individual monthly sales are appearing as individual measures so 24 measures relating to each month. Is there a way of grouping these so I can take advantage of the standard date functionality in Tableau? For example I would like to be able to take advantage of the line graphing visualisations as well as rolling up the revenue for the year for example to compare 2012 to 2011 per store. Am i missing something?

       

      I'm guessing its something basic I'm missing but any help would be appreciated.

       

      Thanks

      Paul