Buckets using Class function

[#1]

Hello,

I have created some buckets (0-10, 10-20, 20-30...) using class function for the data that I have. The problem is that most of the data has value '0' so the first bar is really long as compared to other bars. Is there a way to have to data match to the first bar only if the value is greater than 0? I tried using offset 1 and also tried using if function in the expression to calculate the counts only if value is greater than 0 but somehow it doesn't work.

Please help.

thanks,

Manoj

[JonnyPoole · Accepted solution]

If your class function is this:   class(  Value,10)

then change it to:

if ( Value > 0 , class(Value,10))

this is done on the dimension

[#3]

Ah, it was that simple. I used 'if' function everywhere else but here 🙂

thanks!