Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
Try this
[Daily Count]:
Noconcatenate
LOAD Date
Sum(Count) AS DailyCount
Group By Date;
LOAD Date(Floor(Date),'DD/MM/YYYY') as Date,
Count
Resident [Hourly Count];