Forum Discussion
Getting an Average Point In Time by Date and Individual
The formula you have written is designed to give you the average start time of a range of dates. I.e. its purpose is to come up with the total at the bottom of your table.
If you want the average start time, you need to use the formula that uses the employee in the VALUES function.
I want two tables, average start time by date, and average start time by employee. The screenshot in my previous post was meant to show the table for average start time by date in which you can see only the min value is being returned, not the average of all start times that occured during that date.
I didn't depict the average start time by employee table but it is doing the same thing.
I have two seperate measures as you described, one for average start time by employee, and one for average start time by date, but both are still just returning the min value.