Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Wiki Markup
{anchor:top}
{toc: class=contents}
h2. Overview
{styleclass: Class=topLink}[top|#top]{styleclass}
A scatter plot (points not joined) chart that allows the charting of 2 related attribute series.  Can only be used if the data series are related.  Useful for finding outliers in data that is not linear.

h3. Chart Data Options



h2. Tutorial
{styleclass: Class=topLink}[top|#top]{styleclass}

{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.* On the *Step 1. Report Data* page 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:widhth=70%}
!3.png!
{column}
{section}

{section}
{column:width=30%}	 
*6.* As you want to see each individual camp rating in our Histogram you will need to enable the display of Duplicate Records.

*7.* To do this, expand the *Report Data* section and enable the *Show Duplicate Records* option.	 
{column}
{column:widhth=70%}
!89.png!
{column}
{section}

{section}
{column:width=30%}
*8.* On the Report Data page, drag and drop the !rpt_dim.png! *Gender* dimension, and !rpt_metric.png! *Camp Rating* metric into the Column Fields area.

*9.* Add the !rpt_metric.png! *Camp Rating* metric to the Filters area as well.

*10.* You will need to remove the aggregations on both copies of the !rpt_metric.png! *Camp Rating* fields by selecting each one individually and clicking on the !clear.png! Clear button.

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

{section}
{column:width=30%}
*12.* Next you will need to setup a filter to remove results with a Camp Rating of zero. This is because when athletes cancel their booking and don't attend a camp their Camp Rating defaults to 0.

*13.* Set the filter to *Camp Rating* Different from *0*.

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

{section}
{column:width=30%}
*15.* You should now see the Pie Chart image (pictured here). Click on the image to go to the Chart Format page where you can setup your chart.	 
{column}
{column:widhth=70%}
!ChartClick.png!
{column}
{section}

{section}
{column:width=30%}
*16.* Click on the *Chart* Menu, select *StatisticalAnalytical* as the Chart Type and click on the picture of the *Histogram* Chart to select it. 

*17.* Click *Save*, this will load the options for a Histogram Chart.	

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

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

*19.* Set the Series to *Camp Rating*.

*20.* Click the *Refresh* link to generate your chart.

!refresh.png!
{column}
{column:widhth=70%}
!setData.png!
{column}
{section}

{section}
{column:width=30%}	 
*21.* You should now have a chart that looks like the one pictured. 

*22.* You may want to try setting the Colour to *Gender* in order to layer the histogram.
{column}
{column:widhth=70%}
!generateHistogram1.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=30%}	 
*23.* You should have a layered Histogram that looks like this.

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

{section}
{column:width=30%}
*25.* Click on the *Save* Menu and use *Histogram Chart Tutorial* as the Name.

*26.* Type *This Histogram Chart was created using the Charts Tutorial* as the Description.

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

*28.* Click *Activate*.	

!activate.png! 
{column}
{column:widhth=70%}
!saveHistogram.png|thumbnail,border=1!
{column}
{section}
\\
\\
{horizontalrule}
{styleclass: Class=topLink}[top|#top]{styleclass}