Overview
[top]
Type |
Icon |
When to Use |
|---|---|---|
Combination Charts |
|
Combination charts, in effect, superimpose one chart type above or below another. Use to improve clarity and highlight relationships between data sets. |
Overlay Chart |
|
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. |
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. |
Column Chart Tutorial
[top]
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
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.
1. Click on the Create link and select Report to begin building your report.
Unable to render embedded object: File (01.png) not found.
2. You should now be on the Initialise Report page. Select the Drag and Drop Builder as the build tool.
Unable to render embedded object: File (02.png) not found.
3. Select Ski Team as the View.
4. Now click the Unable to render embedded object: File (step_right_on.png) not found. button to proceed.
Unable to render embedded object: File (2a.png) not found.
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.
Unable to render embedded object: File (3.png) not found.
6. Now you need to add metrics to your report. Click on the Unable to render embedded object: File (expand.gif) not found. next to the Time category to expand it.
7. Drag and drop the Unable to render embedded object: File (rpt_dim.png) not found. Year field into the Columns area.
8. Now expand the Athlete Payment category and drag and drop the Unable to render embedded object: File (rpt_metric.png) not found. Invoice Estimate dimension into the Columns area below Year. You will notice that the icon has changed to Unable to render embedded object: File (rpt_metric_sum.png) not found., this is because the default aggregation for this field has been set to SUM in the view.
9. Click on Unable to render embedded object: File (step_right_on.png) not found. at the top of the page to move to the next step.
Unable to render embedded object: File (4.png) not found.
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.
Unable to render embedded object: File (ChartClick.png) not found.
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.
Unable to render embedded object: File (5.png) not found.
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.
Unable to render embedded object: File (6.png) not found.
17. You should now have a chart that looks like the one pictured.
Unable to render embedded object: File (7.png) not found.
18. Click on the Chart Format Menu.
19. Click on the Add button link to setup a second chart.
Unable to render embedded object: File (add.png) not found.
Unable to render embedded object: File (8.png) not found.
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.
Unable to render embedded object: File (save.png) not found.
Unable to render embedded object: File (9.png) not found.
22. Expand the Sum Invoiced Amount section and set the Chart to Chart 1 (Line).
23. Set the Thickness to 2
Unable to render embedded object: File (10.png) not found.
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
Unable to render embedded object: File (refresh.png) not found.
Unable to render embedded object: File (11.png) not found.
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 Unable to render embedded object: File (menu_close.png) not found. Close button to go back to the Report Preview page.
Unable to render embedded object: File (12.png) not found.
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.
Unable to render embedded object: File (13.png) not found.
[top]