Difference between revisions of "Key Stats - Visualisations"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) |
|||
| Line 1: | Line 1: | ||
== Overview == | == Overview == | ||
| − | bxp | + | bxp allows a custom visualisation report to be generated on screen through the Keystats module. The visual Keystat can generate a number of charts: line, bar and pie. |
| − | + | This visual Keystat generates any number of Keystat data in the chart once they are separated by a , | |
== Creating a Visual Key Stat == | == Creating a Visual Key Stat == | ||
| − | To create a Visual | + | To create a Visual Keystat make sure to have the Keystat Id that contains the data you wish to generate the desired chart from. To create a Keystat:- |
| Line 13: | Line 13: | ||
| − | + | Input the following settings to successfully create a visual key stat:- | |
| − | 1) Title - This should be an easily identifiable title for the | + | 1) Title - This should be an easily identifiable title for the keystat |
2) Type - Set this to be ''Graphic'' | 2) Type - Set this to be ''Graphic'' | ||
| − | 3) Query - Field(s) - This field should contain the headings of the stats | + | 3) Query - Field(s) - This field should contain the headings of the stats to be included in the chart ( multiple items can be separated by a ,) |
| − | 4) Query - SQL - This field should contain the key stat ids | + | 4) Query - SQL - This field should contain the key stat ids to be included in the chart ( multiple items can be separated by a ,) |
| − | 5) Display Title - This is the title of the Graph when it | + | 5) Display Title - This is the title of the Graph when it generates on screen |
| − | 6) Style Pattern - This allows you to select the type of graph you wish to | + | 6) Style Pattern - This allows you to select the type of graph you wish to generate, i.e. Line, Bar or Pie |
| Line 34: | Line 34: | ||
== Visual Key Stat Multi Data Series == | == Visual Key Stat Multi Data Series == | ||
| − | bxp | + | bxp can generate two charts with multiple Data Series'. These charts are a line chart, and a bar chart with a line. Both of these charts are created the exact same way as the standard graphs outlined above, but require slight modification to the following settings: |
| − | following settings : ''Query - SQL'' and ''Query - Field(s)'' | + | ''Query - SQL'' and ''Query - Field(s)'' |
=== Line Chart Multi Series === | === Line Chart Multi Series === | ||
| − | In order to | + | In order to generate a line chart with multiple data series' the following settings must be in the following format: |
<syntaxhighlight lang="html4strict"> | <syntaxhighlight lang="html4strict"> | ||
| Line 59: | Line 59: | ||
=== Bar Chart with Line === | === Bar Chart with Line === | ||
| − | + | To generate a bar chart with a line, the following settings must be in the following format: | |
<syntaxhighlight lang="html4strict"> | <syntaxhighlight lang="html4strict"> | ||
Revision as of 14:54, 1 May 2015
Contents
1 Overview
bxp allows a custom visualisation report to be generated on screen through the Keystats module. The visual Keystat can generate a number of charts: line, bar and pie.
This visual Keystat generates any number of Keystat data in the chart once they are separated by a ,
2 Creating a Visual Key Stat
To create a Visual Keystat make sure to have the Keystat Id that contains the data you wish to generate the desired chart from. To create a Keystat:-
Main Menu > Key Stats > KeyStat - Add
Input the following settings to successfully create a visual key stat:-
1) Title - This should be an easily identifiable title for the keystat
2) Type - Set this to be Graphic
3) Query - Field(s) - This field should contain the headings of the stats to be included in the chart ( multiple items can be separated by a ,)
4) Query - SQL - This field should contain the key stat ids to be included in the chart ( multiple items can be separated by a ,)
5) Display Title - This is the title of the Graph when it generates on screen
6) Style Pattern - This allows you to select the type of graph you wish to generate, i.e. Line, Bar or Pie
3 Visual Key Stat Multi Data Series
bxp can generate two charts with multiple Data Series'. These charts are a line chart, and a bar chart with a line. Both of these charts are created the exact same way as the standard graphs outlined above, but require slight modification to the following settings: Query - SQL and Query - Field(s)
3.1 Line Chart Multi Series
In order to generate a line chart with multiple data series' the following settings must be in the following format:
<!--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
3.2 Bar Chart with Line
To generate a bar chart with a line, the following settings must be in the following format:
<!--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
4 Examples Output
Bar Chart
Pie Chart
Line Chart
Line Multi Series
Bar Chat With Line
