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?
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
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,
I am not sure I understand the final goal you want... would you be able to share a sample with the expected output?
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
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