Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
How can i create buckets from measure?
Eg. I have Count(CallId) as total and want to create buckets for total. How can i achieve this?
Cant use class function because class function needs field not measure!
Thanks!!!
Use Class() function -
Dimension Class(Product,10)
Measure - Count(Product)
May be use below as Dimension
Aggr(Class(Count(CallID),10),CallID)
hey,
Am only getting 0-10 bucket,i want 0-10,10,20,20-30,etc...
Provide some data... you would get 0-10, 10-20, 20-30 if you have count(CallID) accordingly..
I have attched sample qvf
This is a distinct list of CallLogID which is always 1. What dimension are you counting this CallLogID on? In the sample you have provided there is only one field, but I am guessing that you might have more dimension in your actual scenario.
Actually i want to create a listbox in which all the buckets are present ie.0-10,10-20,etc....
i already have a graph as below:
Thanks !!
We sort of understand what you want, but what is still unclear is that what dimension are you counting CallLogID on? In other words, when you say Count(CallLogID) as expression, what is your dimension?
DImesion is AtmCode