How can I get a unique count for a "group of records"?

Discussion created by jayankurian on Oct 18, 2012
Latest reply on Nov 14, 2012 by comment




I have a database which contains 230 records for the Month of September 2012.


Data Example:

Sept 1, I have 8 records

Sep 2, I have 18 records

Sept 3, I have 12 etc.


How do I get the count of days(unique count of day, in other words if Sept 1 have 8 records I want a field which should hold the value of 1 for Sep 1, and value 1 for Sep 2, value 1 for Sept 3 and so on... later I want to get a total of this value for some other calculations.


Any easy way other than writing complex script?


Thank you