On the X axis I have the months and on the Y axis I have the average scores. I have a legand that shows the different Services for each. What I need is for the graph to show all of the for months even if they are blank, and all of the services for each supervisor even if those are blank.
Example: One supervisor has three services. In the first service, there ar no scores, but still need it to show in the legand so we know this is incomplete. The second and third service were not completed for April, but I still wan that to show on the graph.
Exp1 is the date, Auditor is the Supervisor, service_id is the service, and Quality Review Tool is the Average score.
Any help would be apriciated, as I have a Tuesday deadline. Thanks guys
Expand|Select|Wrap|Line Numbers
- TRANSFORM Avg(QIReportPt2.[Quality Review Tool]) AS [AvgOfQuality Review Tool]
- SELECT QIReportPt2.Expr1
- FROM QIReportPt2
- GROUP BY QIReportPt2.Expr1, QIReportPt2.Auditor
- PIVOT QIReportPt2.service_id;