Charts

--> still in development, for now just a collection of doc-snippets

http://www.highcharts.com/ref/

Contents 1 Chart options field 2 Series options field 3 UTC Date per SQL 4 call a chart via button 5 chart in ein child-div 6 SQL

Chart options field

Could be used to set any specific chart option.

• aaChart.hsoptions.chart.zoomType='x'; Option to zoom into a date/time chart with a double click.
• aaChart.setSeriesCompare('percent'); Allows comparing the development of the series against each other in "percent" or "value" .

Series options field

Set specific plot options for one series. Option reference: http://www.highcharts.com/ref/#plotOptions-series

• lineWidth : 1 Set line with for this series.
• dashStyle: 'Dot', marker: {enabled: false} Dotted line without marker.

UTC Date per SQL

DB2:

('Date.UTC(' || YEAR(myDate) || ',' || (MONTH(myDate)-1) || ',' || DAY(myDate)|| '),' || sum(myPrice) )

mysql:

concat('Date.UTC(' , cast(YEAR(myDate) as char) ,',' , cast((MONTH(myDate)-1) as char) , ',' , cast(DAY(myDate) as char) , '),', cast(sum(myPrice) as char) ) as Foo

call a chart via button

     <button text="Forward curve" alt="Forward curve" image="chart.png">
       <onclick>
         <ajaxPageLoad style="ajax" target="tabGroup_priceManager_southdiv">
           <request>ChartDIV</request>
           <param value="{$vpm_ForwardChartID}">ChartID</param>
           <param value="tabGroup_priceManager_south">renderTo</param>
           <param value="{$vHCID}">Parm01</param>
           <param value="{$vRICSpot}">Parm02</param>
         </ajaxPageLoad>
       </onclick>
     </button>

chart in ein child-div

 <xsl:template match="/">
   <inner_request>
     <idiv>
       <ajaxPageLoad style="ajax" target="tabGroup_priceManager_southdiv">
         <request>ChartDIV</request>
         <param value="{$vpm_HistoricCompareChartID}">ChartID</param>
         <param value="tabGroup_priceManager_south">renderTo</param>
         <xsl:choose>
           <xsl:when test="$vPath/row[position()=1]">
             <param value="{$vPath/row[position()=1]/returnvalue[@implname='CICINR']/@unformatted}">Parm01</param>
           </xsl:when>
           <xsl:otherwise>
             <param value="0">Parm01</param>
           </xsl:otherwise>
         </xsl:choose>
       </ajaxPageLoad>
     </idiv>
   </inner_request>
 </xsl:template>

SQL

• moving average: http://www.sqlservercentral.com/articles/Moving+Average/69389/