Dual combines a text and numeric value in a single field.
The data is returned as the text value but is sorted using the number by default.
A simple example are month names.
The text data is January, February... December but the data is sorted by month number 1.2... 12
dual(text_value, numeric_value) as filed_name
How are you using Dual and what result do you expect?
Sorry for the sample delay. The following is the chart that I have. But I do not want to have the chart like this.
First I load the data:
LOAD * INLINE [
A.cus, A,1, A
B.cus, B,2, B
C.cus, C,3, C
D.cus, D,4, D
E.cus, E,5, E
F.cus, F,6, F
G.cus, G,7, G
H.cus, H,8, H
I.cus, I,9, I
J.cus, J,10, J
K.cus, K,11, K
L.cus, L,12, L
I use dual() in expression.
Dual(If(year =2009,LabelOff,''), count(customer)*100/count(total <year> customer))
And my dimention is : 1.year 2. CustomerOrder.
Then I click the 'show value on data point' and the dual function could not work......
With a combo chart, it is possible to make a text-only expression (not a dual) and show this on the data points. Create an expression that returns the text and turn off line, symbol and bar for the expression, then turn on show on data points. I don't think this works for an area chart - but I have never tried.