Last year I posted [this question] and I got a breakdown of completed surveys by manager.
This year I would like to expand this slightly by introducing
Please can I have some pointers on how I would do this?
What I would like to see:
Completed is a 1 when there is a QuestionID of 24. Total is just 1 for each user. I hope this makes sense. Let me know if more detail is required.: http://ask.sqlservercentral.com/questions/6392/how-do-i-return-a-line-showing-a-count-of-completed-surveys-of-each-direct-user-under-a-particular-manager-recursively-in-a-survey