APEX

Hi:

Have a unique requirement.

I have developed a stacked 2d column flash chart with mulitple series. The chart data is based on a pl/sql function that returns a query.

The chart is displaying correctly. However, I have a requirement to display on a chart a horizontal line representing a threshold amount. The value of the amount will be different for each rendering of the chart.

Here is the function I use to render the chart:

DECLARE
v_query VARCHAR2(4000);
BEGIN
v_query := v_query || 'SELECT NULL link, charge_date, ';

FOR c IN (SELECT DISTINCT subcategory_id
FROM xxclx_exposure_tmp2
WHERE snapshot_id = 222)
LOOP
v_query :=
v_query
|| 'SUM (decode(subcategory_id, '''
|| c.subcategory_id
|| ''', total_charge_amount, 0)) "'
|| c.subcategory_id
|| '", ';
END LOOP;

v_query := RTRIM (v_query, ', ');
v_query := v_query || ' ';
v_query :=
v_query
|| 'FROM ( SELECT subcategory_id, '
|| 'charge_date, '
|| 'round(SUM(total_charge_amount),2) total_charge_amount '
|| 'FROM xxclx_exposure_tmp2 '
|| 'WHERE snapshot_id = 222 '
|| 'AND charge_date between to_date(''01-OCT-2010'',''dd-MON-yyyy'') '
|| 'AND to_date(''10-OCT-2010'',''dd-MON-yyyy'') '
|| 'GROUP BY subcategory_id, charge_date ) ';
v_query :=
v_query
|| 'GROUP BY charge_date '
|| 'ORDER BY charge_date';



RETURN(v_query);

END;

is there a way that I can display a horizontal line on the chart representing a threshold?

Any help would be appreciated.

Thanks.

Bruce.