Key Stats - Visualisations

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 Keystat 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