General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>If a rep works on 4 projects, they're still only 1 rep.
>Right, Either will give you that.
I tried the cnt(Distinct repid) as repcnt, but it still returned 14 rather than 9.
Each manager has 2 teams. A rep can spend time on either team. The task is to find the average time per rep for each manager's team AND manager overall. the average is simple: Sum(time4team) / RepCnt4Team = team avg time/rep
The same for manager overall: sum(alltime) / repcnt
The problem is when a rep is on both teams, they can't get counted twice.
I'll eventually figure it out, but it gets uglier the closer I get...
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only