Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

Version 1 Next »

Overview

Unknown macro: {styleclass}

[top]

These are all designed with a particular kind of dataset in mind, resulting in highly specified charts.

Funnel

Unable to render embedded object: File (chart_funnel.gif) not found.

Used to display steps in a process, helps to identify bottle necks in a workflow.

Radar

Unable to render embedded object: File (chart_radar.gif) not found.

You want to compare data by integrating multiple axes into a single radial figure.

Waterfall

Unable to render embedded object: File (chart_waterfall.gif) not found.

Waterfall charts are a special type of Floating Column Chart. A typical waterfall chart shows how an initial value is increased and decreased by a series of intermediate values, leading to a final value.

Event

Unable to render embedded object: File (chart_event.gif) not found.

Maps the occurance of events against the values of a numeric data set over time.

Week Density

Unable to render embedded object: File (chart_timeheat.gif) not found.

You want to measure the density of an occurance or a metric value based on an hour, relative to other times in the same day of the week.

Z Chart

Unable to render embedded object: File (chart_z.gif) not found.

This allows you to display trends over time by charting a line for data, accumulative total, and moving total.

Trellis

Unable to render embedded object: File (chart_trellis.gif) not found.

This allows you to segment the chart by multiple categories on each axis.

Chart Data Options

Unknown macro: {styleclass}

[top]

Funnel, Radar, Waterfall, and Z Charts

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

Event Chart

Option

Description

Label

Time value

Value

Metric shown in the line (the top of the chart)

Event

Binary values that signify if the event was occurring on each of the time values.

Trellis Chart

Option

Description

Column

You may select up to two different fields to use as columns in your trellis.

Row

You may select up to two different fields to use as rows in your trellis chart.

Colour

You can select one field to split your values by colour.

Size

When you have a scatter plot trellis you will also be able to select a metric to use for the size of the bubbles.

Note: at least one of either the Column or Row fields selected must be a metric.

Funnel Chart Creation

Unknown macro: {styleclass}

[top]

 Click here to expand...

1. Click on the Create link to begin creating your chart.

Unable to render embedded object: File (1.png) not found.

2. You should now be on the Initialise Report page. Leave the Drag and Drop Builder selected as the build tool.

3. Select Ski Team as the Database View (if not already selected).

4. Now click either the Unable to render embedded object: File (step_right_on.png) not found. or Click here to continue button to proceed.

Unable to render embedded object: File (2.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.

Unable to render embedded object: File (3.png) not found.

6. On the Report Data page, drag and drop the Unable to render embedded object: File (rpt_dim.png) not found. Booking Step and Unable to render embedded object: File (rpt_dim.png) not found. Athlete ID fields into the Column Fields area.

7. Drag and drop the Unable to render embedded object: File (rpt_dim.png) not found. Booking Status field into the Filters area.

8. Select the Unable to render embedded object: File (rpt_dim.png) not found. Athlete ID field and add a Unable to render embedded object: File (count.png) not found. Count aggregation to it.

9. Click on Unable to render embedded object: File (step_right_on.png) not found. at the top of the page.

Unable to render embedded object: File (27.png) not found.

10. On the Filters page, set Booking Status to be Equal to.

11. Click on the Unable to render embedded object: File (rpt_filterprompt.gif) not found. 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.

Unable to render embedded object: File (submit.png) not found.

14. Click on Unable to render embedded object: File (step_right_on.png) not found. at the top of the page.

Unable to render embedded object: File (29.png) not found.

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.

Unable to render embedded object: File (save.png) not found.

Unable to render embedded object: File (30.png) not found.

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.

Unable to render embedded object: File (refresh.png) not found.

Unable to render embedded object: File (31.png) not found.

22. You should now have a chart that looks like the one pictured here.

Unable to render embedded object: File (32.png) not found.

23. You now need to Save and Activate your chart. Click on the Close button to go back to the Report Preview page.

Unable to render embedded object: File (menu_close.png) not found.

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.

Unable to render embedded object: File (activate.png) not found.

Unable to render embedded object: File (33.png) not found.

Radar Chart Creation

Unknown macro: {styleclass}

[top]

 Click here to expand...

1. Start creating a chart as you did with the other charts by clicking on the Create link.

2. On the Report Data page, drag and drop the Unable to render embedded object: File (rpt_dim.png) not found. Camp Demographic dimension, Unable to render embedded object: File (rpt_metric.png) not found. Profit Margin, Unable to render embedded object: File (rpt_metric.png) not found. Invoiced (Pref Currency) metrics into the Column Fields.

3. Change the aggregations on both of the metrics to Unable to render embedded object: File (avg.png) not found. Average, using the same steps as before, selecting Average rather than Count.

4. Make sure that you select the Chart Only option as you have for the other charts.

5. 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 (34.png) not found.

6. On the Report Preview page click on the Pie Chart image as before.

7. Click on the Chart Menu and select Special Purpose as the Chart Type and Radar as the subtype (click on the picture in the middle).

8. Click Save to load the options for a Radar Chart.

Unable to render embedded object: File (save.png) not found.

Unable to render embedded object: File (35.png) not found.

9. Set the Label to Camp Demographic.

10. Select Avg Profit Margin and Avg Invoiced (Pref Currency) as the Series.

11. Click Refresh to generate your chart.

Unable to render embedded object: File (refresh.png) not found.

Unable to render embedded object: File (36.png) not found.

12. You should now have a chart that looks like this.

Unable to render embedded object: File (37.png) not found.

13. Click on the Gridlines Menu and set the Show Gridlines option to Yes.

14. Click Save.

Unable to render embedded object: File (save.png) not found.

Unable to render embedded object: File (38.png) not found.

15. Click on the Labels Menu and set the Labels option to Yes.

16. Click Save.

Unable to render embedded object: File (save.png) not found.

Unable to render embedded object: File (39.png) not found.

17. You should now have a chart that looks like the one pictured here. Each line should have a label corresponding to a Camp Demographic, and the gridlines should now be visible.

18. You are now finished with this chart so Save and Activate it.

Unable to render embedded object: File (40.png) not found.

19. Click on the Close button to go back to the Report Preview page.

Unable to render embedded object: File (menu_close.png) not found.

20. Click on the Save Menu and use Radar Chart Tutorial as the Name.

21. Type This Radar Chart was created using the Charts Tutorial as the Description.

22. Enter Tutorial as the Category and Charts as the Sub Category.

23. Click Activate.

Unable to render embedded object: File (activate.png) not found.

Unable to render embedded object: File (41.png) not found.

Event Chart Creation

Unknown macro: {styleclass}

[top]

 Click here to expand...

1. Click on the Create link to begin creating your chart.

Unable to render embedded object: File (1.png) not found.

In order to complete this tutorial you will need to import some sample data to use. Make sure you have a writable data source prepared.

2. You should now be on the Initialise Report page. Select the Spreadsheet/CSV Import option.

3. Select your writable data source in order to store the spreadsheet data.

4. Select a view category

5. Select the [^EventChartSample.csv] file.

6. 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 (eventLoad.png) not found.

7. You should now see the spreadsheet preview (as pictured here). Select Report as the category for each of the columns.

8. Set the spreadsheet name to be Event Chart Sample and the description to Tutorial Data.

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 (eventImport.png) not found.

10. 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.

11. 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 Report category to expand it.

12. Drag and drop EventDate, SocialMediaCampaign, OnlineCampaign, PaperCampaign, and WebsiteHits fields into the Columns area.

13. 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 (45.png) not found.

14. You should now be on the Report Preview page. Click on the image of a Pie Chart (pictured here) to go to the Chart Format page where you can setup your chart.

Unable to render embedded object: File (ChartClick.png) not found.

15. Click on the Chart Menu, select Special Purpose as the Chart Type and click on the picture of the Event Chart to select it.

16. Click Save, this will load the options for an Event Chart.

Unable to render embedded object: File (save.png) not found.

Unable to render embedded object: File (46.png) not found.

17. In the Chart Data section you will need to select the data for each setting in the chart.

18. Set the Label to EventDate, set the Value to WebsiteHits, and select the Events; SocialMediaCampaign, OnlineCampaign, and PaperCampaign.

19. Click the Refresh link to generate your chart.

Unable to render embedded object: File (refresh.png) not found.

Unable to render embedded object: File (47.png) not found.

20. You should now have a chart that looks like the one pictured.

21. You now need to Save and Activate your chart. Click on the Close button to go back to the Report Preview page.

Unable to render embedded object: File (menu_close.png) not found.

Unable to render embedded object: File (48.png) not found.

22. Click on the Save Menu and use Event Chart Tutorial as the Name.

23. Type This Event Chart was created using the Charts Tutorial as the Description.

24. Enter Tutorial as the Category and Charts as the Sub Category.

25. Click Activate.

Unable to render embedded object: File (activate.png) not found.

Unable to render embedded object: File (49.png) not found.

Week Density Chart Creation

Unknown macro: {styleclass}

[top]

 Click here to expand...

1. Click on the Create link to begin creating your chart.

Unable to render embedded object: File (1.png) not found.

In order to complete this tutorial you will need to import some sample data to use. Make sure you have a writable data source prepared.
2. You should now be on the Initialise Report page. Select the Spreadsheet/CSV Import option.

3. Select your writable data source in order to store the spreadsheet data.

4. Select a view category

5. Select the [^WeekDensityChartSample.csv] file.

6. 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 (weekLoad.png) not found.

7. You should now see the spreadsheet preview (as pictured here). Select Report as the category for each of the columns.

8. Set the spreadsheet name to be Week Density Chart Sample and the description to Tutorial Data.

9. Change the Transaction ID field to a Dimension and ensure the Transaction Time field is recognised as a Timestamp.

10. 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 (weekImport.png) not found.

11. 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.

12. 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 Report category to expand it.

13. Drag and drop Transaction Time, Transaction ID, and Transaction Value into the Columns area.

14. Apply a Count Distinct to the Transaction ID and Sum to the Transaction Value fields.

15. 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 (51.png) not found.

16. You should now be on the Report Preview page. Click on the image of a Pie Chart (pictured here) to go to the Chart Format page where you can setup your chart.

Unable to render embedded object: File (ChartClick.png) not found.

17. Click on the Chart Menu, select Special Purpose as the Chart Type and click on the picture of the Week Density Chart to select it.

18. Click Save, this will load the options for an Event Chart.

Unable to render embedded object: File (save.png) not found.

Unable to render embedded object: File (52.png) not found.

19. In the Chart Data section you will need to select the data for each setting in the chart.

20. Set the Label to Transaction_Time, set the Series to Count Distinct: Transaction_ID or Sum Transaction_Value.

21. Click the Refresh link to generate your chart.

Unable to render embedded object: File (refresh.png) not found.

Unable to render embedded object: File (53.png) not found.

22. You should now have a chart that looks like the one pictured.

23. You now need to Save and Activate your chart. Click on the Close button to go back to the Report Preview page.

Unable to render embedded object: File (menu_close.png) not found.

Unable to render embedded object: File (54.png) not found.

24. Click on the Save Menu and use Week Density Chart Tutorial as the Name.

25. Type This Week Density 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.

Unable to render embedded object: File (activate.png) not found.

Unable to render embedded object: File (55.png) not found.

Waterfall Chart Creation

Unknown macro: {styleclass}

[top]

 Click here to expand...

The waterfall chart is used to display cummulative values of a series. In this tutorial, you are going to examine the total invoiced amount for 2009, split by month.

1. Start creating a chart as you did with the other charts by clicking on the Create link.

2. On the Report Data page, drag and drop the Unable to render embedded object: File (rpt_dim.png) not found. Month dimension and Unable to render embedded object: File (rpt_metric.png) not found. Invoiced (Pref Currency) metric into the Column Fields.

3. Drag and drop the Unable to render embedded object: File (rpt_dim.png) not found. Year dimension into the Filters section.

4. Make sure that you select the Chart Only option as you have for the other charts.

5. Click on Unable to render embedded object: File (step_right_on.png) not found. at the top of the page.

Unable to render embedded object: File (56.png) not found.

6. On the filters page leave the Year set to Equal to and click on the Unable to render embedded object: File (rpt_filterprompt.gif) not found. icon to select 2009.

7. 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 (57.png) not found.

8. On the Report Preview page click on the Pie Chart image as before.

9. Click on the Chart Menu and select Special Purpose as the Chart Type and Waterfall as the subtype (click on the picture on the right).

10. Click Save to load the options for a Radar Chart.

Unable to render embedded object: File (save.png) not found.

Unable to render embedded object: File (58.png) not found.

11. Set the Label to Month.

12. Select Sum Invoiced (Pref Currency) as the Series.

13. Click Refresh to generate your chart.

Unable to render embedded object: File (refresh.png) not found.

Unable to render embedded object: File (60.png) not found.

14. You should now have a chart that looks like this. You now need to Save and Activate your chart.

Unable to render embedded object: File (61.png) not found.

15. Click on the Close button to go back to the Report Preview page.

Unable to render embedded object: File (menu_close.png) not found.

16. Click on the Save Menu and use Waterfall Tutorial as the Name.

17. Type This Waterfall Chart was created using the Charts Tutorial as the Description.

18. Enter Tutorial as the Category and Charts as the Sub Category.

19. Click Activate.

Unable to render embedded object: File (activate.png) not found.

Unable to render embedded object: File (62.png) not found.

Trellis Chart Creation

Unknown macro: {styleclass}

[top]

 Click here to expand...

The trellis chart is a type of combination chart that changes depending on the combination of column and row segmentations selected.

1. Start creating a chart as you did with the other charts by clicking on the Create link.

2. On the Report Data page, drag and drop the Unable to render embedded object: File (rpt_dim.png) not found. Demographic, Unable to render embedded object: File (rpt_dim.png) not found. Gender, Unable to render embedded object: File (rpt_metric.png) not found. Age at Camp, and Unable to render embedded object: File (rpt_dim.png) not found. Athlete ID fields into the Column Fields.

3. You will need to remove the aggregation from Avg Age at Camp by selecting the field and clicking the Unable to render embedded object: File (clear.png) not found. Clear button. You will also have to apply the Unable to render embedded object: File (countdistinct.png) not found. Count Distinct aggregation to the Athlete ID field.

4. Make sure that you select the Chart Only option as you have for the other charts.

5. Click on Unable to render embedded object: File (step_right_on.png) not found. at the top of the page.

Unable to render embedded object: File (63.png) not found.

6. On the Report Preview page click on the Pie Chart image as before.

7. Click on the Chart Menu and select Special Purpose as the Chart Type and Trellis as the subtype (click on the picture on the right).

8. Click Save to load the options for a Trellis Chart.

Unable to render embedded object: File (save.png) not found.

Unable to render embedded object: File (64.png) not found.

9. Set the Columns to Age at Camp and Demographic.

10. Select Row to Count Distinct Athlete ID.

11. Set the Colour to Gender.

12. Click Refresh to generate your chart.

Unable to render embedded object: File (refresh.png) not found.

Unable to render embedded object: File (65.png) not found.

13. You should now have a chart that looks like this. You now need to Save and Activate your chart.

Unable to render embedded object: File (66.png) not found.

14. Click on the Close button to go back to the Report Preview page.

Unable to render embedded object: File (menu_close.png) not found.

15. Click on the Save Menu and use Trellis Tutorial Tutorial as the Name.

16. Type This Trellis Chart was created using the Charts Tutorial as the Description.

17. Enter Tutorial as the Category and Charts as the Sub Category.

18. Click Activate.

Unable to render embedded object: File (activate.png) not found.

Unable to render embedded object: File (67.png) not found.

Z Chart Creation

Unknown macro: {styleclass}

[top]

 Click here to expand...

The Z Chart is a specially designed line chart used for period comparisons.

1. Start creating a chart as you did with the other charts by clicking on the Create link.

2. On the Report Data page, drag and drop the Unable to render embedded object: File (rpt_dim.png) not found. Month dimension, and Unable to render embedded object: File (rpt_metric.png) not found. Profit Margin metric into the Column Fields area.

3. Change the aggregation on Profit Margin to average by selecting the field and clicking on the
Unable to render embedded object: File (avg.png) not found. icon.

4. Make sure that you select the Chart Only option as you have for the other charts.

5. 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 (68.png) not found.

6. On the Report Preview page click Columns link.

Unable to render embedded object: File (69.png) not found.

7. Select Month as the Column.

8. Click on the Display Menu.

9. Set the Format to Date.

10. Select Other as the Date Format

11. Type MMMM, yy in the Format box.

12. These options will mean that instead of just displaying the Month names, Yellowfin will display the month name and then the year, eg: March, 09.

Unable to render embedded object: File (70.png) not found.

13. On the Report Preview page click on the Pie Chart image as before.

14. Click on the Chart Menu and select Line as the Chart Type and Z Chart as the subtype.

15. Click Save to load the options for a Z Chart.

Unable to render embedded object: File (save.png) not found.

Unable to render embedded object: File (71.png) not found.

16. Set the Label to be Month.

17. Set the Series to be Avg Profit Margin.

18. Click Refresh to view your chart.

Unable to render embedded object: File (refresh.png) not found.

Unable to render embedded object: File (72.png) not found.

19. Your chart should now look like this one.

Unable to render embedded object: File (73.png) not found.

20. You are now going to customise the look of your Z Chart. Click on the Chart Format Menu.

21. You are going to extend the chart so it shows 24 months worth of data at a time. When you do this, remember that Yellowfin needs double the amount of data in order to calculate the Moving Total. In this case it would need 48 months worth of data.

22. Click Save to see how these options have changed your chart.

Unable to render embedded object: File (save.png) not found.

Unable to render embedded object: File (74.png) not found.

23. Click on the Unable to render embedded object: File (option_closed.gif) not found. icon next to the Periodic Value to expand the options.

24. Set Line Shapes to Yes.

25. Set the Line Thickness to 2.

26. Repeat these steps for Cumulative Total and Moving Total.

27. Click Refresh to regenerate your chart.

Unable to render embedded object: File (refresh.png) not found.

Unable to render embedded object: File (75.png) not found.

28. Your chart should now look like the one pictured here.

29. You are now finished with this chart so Save and Activate it.

Unable to render embedded object: File (76.png) not found.

30. Click on the Close button to go back to the Report Preview page.

Unable to render embedded object: File (menu_close.png) not found.

31. Click on the Save Menu and use Z Chart Tutorial as the Name.

32. Type This Z Chart was created using the Charts Tutorial as the Description.

33. Enter Tutorial as the Category and Charts as the Sub Category.

34. Click Activate.

Unable to render embedded object: File (activate.png) not found.

Unable to render embedded object: File (77.png) not found.



Unknown macro: {horizontalrule}
Unknown macro: {styleclass}

[top]

  • No labels