Problem with counting by date

[#1]

Hi all,

I have an application in which I would like to count IDs for every day in the data. When I try to do this it doesn't group correctly as the dates are duplicated. So you see the count like this:

1/8/2010 11
1/8/2010 2
1/8/2010 16

While I would expect

1/8/2010 29

Any ideas on how to do this?

Regards,

Rishi

[lironbaram · Accepted solution]

hi

your problem is that the filed

Resource Start Date is a time stamp not a date , you see the same date repeating for every hour it have a record

attach is a solution in the chart, but you beter do this in the load script

you can use the same formula or just the simple one date(Resource Start Date)

hope it helps

[#3]

Hi RoiUser,

Thank a lot for the solution. You saved me a lot of time figuring out why it didn't group!

Keep up the good work!

Regards,

Rishi