Grouping by a value range

[villegasi03]

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

[vgutkovsky · Accepted solution]

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

[villegasi03]

Worked like a charm thank you