Overview
[top]
Used to display steps in a process, helps to identify bottle necks in a workflow.
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 |
Funnel Chart Tutorial
[top]
Summary
In order to set up a Funnel 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 Series
- Create your chart, selecting Special Purpose as the type, and Funnel as the chart
- Provide the Label and Series options and Refresh
- Customise the Chart as required
- Close the Chart Builder
- Save your report
Tutorial
1. Click on the Create link and select Report to begin building your report.
2. You should now be on the Initialise Report page. Select the Drag and Drop Builder as the build tool.
3. Select Ski Team as the View.
4. Now click the 
button to proceed.
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.
6. On the Report Data page, drag and drop the 
Booking Step and Athlete ID fields into the Column Fields area.
7. Drag and drop the Booking Status field into the Filters area.
8. Select the Athlete ID field and add a 
Count aggregation to it.
9. Click on at the top of the page.
10. On the Filters page, set Booking Status to be Equal to.
11. Click on the 
link to set the value.
12. Select Cancelled. In this case, we are only interested in seeing bookings that have been cancelled, examining which step athletes cancel in.
13. Click Submit to save your changes.
14. Click on at the top of the page.
15. On the Report Preview page click on the Pie Chart image as before.
16. Click on the Chart Menu and select Special Purpose as the Chart Type and Funnel as the subtype (click on the picture on the left).
17. Click Save to load the options for a Funnel Chart.
18. Set the Chart Data settings.
19. Select Booking Step for the Label.
20. Select Count Athlete ID as the Series.
21. Click Refresh to generate your chart.
22. You should now have a chart that looks like the one pictured here.
23. You now need to Save and Activate your chart. Click on the Close button to go back to the Report Preview page.
24. Click on the Save Menu and use Funnel Chart Tutorial as the Name.
25. Type This Funnel Chart was created using the Charts Tutorial as the Description.
26. Enter Tutorial as the Category and Charts as the Sub Category.
27. Click Activate.
[top]