Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody,
Is it possible to use the class() function to set an exponential scale, maybe by manipulating the class_width variable?
Fi.
I have a bunch of responstimes of a calldesk. I want to count the number of calls which was responded to
a) between 0 and 15 minutes
b) between 15 and 60 minutes,
c) between 60 minutes and 4 hours,
d) between 4 and 8 hours,
e) more than 8 hours.
I don't want to set the intervals in the script, since this costs me too much flexibility in the dashboard.
Any suggestions?
Thanks a lot!!
Maybe I can aggregate?
With class by defalut you can use only equal scale (except some tricks for bounds and so on).
Try to make a formula that returns 1..N for your time values then use pick() to assign correspinding text labels.
Or you can program this logic with dozens of ifs.