1 Reply Latest reply on Jul 5, 2012 6:38 PM by Russell Christopher

    Connecting to a date-pivoted Excel document

      I am being asked to visual data from a pivoted Excel (.xlsx) workbook—a summary with pivoted date column headers. See attachment for details:

       

      Screen shot 2012-07-05 at 5.12.15 PM.png

       

      The dates are showing up in Tableau as separate measures, and not in the Date format, either:

       

      Screen shot 2012-07-05 at 5.14.11 PM.png

       

      What I need is to be able to visualize each company's "scores" week by week on a graph, where the date is a Date format Dimension. Similar to this graph:

       

      Screen shot 2012-07-05 at 5.17.25 PM.png

       

      How can I get Tableau to understand the date aspect of this pivoted data, without restructuring the Excel document?