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}
Plots the intensity of a metric across multiple categories.

h3. Chart Data Options
||Option||Description||
|ColumnHorizontal Axis|You may select up to two different fields to use as columns in your trellis.|
|RowVertical Axis|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. Heat Grid Tutorial
{styleclass: Class=topLink}[top|#top]{styleclass}

h3. Summary
In order to set up a Heat Grid Chart you will need:
# Create a report with chart display
## Select field(s) to use as the *RowHorizontal Axis*
## Select field(s) to use as the *ColumnVertical Axis*
## Select a field to use as the *Colour* (optional field)
## Select a field to use as the *Size* (optional field)
# Create your chart,  selecting *AnalyticalHeat Grid* as the type, under andthe *Heat GridAnalytical* asheading
the chart
# Provide the *RowHorizontal Axis*, *ColumnVertical Axis*, *Colour*, and *Size* options and
*Refresh*
# Customise the Chart as required
# *Close* the Chart Builder
# *Save* your report

h3. Tutorial
{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}Proceed to the *Output* step
# *Save* your report

\\
\\
{horizontalrule}
{styleclass: Class=topLink}[top|#top]{styleclass}