2 Replies Latest reply on Oct 15, 2012 2:55 PM by Sten Lomme

    Reading multidimensional data from Excel

    Sten Lomme

      I'm trying to figure out how I can read electronic usage data and present hourly, daily, monthly, etc in Tableau. The data is stored in an Excel-file and structured dimensionally as below:

       

       

      DATEUNITHOUR 1HOUR 2HOUR 3HOUR 4HOUR 5HOUR 6HOUR 7HOUR 8HOUR 9HOUR 10HOUR 11HOUR 12HOUR 13HOUR 14HOUR 15HOUR 16HOUR 17HOUR 18HOUR 19HOUR 20HOUR 21HOUR 22HOUR 23HOUR 24SUM
      01.09.201011885433223259161715171516161542322323177
      02.09.20101188542232325816161615161615161616533333205
      03.09.201011885433334359161616151615161553232332181

       

       

      How can I present this data graphically by day in Tableau? If the data was stored ralationally as below, I would have no problem. But with the hours listed in columns, I'm not sure how to read this into Tableau.

       

      DATEUNITHOUR VALUE
      01.09.201011885413
      01.09.201011885423
      01.09.201011885432
      01.09.201011885442

       

      Any help would be appreciated.

      Thanks!