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

    Group by Date not working

    Shuhel Miah



      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]:
          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?