chart decimals

[CFkubio]

Hi all,
I'm looking for an example or some help making a linear graph of decimal
pairs. I've tried to simplify it but still can't quite get everything to work
right in ColdFusion. Here is my sample data (X,Y):
(2.0,5.5) (8.0,2.5) (4.0,3.0) (1.1,4.0).

I'm getting "Error Occurred While Processing Request" For input string: "2.0".
Stack Trace...
java.lang.NumberFormatException: For input string: "2.0"

Can ColdFusion be used to create a linear plot/chart/graph when X and Y are
both decimal numbers? Any suggestions appreciated.



<cfchart xAxisType="scale">
<cfchartseries type="line">
<cfchartdata item=2.0 value=5.5>
<cfchartdata item=8.0 value=2.5>
<cfchartdata item=4.0 value=3.0>
<cfchartdata item=1.1 value=4.0>
</cfchartseries>
</cfchart>

[BKBK]

>... "2.0"
That's a clue. item="2.0"

[CFkubio]

Thanks for your reply, BKBK, sorry I don't follow, what am I missing?
Is it the data type?
I know the documentation says if xAxisType = "scale" then "all cfchartdata
item attribute values must be numeric."
Is cfchartdata reading item=2.0 as a string of text?
Do I have to set the data type to numeric? If so, how?

[BKBK]

What happens when you do item="2.0" in place of item=2.0?
I always thought item must be a string, but can't remember whether
value may accept fractions. I'm going off to check. In any case, I would
do what most people do, which is in fact the accepted good preactice.
Scale the values by a factor, e.g. 10.

[CFkubio]

I get the same thing with or without quotes. thanks for the suggestion, I take it "Scale the values by a f actor of 10 that you mean multiply the items (or x) by 10, right?

[BKBK]

>... you mean multiply the items (or x) by 10, right?
yes

>... I get the same thing with or without quotes

I've checked that the chart specification does indeed accept
decimals. In MX7 anyway. But not with the attribute xAxisType="scale".
This should do you.

<cfchart>
<cfchartseries type="line">
<cfchartdata item="2.0" value=5.5>
<cfchartdata item="8.0" value=2.5>
<cfchartdata item="4.0" value=3.0>
<cfchartdata item="1.1" value=4.0>
</cfchartseries>
</cfchart>

[CFkubio]

I got something working now, going back to your previous suggestion, I
multiplied the data by a factor of 100, then CAST AS int to remove the decimal
places from query data.
xAxisType has to be scale, otherwise the data is just string, (it can be
sorted alphabetically but the numbers won't appear in a linear scale).