Line chart by month - Count of Employees who average > 20 hrs/week on specific tasks

[tschullo]

I need help figuring out how to write an aggr function that will give me a count of employees who average > 20 hrs/week on specific tasks (A,B) so that I can produce a line chart as shown below.

I have attached a QVS with the sample data, the only data that is faked is the BarGraph data as I could not figure out how to do it.

Note that I was able to create a pivot that shows the data in a way that can isolate the employee's as outlined, but the line graph is a different animal.

I have already solved this in script, but I want to do it in the chart so that it respects dynamic filtering by manager, dept, etc.

[SunilChauhan · Accepted solution]

just Create a field for average/week  in Script and the  at UI  do like below

Count( Distinct IF( avgField>20,EmplID field))

This way you use aggreagate function 

[tschullo]

Thanks, I suppose in this case that is good enough since it's down to the employee level and is averaged per month.

Thanks again!