AnsweredAssumed Answered

Unique Value Count

Question asked by strngr12 on Feb 15, 2013
Latest reply on Feb 16, 2013 by Oliver_Reid

Hello Everyone,

 

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:

 

A

A

B

C

C

 

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!

 

Thanks,

 

Dan

Outcomes