03-26-2018 01:41 PM
I have 2 columns in my data set - Handle Time and Handled Calls.
I am creating an aggregated measure in the front end - AHT = Handle Time / Handle Calls.
Now I want to create Buckets based on Aggregated measure AHT such as
If AHT between 0 and 300, 'AHT Bucket'n = '0-300'
Else If AHT between 300 and 600, 'AHT Bucket'n = '300-600'
Else If AHT between 600 and 900, 'AHT Bucket'n = '600-900'
Else 'AHT Bucket'n = '900+'
Please can anyone help me with how to achieve this.
03-26-2018 02:07 PM
In Data Builder you can write a CASE as you write in PROC SQL under Expression in Column Editor based on your aggregation.
03-26-2018 04:02 PM
See my response to the same type of problem here:
Still working on it...