This content has been marked as final. Show 7 replies
Is it possible to implement this in APEX?It is possible to implement charts with multiple series in Apex. You'll do this with multiple SELECTs, each representing a different series. Using your example, they'll look something like this:
Series 1 SELECT NULL AS LINK, Name AS LABEL, X1 AS VALUE FROM tbl1 WHERE Class = 4; Series 2 SELECT NULL AS LINK, Name AS LABEL, X2 AS VALUE FROM tbl1 WHERE Class = 4; Series 3 SELECT NULL AS LINK, Name AS LABEL, X3 AS VALUE FROM tbl1 WHERE Class = 4; Series 4 SELECT NULL AS LINK, Name AS LABEL, X4 AS VALUE FROM tbl1 WHERE Class = 4;
Thanks Matthew, I'll give it a try and get back to you
I tried your code, it is different from what i wanted, I was not clear enough, sorry. I made a quick excell chart of what i want and took a snapshot, please take a look at it.
K -- you not only have to create multiple series, but you also need to make a crosstab view/query of that table. The values of X1, X2, X3, and X4 need to be rows rather than columns when graphing.
I am not really sure if i can do this, any examples would be very helpful.
Thanks a lot
The following each have examples on this:
One of my applications has severel charts created using only one Serie, but displaying 1-180 lines dynamicly.
In order to archive "Dynamic Multiple Series (1-250)" you need to create the series as a-in-one serie.
Create only one serie query.
The sql query is created as the return value of a pl/sql function.
The returned sql should look somewhat like this
In your case the returned sql query will rely on either sql and pivot syntax or a table function.
select null link, some_category label, somevalue1 "Serie 1", somevalue2 "Serie 2", somevalue3 "Serie 3", somevalue4 "Serie 4", somevalue5 "Serie 5", somevalue6 "Serie 6" from (your query) order by some_category
You loose control of the line colouring.
Serie labels has a max length of 30-32 characters .
Hove you get the idea :)