| Date | Site | Supervisor | Segment | ANS | CallType | FormType | CoachingErrorType | CallInfoType | Segment | CallId |
| Date | Site | Supervisor | Segment | ANS |
I have two tables above. The first table (Errors) has a measure of count(CoachingErrorType) and the second table (Calls) has a measure of SUM(ANS). What I'm trying to do is get an error percentage of the sum(ans) which is the error percentage of total calls eventually Count(CoachingErrorType)/Sum(ANS) and then be able to drill down by site, supervisor, date, and segment. I can join on one key and get the results I need, but I want to be able to drill down by site, supervisor, and segment. How can I do this if I only have one key. I tried joining the tables on multiple columns I tried two at first ( see below) but that didn't give the results I was looking for. I am still getting duplicate supervisor columns, etc.
Errors:
LOAD
AutoNumber(Supervisor&Segment) as Key,
DateCompleted,
CallDate,
AddedBy,
AgentName,
[Supervisor] as Errors_Supervisor,
Location,
CallType,
FormType,
CoachingDetails,
CoachingErrorType,
CallInfoType,
CreditUnionName,
[Segment] as Errors_Segment,
CallId
FROM [path], table is Errors);
Right Join
LOAD
AutoNumber(Supervisor&Segment) as Key,
"Date",
Site,
[Supervisor] as [Calls_Supervisor],
[Segment] as [Calls_Segment],
ANS
FROM [path]
(ooxml, embedded labels, table is Calls);
