|
-- 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
|