|
-- Region Name: Combined Chart - Anychart Integration Kit - Print --
Region Source
<div id="container_#CHART_NAME#"></div>
<script type="text/javascript" language="javascript">
var chart_#CHART_NAME# = new AnyChart('&ANYCHART_INTEGRATION_KIT./#CHART_TYPE#.swf');
chart_#CHART_NAME#.width = "#WIDTH#";
chart_#CHART_NAME#.height = "#HEIGHT#";
chart_#CHART_NAME#.setXMLFile('#HOST#apex_util.flash?p=&APP_ID.:12:&APP_SESSION.:FLOW_FLASH_CHART_R#REGION_ID#');
chart_#CHART_NAME#.write('container_#CHART_NAME#');
</script>
#CHART_REFRESH#
Series Queries
Series 1 2D Column
SELECT NULL LINK,
ENAME LABEL,
SAL, COMM
FROM EMP
ORDER BY ENAME
Serie 2 Spline
SELECT NULL LINK,
ENAME LABEL,
SAL+NVL(COMM,0) "{name:Total;type:Spline}"
FROM EMP
ORDER BY ENAME
Serie 3 Line (Min, Avg, Max)
select
null as link
, ename as label
, min(sal) over () as "{name:Minimum;type:Line}"
, avg(sal) over () as "{name:Average;type:Line}"
, max(sal) over () as "{name:Maximum;type:Line}"
from emp
order by ename
Chart XML
Default XML from APEX
|