|
-- Region Name: Two 2D Spline charts with an extra Y-axes - 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
Two Spline
select null
, to_char(o.order_timestamp, 'DY') label
, sum (decode(p.category,'Computer',oi.quantity * oi.unit_price,0)) "{n:Computer;t:Spline;y:ex}"
, sum (decode(p.category,'Video',oi.quantity * oi.unit_price,0)) "{n:Video;t:Spline}"
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">
<line_series>
<tooltip_settings enabled="true">
<format>
Series: {%SeriesName}
Category: {%CategoryName}
Value: {%Value}
</format>
</tooltip_settings>
<animation type="&P46_LINE_ANIMATION." duration="3" show_mode="Together"></animation>
</line_series>
</data_plot_settings>
<chart_settings>
<title><text>Spline with Multiple Y-Axes</text></title>
<legend enabled="true"></legend>
<axes>
<y_axis>
<scale type="Logarithmic" minimum="1" log_base="5"/>
<title><text>Video Sales</text></title>
<labels><format>{%Value}{numDecimals:0}</format></labels>
</y_axis>
<extra>
<y_axis name="ex">
<title><text>Computer Sales</text></title>
<labels><format>{%Value}{numDecimals:0}</format></labels>
</y_axis>
</extra>
</axes>
<chart_animation type="&P46_CHART_ANIMATION." duration="1" show_mode="Together"></chart_animation>
</chart_settings>
#DATA#
</chart>
</charts>
<settings><animation enabled="True" /></settings>
</anychart>
|