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]

I am not sure what you mean when you say how is this working? Can you elaborate on what exactly you don't understand?

Yes, it should work with combo chart

[Anonymous]

thanks sunny so much,it resolved my issue

thanks a lot,

just one doubt please?

though its working fine  but actually i have 5 fields like this having the same ranges(0-9),

so earlier i was creating a cyclic group to show it as a dimension ,

but now in this case how i shud achieve it ,though i still want this drill down feature for all the fields as well

thanks in advance,

sorry for troubling,

[sunny_talwar]

I am not sure I understand the final goal you want... would you be able to share a sample with the expected output?

[Anonymous]

i have fields:

fields    values

a          0,1,2,3.........9

b          0,1,2,3.........9

c           0,1,2,3.........9

d             0,1,2,3.........9

e                0,1,2,3.........9

somehow these fields are related

so i want to group it together

i created a cyclic group but also need tthe above drill down functionality,would it be possible in the same chart

[sunny_talwar]

somehow these fields are related

You are hilarious.... anyways, I think we are not getting anywhere with this discussion. I will let someone else help you out here

All the best