Dynamic Mutiple Series Line Chart
madmacNov 21 2011 — edited Dec 6 2011I am trying to create a Dynamic Mutiple Series Line Cart in one sql statement. I don't want to have to hard code the series value part of the sql. The book shows the following.
Multiple Series Syntax (Flash only)
For column charts and line Flash charts, you can define multiple series in one SQL
query. The series names for these chart types are derived from the corresponding
column aliases in the query. To define a multiple series Flash chart, use the following
syntax:
SELECT link, label, series_1_value [, series_2_value [, ...]]
FROM ...
But to me it looks like you have to hard code the values. Can someone show an example of dynamically building the series value list? Also is there a good APEX chart reference guide available?
Edited by: madmac on Nov 21, 2011 2:36 PM