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!
Set the Detail aggregation property for [Applicant Email Address] to Count or Count Distinct.
Quote from: dougp on 19 Nov 2021 10:40:00 AM
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?
Any ideas? I was thinking an actual written expression was needed for this.