Bucketing

[dhavalvyas]

What is expression for following KPI to create bucketing ?

Bucketing of sales order 1-30 , 31-60 , 61-90, 91-120 ,121 to Above

[Frank_Hartmann]

try:

=class(Field,30)

as dimension

and

count(Field)

as expression

hope this helps

[Anil_Babu_Samineni]

May be this?

If(order >=1 and order <31, Dual('0-30',1), If(order >=31 and order <61, Dual('31-60',2), If(order >=61 and order <91, Dual('61-90',3), If(order >=91 and order <121, Dual('91-120',4), If(order >=121,Dual('>=121',5))))))

[sunny_talwar]

Check here may be:

Buckets

[aarkay29]

Something like this

  if([Days Late] <1, 'On Time',

  if([Days Late] < 31 and [Days Late] > 0, '1 - 30',

  if([Days Late] < 61 and [Days Late] > 30,'31 - 60',

  if([Days Late] < 91 and [Days Late] > 60, '61 - 90',

  if([Days Late] < 121 and [Days Late] > 90, '91 - 120',

  if([Days Late] > 120, 'Over 120')))))) as [Age Bucket]