1 Reply Latest reply: May 6, 2018 9:35 PM by Sunny Talwar RSS

    Group by Date not working

    Shuhel Miah

      Hi,

       

      I am trying to group a table that has hourly entries such that it rolls in up into daily entries; I have the following in my load script:

       

      [Daily Count]:
      Noconcatenate
      LOAD
          Date(Floor(Date),'DD/MM/YYYY') AS Date,
          Sum(Count) AS DailyCount
      Resident [Hourly Count]
      Group By Date;

       

      However it still shows the date as repeated values. Any suggestions to what I could be doing wrong?


      Thanks,