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

h3. Chart Data Options
||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.|

{color:#C00000}*Note:*{color} at least one of either the Column or Row fields selected must be a metric.


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.* Make sure that you select the *Chart Only* option as you have for the other charts & click on !step_right_on.png! at the top of the page.
{column}
{column:width=70%}
!3.png!
{column}
{section}

{section}
{column:width=30%}
*6.* On the Report Data page, drag and drop the !rpt_dim.png! *Age Group at Camp*, !rpt_dim.png! *Gender*, !rpt_metric.png! *Invoiced Amount*, and !rpt_dim.png! *Athlete ID* fields into the *Column Fields*.

*7.* You will need to apply the !countdistinct.png! *Count Distinct* aggregation to the *Athlete ID* field.

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

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

{section}
{column:width=30%}	 
*10.* On the Report Preview page click on the Pie Chart image as before.

*11.* Click on the *Chart* Menu and select *Analytical* as the Chart Type and *Heat Grid* as the subtype (click on the picture on the right).

*12.* Click *Save* to load the options for a *Heat Grid Chart*.

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

{section}
{column:width=30%}	 
*13.* Set the Column to *Age Group at Camp*.

*14.* Select Row to *Gender*.

*15.* Set the Colour to *Count Distinct Athlete ID*.

*16.* Set the Size to *Sum Invoiced Amount*.

*17.* Click *Refresh* to generate your chart.

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

{section}
{column:width=30%}	 
*18.* You should now have a chart that looks like this. You now need to *Save* and *Activate* your chart.	 
{column}
{column:width=70%}
!generateChart.png!
{column}
{section}

{section}
{column:width=30%}
*19.* Click on the *Close* button to go back to the Report Preview page.

*20.* Click on the *Save* Menu and use *Heat Grid Tutorial* as the Name.

*21.* Type *This Heat Grid 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*.	 

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