3 Replies Latest reply: Mar 27, 2018 12:43 PM by Mike Boreham RSS

    CrossTable and dates

    Lukas Roček

      Hi all,

      I have a problem with crossTable Load. I have this table in Excel:

      diskuze.PNG

      I use this code:

       

      Capacity:

      CrossTable (Months,Utilization)

      LOAD

          Name as WorkerName,

          "43009",

          "43040",

          "43070",

      FROM [path.xlsx]

      (ooxml,embedded labels,  table is Sheet1);


      I need to view dates, but when I try to convert it to date, no results (Date, Timestamp...)

      How to load this data? Especially for a heatmap?

      Thaks a much for your ideas