Is there a way to get a summary or other type of field to give me a count of unique values in another field? For example, lets say I have five fields:
The value I'd want returned in my summary field would be 3 because there are three values: A, B and C. The story is that I am trying to break down a daily average of uploads to a site. What I know is the size of each individual upload and the date they happened on. Because the uploads didn't happen daily I can't just take a date range ad divide the total, I need to divide the total size by the number of days that uploads actually occurred.
Any help would be greatly appreciated!