240
edits
Changes
no edit summary
== Overview ==
[[File:VisKeyStatSetting.png]]
== Visual Key Stat Multi Data Series ==
bxp allows the the rendering of two charts with multiple Data Series's, these charts are a line chart and a bar chart with line. Both of these charts are created the exact same was a the standard graphs as outlined above but require slight modification to the
following settings : ''Query - SQL'' and ''Query - Field(s)''
=== Line Chart Multi Series ===
In order to render a line chart with multiple data series's the following settings must be in the following format:
<syntaxhighlight lang="html4strict">
<!--Base Format-->
Query - Field(s) - Name of data series( sep by , )[[DATASERIES]]Headings for intervals ( sep by , )
Query - SQL - Values for Series 1 (sep by ,)[[DATASET]]Values for Series 2 (sep by ,)..............[[DATASET]]Values for Series X(sep by ,)
<!--Example-->
Query - Field(s) - Series1, Series 2[[DATASERIES]]Date Range 1,Date Range 2, Date Range 3
Query - SQL - 10,110,200[[DATASET]]500,100,300
</syntaxhighlight>
=== Bar Chart with Line ===
In order to render a bar chart with Line the following settings must be in the following format:
<syntaxhighlight lang="html4strict">
<!--Base Format-->
Query - Field(s) - Name for the Bar Chart Series, Name for the Line Chart Series[[DATASERIES]]Headings for intervals ( sep by , )
Query - SQL - Values for the Bar Chart (sep by ,)[[DATASET]]Values for the Line Chart (sep by ,)
<!--Example-->
Query - Field(s) - Bar Chart Series, Line Chart Series[[DATASERIES]]Date Range 1,Date Range 2, Date Range 3
Query - SQL - 10,110,200[[DATASET]]500,100,300
</syntaxhighlight>
== Examples Output ==
[[File:VisKeyStatChartLine.png]]
'''Line Multi Series'''
[[File:KeyStats_Line_Multi.png]]
'''Bar Chat With Line'''
[[File:KeyStats_Bar_Line.png]]