Group by Date not working

[stats101]

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,

[sunny_talwar]

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];