Buckets!

[Karahs]

Hi everyone,

Need Following Buckets For Count(Complain) as Dimension or as a Filter pane  in Following Format :

1 - 2

More than 5

More than 7

More than 10

Thanks&Regards,

Kshitija

[sunny_talwar · Accepted solution]

May be like this:

Aggr(

If(Count(Complain) < 2, Dual('1-2', 1),

If(Count(Complain)  > 10, Dual('More Than 10', 4),

If(Count(Complain)  > 7, Dual('More Than 7', 3),

If(Count(Complain)  > 5, Dual('More Than 5', 2))))), [Client Code])

[Karahs]

Thanks Sunny T , it worked (y)