Page Comparison

{anchor:top}
{toc: class=contents}
h2. Overview
{styleclass: Class=topLink}[top|#top]{styleclass}

||Type||Icon||When to Use||
|*Combination Charts*|!chart_combined.png!|Combination charts, in effect, superimpose one chart type above or below another. Use to improve clarity and highlight relationships between data sets.|
|*Overlay Chart*|!chart_layered.png!|Use the line chart to emphasize a trend and bars to emphasize specific values. Line/Bar combinations may work better by de-emphasizing bars through the use of subtle colours.|

h3. Chart Data Options
||Option||Description||
|Horizontal Axis|This is the category label for the X axis|
|Vertical Axis|Typically a numeric value such as $.  An item that you want to measure on your Chart|
|Colour|This option is only available if you have a cross tab data set available and is used to determine the colour applied for cross tab series data.|


h2. Combination Chart Tutorial
{styleclass: Class=topLink}[top|#top]{styleclass}
h3. Summary
In order to set up a Combination Chart you will need:
# Create a report with chart display
## Select a field to use as the *Label*
## Select field(s) to use as the *Metrics*
# Create your chart, selecting *Overlay* as the type
# Provide the *Horizontal Axis* and *Vertical Axis* fields
# Customise the Chart as required, creating a second chart and assigning metric(s) to it
# *Close* the Chart Builder
# *Save* your report

h3. Tutorial
{section}
{column:width=40%}
*1.* Click the *Create* link in the main navigation bar of the system, and select the *Report* option. 
{column}
{column:width=60%}
!01.png!
{column}
{section}

{section}
{column:width=40%}
*2.* You will now be on the Report Initialisation page. Ensure the *Drag and Drop Builder* has been selected to use for report creation.

*3.* Click on the *Ski Team* view in order to use the fields defined within it for creating the report. 
{column}
{column:width=60%}
!02.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=40%}
*4.* Add *Year*, *Invoiced Amount*, and *Athlete ID* to *Columns*.

*5.* Apply a *Count* aggregation to the *Athlete ID* field.

This will allow you to see how many athletes you had per year, and then compare that figure to the total sales for the year.

*6.* Disable *Drill Down*.

*7.* Format the metric fields so they are named *Invoiced* and *Athletes*.

This will mean that the names are displayed nicely in the combination chart.
{column}
{column:width=60%}
!03.png!
{column}
{section}

{section}
{column:width=40%}
*8.* Proceed to the *Charts* step of the builder.
{column}
{column:width=60%}
!04.png!
{column}
{section}

{section}
{column:width=40%}
*9.* Select the *Overlay* chart from the *Combination Charts* section of the charts panel on the right of the screen.

This chart will allow us to display multiple metrics on the same chart, while using two different scales in order to compare metrics of very different proportions.
{column}
{column:width=60%}
!05.png!
{column}
{section}

{section}
{column:width=40%}
*10.* Set the following components:
* *Horizontal Axis:* Year
* *Vertical Axis:* Invoiced, Athletes

You will now have what looks like a column chart. At the moment, due to the fact that the size of the two metric fields are vastly different, you will only see the Invoiced columns, the Athletes columns will be too small to appear on the same scale. This is why we will be adding a secondary axis in the coming steps.
{column}
{column:width=60%}
!06.png!
{column}
{section}

{section}
{column:width=40%}
*11.* Open the *Combination Charts menu and add a second chart.
{column}
{column:width=60%}
!07.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=40%}
*12.* Set the second chart to be a *Bar*, and enable the use of a *Secondary Axis*.

*13.* Change the first chart to be a *Line*.

Once you've enabled the second chart, you will need to assign a metric field to it, at the moment both metrics are still using the first chart, with the first vertical axis.
{column}
{column:width=60%}
!08.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=40%}
*14.* Open the *Series menu, select the *Invoiced* metric, and change the *Combination Sub Chart* option to be *Chart 2 (Bar)*.
{column}
{column:width=60%}
!09.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=40%}
*15.* While still in the *Series* menu, select the *Athletes* metric, and change the *Thickness* option to *2* and set *Shapes* to *Yes*.
{column}
{column:width=60%}
!10.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=40%}
You will now have a Combination Overlay chart. The only issue is that the user has no way of knowing which metric belongs to which axis.
{column}
{column:width=60%}
!11.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=40%}
*16.* Open the *Axis* menu.

*17.* Set the *Vertical* axis *Display Name* to *Athletes* and the *Secondary Vertical* axis *Display Name* to *Invoiced*.

You will now see labels on the axes which match up to the chart legend, letting the user know which metric belongs to which axis and which scale.
{column}
{column:width=60%}
!12.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=40%}
*18.* *Save* your report.
{column}
{column:width=60%}
!13.png|thumbnail,border=1!
{column}
{section}

\\
\\
{horizontalrule}
{styleclass: Class=topLink}[top|#top]{styleclass}