type is fixed, for output columns? [message #51913] |
Mon, 27 June 2005 17:23 |
Eclipse User |
|
|
|
Originally posted by: no.spam.com
When I view the output columns of an dataset, the 'type' doesn't change.
Is this normal? Should that be able to be manipulated, or is it read-only
and based on the input data source?
And if the answer is yes, anyone have advice as to what to do if your data
is coming across as strings, and you need to use in charts (thus need it
as a number format)? In my scenario I don't have control of the process
generating the data, and thus have to work with it after its created (with
the inaccurate data type).
Any info appreciated...
|
|
|
Re: type is fixed, for output columns? [message #51940 is a reply to message #51913] |
Mon, 27 June 2005 17:36 |
Eclipse User |
|
|
|
Originally posted by: no.spam.com
As a followup, it appears from the help files that the string data type
shouldn't cause problems, but I get the unable to render chart error --
"Unable to compute a percent/stacked axis containing non-numerical data"
|
|
|
|
Re: type is fixed, for output columns? [message #51991 is a reply to message #51966] |
Mon, 27 June 2005 19:09 |
Eclipse User |
|
|
|
Originally posted by: no.spam.com
Gary Xue wrote:
> ...
> As a workaround, you can create a computed column on your data set. Define a
> Javascript expression for the computed column to convert your String data to
> Numeric, then use the computed column to build your chart.
Thanks Gary. What would this expression be like? I am familiar with
ToString() -- is there something I can do the opposite with and force to a
number format?
|
|
|
Powered by
FUDForum. Page generated in 0.04514 seconds