What I want to do now is add an employee dimension and show their activity for the current day and still show the average activity for their job title.
Average Activities per Day
I can add the employee and Sum([Activity Counter]), but changing the grain of the table breaks the Average Activities per Day calculation. I can't seem to find an example of how to do this. I tried to have it ignore the Employee dimension but it doesn't work.
Hi Stefan! Thanks for taking the time to help me out. This is close but most of the average activities per day numbers aren't correct. (Some are, however.) The ones that are off are close to the correct values but not spot on. Strange.
I'll keep at it with this is a starting point but if you have any other ideas I'd sure appreciate it.