digitallyskilled
IS-IT--Management
I am trying to compare one users total orders with the average of all users orders per project type. I have the query that gives me the data i need for the firs user but i need to somehow get the average of everyone else
I then want to display that data in a chart using reporting services
any suggestions?
SELECT
[Order].Id,
Users.FirstName,
Users.LastName,
[Order].CreatorId,
ProjectType.ProjectType,
[Order].ProjectTypeId
FROM [ORDER]
INNER JOIN Users ON [Order].CreatorId = Users.[Id]
INNER JOIN ProjectType on [ORDER].ProjectTypeId = ProjectType.Id
Where [Order].CreatorId = @CreatorId and [Order].ProjectTypeId NOT IN (12,13,14)
I then want to display that data in a chart using reporting services
any suggestions?
SELECT
[Order].Id,
Users.FirstName,
Users.LastName,
[Order].CreatorId,
ProjectType.ProjectType,
[Order].ProjectTypeId
FROM [ORDER]
INNER JOIN Users ON [Order].CreatorId = Users.[Id]
INNER JOIN ProjectType on [ORDER].ProjectTypeId = ProjectType.Id
Where [Order].CreatorId = @CreatorId and [Order].ProjectTypeId NOT IN (12,13,14)