Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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))))
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
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 <','-')
my requirement is like
0
1-3
4-6
7-9
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
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
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
Did you even open my application? Please check the application where I have created a drill down group which does exactly what you want.
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?