dual function

[Anonymous]

dual(replace(Class(field,3),'<= x <','-'),Class(field,3))

i have values from 0 to 9 in my field

so now whats happening with above statement is :

there are 3 groups created

0-3

3-6

6-9

9-12

what i want is groups till 6-9 only

0-3

3-6

6-9

how i shud do it?

[sunny_talwar]

May be make it like this

If(field >= 0 and field <= 3, Dual('0-3', 1),

     If(field <= 6, Dual('3-6', 2),

          If(field <= 9, Dual('6-9', 3))))

[aarkay29]

if(field>0 and field <3, 0-3,

if(field>=3 and field<6,3-6,6-9)) as Buckets

Class would not work for your requirement because class(field,3) would evaluate

0<=x<3

3<=x<6

6<=x<9   Less than 9 so it gives extra value 9<=x<12

[Miguel_Angel_Baeyens]

Class() creates a value where each of the inputs can be between a range. The higher bound, in this case 9, will be in the range 9-12, if you want to only display 0-9, you should convert in the value to 8 for the sake of the function, so the upper bound is never higher than 9 yet the class 6-9 returns everything including 9:

Replace(Class(If(field = 9, 8, field), 3),'<= x <','-')

[Anonymous]

my requirement is like

0

1-3

4-6

7-9

[Anonymous]

i also want to have a drill down feature

if i click on range 1-3 so it should show me the drill down values

of 1,2 and 3

[sunny_talwar]

Check the attached file....

And please try to be clear with your requirement... the reason I say this is because first you wanted groups of 0-3, 3-6, 6-9 and then you changed it to 0, 1-3, 4-6, 7-9....

Best,

Sunny

[Anonymous]

thanks,i got the grouping but can you please help how i should get the view like:

if i click on any of the range it should show me all the values in that range

suppose its

3-6

i should be able to see

3 4 5 6 values

[sunny_talwar]

Did you even open my application? Please check the application where I have created a drill down group which does exactly what you want.

[Anonymous]

thanks so much

but how is this working?

can u please help for the same

and also i have a cyclic group and a combo chart,will it work the same way?