2 Replies Latest reply: Oct 27, 2017 12:42 AM by Luk�? Ro?ek RSS

    CrossTable and dates

    Luk�? 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