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||
|Label|This is the category label for the X axis|
|Series|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. Column Chart Tutorial
{styleclass: Class=topLink}[top|#top]{styleclass}
h3. Summary
In order to set up a Column Chart you will need:
# Create a report with chart display
## Select a field to use as the *Label*
## Select a field to use as the *Metric*
## Select a field to use as the *Colour* (if you have decided to create a cross tab report)
# Create your chart, selecting *Column* as the type
# Provide the *Label*, *Metric*, and *Colour* options and *Refresh*
# Customise the Chart as required
# *Close* the Chart Builder
# *Save* your report


h3. Tutorial
The following Column Chart tutorial can be used for any of the above listed Column Charts, with the exception of the Stacked and Layered options, which simply requires the report to be changed to a cross tab in order to be implemented.

{section}
{column: width=30%}
*1.* Click on the *Create* link and select *Report* to begin building your report.
{column}
{column: width=70%}
!01.png! 
{column}
{section}

{section}
{column: width=30%}
*2.* You should now be on the Initialise Report page. Select the *Drag and Drop Builder* as the build tool.
{column}
{column: width=70%}
!02.png! 
{column}
{section}

{section}
{column: width=30%}
*3.* Select *Ski Team* as the View.

*4.* Now click the !step_right_on.png! button to proceed.
{column}
{column: width=70%}
!2a.png|thumbnail,border=1! 
{column}
{section}

{section}
{column:width=30%}
*5.* You should now be on the *Step 1. Report Data* page. To start with, set the Output Options to *Chart Only* by selecting it in the *Report Options* section on the right. This will ensure that the information appears as a chart.
{column}
{column:width=70%}
!3.png!
{column}
{section}
	 
{section}
{column:width=30%}
*6.* Now you need to add metrics to your report. Click on the !expand.gif! next to the *Time* category to expand it. 

*7.* Drag and drop the !rpt_dim.png! *Year* field into the *Columns* area. 

*8.* Now expand the *Athlete Payment* category and drag and drop the !rpt_metric.png! *Invoice Estimate* dimension into the *Columns* area below *Year*. You will notice that the icon has changed to !rpt_metric_sum.png!, this is because the default aggregation for this field has been set to *SUM* in the view. 

*9.* Click on !step_right_on.png! at the top of the page to move to the next step. 
{column}
{column:width=70%}
!4.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=30%}
*10.* You should now be on the Report Preview page. Click on the image of a Pie Chart (pictured here) to go to the Chart Builder page to setup your chart.
{column}
{column:width=70%}
!ChartClick.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=30%}
*11.* Click on the *Chart* Menu, select *Combination Charts* as the Chart Type and click on the picture of the *Overlay* Chart to select it. 

*12.* Click *Save*, this will load the options for an Overlay Chart. 
{column}
{column:width=70%}
!5.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=30%}
*13.* In the *Chart Data* section you will need to select the data for each setting in the chart.

*14.* Set the Label to *Year*. 

*15.* Set the Series to *Sum Invoice Estimate*. 

*16.* Click *Refresh* to generate your chart.
{column}
{column:width=70%}
!6.png!
{column}
{section}

{section}
{column:width=30%}
*17.* You should now have a chart that looks like the one pictured. 
{column}
{column:width=70%}
!7.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=30%}
*18.* Click on the *Chart Format* Menu.

*19.* Click on the *Add* button link to setup a second chart.

!add.png!
{column}
{column:width=70%}
!8.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=30%}
*20.* You are going to end up with a chart that has a line component and a bar component. To set this up set Chart 2 to *Bar*.

*21.* Click *Save*.

!save.png!
{column}
{column:width=70%}
!9.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=30%}
*22.* Expand the *Sum Invoiced Amount* section and set the Chart to *Chart 1 (Line)*.

*23.* Set the Thickness to *2*
{column}
{column:width=70%}
!10.png!
{column}
{section}

{section}
{column:width=30%}
*24.* Expand the *Avg Camp Rating* section and set the Chart to *Chart 2 (Bar)*.

*25.* Define colours for the bars

*26.* Click *Refresh* to see your updated Combination Chart

!refresh.png!
{column}
{column:width=70%}
!11.png!
{column}
{section}

{section}
{column:width=30%}
*27.* This is what your chart should look like. The charts share a common X Axis, and each have their own Y Axis.

*28.* You now need to *Save* and *Activate* your chart. Click on the !menu_close.png! *Close* button to go back to the Report Preview page.
{column}
{column:width=70%}
!12.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=30%}
*29.* It is now time to save your report. Click on the *Report* Menu and select *Save*.

*30.* Type *Combination Chart Tutorial* as the Name, and *This Combination Chart was created using the Charts Tutorial* as the Description.

*31.* Enter *Tutorial* as the Category and *Charts* as the Sub Category.

*32.* Click *Activate*.
{column}
{column:width=70%}
!13.png|thumbnail,border=1!
{column}
{section}

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