11 Replies Latest reply: Jun 29, 2016 7:34 AM by Kshitija Shinde

Buckets from measure

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!!!

• Re: Buckets from measure

Use Class() function -

Dimension Class(Product,10)

Measure - Count(Product)

• Re: Buckets from measure

May be use below as Dimension

Aggr(Class(Count(CallID),10),CallID)

• Re: Buckets from measure

hey,

Am only getting 0-10 bucket,i want 0-10,10,20,20-30,etc...

• Re: Buckets from measure

Provide some data... you would get 0-10, 10-20, 20-30 if you have count(CallID) accordingly..

• Re: Buckets from measure

I have attched sample qvf

• Re: Buckets from measure

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.

• Re: Buckets from measure

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 !!

• Re: Buckets from measure

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?

• Re: Buckets from measure

DImesion is AtmCode

• Re: Buckets from measure

Then try this:

Aggr(Class(Count(CallID),10), AtmCode)

• Re: Buckets from measure

Thankyou so much,got the output as expected .