Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table that looks like:
EmployeeID | Date | Calls | TalkTime | Class |
My goal is to findout what the average talk time is for each class but I want to group by a range of total calls. So in other words I want to know what each classes average talk time is after taking their first 100 calls then 200 calls and so on. Is there any suggestions that you can provide.
Thank you
If you don't need the chart to be overly dynamic, I would suggest creating an additional field in the script to represent the total number of calls per class/day/employee. If you need it to be more dynamic, then you would need to create a calculated dimension in the chart similar to the following:
aggr(
if(count(distinct Calls)<100,
'Less than 100',
if(count(distinct Calls)<200,
'100 - 200',
'Other'
)
),
Class,EmployeeID,Date
)
Regards,
Vlad
If you don't need the chart to be overly dynamic, I would suggest creating an additional field in the script to represent the total number of calls per class/day/employee. If you need it to be more dynamic, then you would need to create a calculated dimension in the chart similar to the following:
aggr(
if(count(distinct Calls)<100,
'Less than 100',
if(count(distinct Calls)<200,
'100 - 200',
'Other'
)
),
Class,EmployeeID,Date
)
Regards,
Vlad
Worked like a charm thank you