Apex 4 Charts: Dynamically adding a series.

To know how to add multiple series chart in Oracle Apex with examples*.

Christoph's 2 Oracle Cents

Here is an example of how to dynamically add a series to a Apex 4 chart.

Imagine the following scenario: You have a table with sales data. The table has three columns: SALES_DATE, STATE, SALES_AMOUNT. And lets say you do business only in Texas. So if you wanted to create a simple line (or other) chart on this table to show the sales amount for each day, it is pretty straight forward. You create a chart series with a query that looks something like this:

If you were doing business in two states (Texas and Oklahoma), you could simply create two series, one for Texas and on for Oklahoma:

Let’s say your business continues to grow, and you may add more states in the future. Of course you could go into the chart manually and continue to add more series.

But wait! There is a better solution! You can add…

View original post 345 more words

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s