|
|
|
|
This type of chart is not possible in APEX 3.x through the wizards and without the Anychart integration kit for APEX.
On the left chart are three types of charts combined: a 2D Column chart which shows the salary and commission by employee, a 2D Spline which shows the total (salary + commission) and 3 Lines which shows the average and minumum and maximum.
On the right chart there's a combination of a 2D Column and Spline chart together with an extra Y-axis.
|
|
|
-- Region Name: Combined Chart - Anychart Integration Kit --
Region Source
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0"
width="#WIDTH#"
height="#HEIGHT#"
id="#CHART_NAME#"
align="">
<param name="movie" value="&ANYCHART_INTEGRATION_KIT./#CHART_TYPE#.swf?XMLFile=#HOST#apex_util.flash?p=&APP_ID.:10:&APP_SESSION.:FLOW_FLASH_CHART_R#REGION_ID#">
<param name="quality" value="high">
<param name="allowScriptAccess" value="sameDomain">
<param name="allowNetworking" value="all">
<param name="scale" value="noscale">
<param name="wmode" value="transparent">
<param name="FlashVars" value="waiting=#FLASH_WAITING#&loading=#FLASH_LOADING#">
<embed src="&ANYCHART_INTEGRATION_KIT./#CHART_TYPE#.swf?XMLFile=#HOST#apex_util.flash?p=&APP_ID.:10:&APP_SESSION.:FLOW_FLASH_CHART_R#REGION_ID#"
quality="high"
width="#WIDTH#"
height="#HEIGHT#"
name="#CHART_NAME#"
scale="noscale"
align=""
allowScriptAccess="sameDomain"
allowNetworking="all"
type="application/x-shockwave-flash"
pluginspage="http://www.macromedia.com/go/getflashplayer"
wmode="transparent"
FlashVars="waiting=#FLASH_WAITING#&loading=#FLASH_LOADING#">
</embed>
</object>
#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
-- Region Name: Combination of a 2D Column and a 2D Spline chart with extra Y-axis - Anychart Integration Kit --
Region Source
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000"
codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,0,0"
width="#WIDTH#"
height="#HEIGHT#"
id="#CHART_NAME#"
align="">
<param name="movie" value="&ANYCHART_INTEGRATION_KIT./#CHART_TYPE#.swf?XMLFile=#HOST#apex_util.flash?p=&APP_ID.:&FLOW_PAGE_ID.:&APP_SESSION.:FLOW_FLASH_CHART_R#REGION_ID#">
<param name="quality" value="high">
<param name="allowScriptAccess" value="sameDomain">
<param name="allowNetworking" value="all">
<param name="scale" value="noscale">
<param name="wmode" value="transparent">
<param name="FlashVars" value="waiting=#FLASH_WAITING#&loading=#FLASH_LOADING#">
<embed src="&ANYCHART_INTEGRATION_KIT./#CHART_TYPE#.swf?XMLFile=#HOST#apex_util.flash?p=&APP_ID.:&FLOW_PAGE_ID.:&APP_SESSION.:FLOW_FLASH_CHART_R#REGION_ID#"
quality="high"
width="#WIDTH#"
height="#HEIGHT#"
name="#CHART_NAME#"
scale="noscale"
align=""
allowScriptAccess="sameDomain"
allowNetworking="all"
type="application/x-shockwave-flash"
pluginspage="http://www.macromedia.com/go/getflashplayer"
wmode="transparent"
FlashVars="waiting=#FLASH_WAITING#&loading=#FLASH_LOADING#">
</embed>
</object>
#CHART_REFRESH#
Series Queries
{n:Video;t:Spline;y:y1}
select null, to_char(o.order_timestamp, 'DY') label, sum (decode(p.category,'Computer',oi.quantity * oi.unit_price,0)) "{n:Computer}", sum (decode(p.category,'Video',oi.quantity * oi.unit_price,0)) "{n:Video;t:Spline;y:ex}", sum (decode(p.category,'Audio',oi.quantity * oi.unit_price,0)) "{n:Audio}", sum (decode(p.category,'Phones',oi.quantity * oi.unit_price,0)) "{n:Phones}" from demo_product_info p, demo_order_items oi, demo_orders o where oi.product_id = p.product_id and o.order_id = oi.order_id group by to_char(o.order_timestamp, 'DY'), to_char(o.order_timestamp, 'D') order by to_char(o.order_timestamp, 'D')
Chart XML
<?xml version = "1.0" encoding="utf-8" standalone = "yes"?>
<anychart>
<margin all="1"/>
<charts>
<chart plot_type="CategorizedVertical" use_anychart3_data_model="true" use_sets_colors="false">
<data_plot_settings default_series_type="Bar">
<bar_series style="AquaLight">
<tooltip_settings enabled="true">
<format>
Series: {%SeriesName}
Category: {%CategoryName}
Value: {%Value}
</format>
</tooltip_settings>
</bar_series>
<line_series>
<tooltip_settings enabled="true">
<format>
Series: {%SeriesName}
Category: {%CategoryName}
Value: {%Value}
</format>
</tooltip_settings>
</line_series>
</data_plot_settings>
<chart_settings>
<title><text>Multiple Y-Axes</text></title>
<axes>
<y_axis>
<scale type="Logarithmic" minimum="1" log_base="5"/>
<title><text>Primary Y-Axis</text></title>
<labels><format>{%Value}{numDecimals:0}</format></labels>
</y_axis>
<extra>
<y_axis name="ex">
<title><text>Secondary Y-Axis</text></title>
<labels><format>{%Value}{numDecimals:0}</format></labels>
</y_axis>
</extra>
</axes>
</chart_settings>
#DATA#
</chart>
</charts>
</anychart>
|
| |
|
|