Group By and Average Calculation

[t0mato]

Hello!

I am working with some HR Data and looking to calculate the following: Average rate of applications per day

Data Items:
[Date Applied] - the date in which the applicant applied
[Applicant Email Address] the email address of the applicant

If I have a data item [Date Applied], my thoughts are that I will simply need to do some kind of Group By on [Date Applied] and COUNT the number of [Applicant Email Address] for each [Date Applied], then get an average of the count of [Applicant Email Address] per day.

My only challenge is writing this expression as I am not familiar with a Group By function or how to write this. Could someone please assist here?

Thanks in advance!

[dougp]

Set the Detail aggregation property for [Applicant Email Address] to Count or Count Distinct.

[t0mato]

Set the Detail aggregation property for [Applicant Email Address] to Count or Count Distinct.

Thanks for the response! And when running this, it will provide an average of the applications per day? Or is there an additional step needed here?

[t0mato]

Any ideas? I was thinking an actual written expression was needed for this.