2 Replies Latest reply: Dec 12, 2012 1:01 PM by Ismael Villegas II RSS

    Grouping by a value range

    Ismael Villegas II

      I have a table that looks like:

       

      EmployeeIDDateCallsTalkTimeClass

       

      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

        • Re: Grouping by a value range
          Vlad Gutkovsky

          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