Page Comparison

{anchor:top}
{toc: class=contents}
h2. Overview
{styleclass: Class=topLink}[top|#top]{styleclass}
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.

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%}
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 *Drag and Drop BuilderCSV Import* 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 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 !step_right_on.png! at the top of the page to move to the next step.
{column}
{column:width=70%}
!2a.png!
{column}
{section}

{section}
{column:width=30%}	 
*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 !step_right_on.png! button at the top of the page to move to the proceednext step.	 
{column}
{column: width=70%}
!2a2b.png|thumbnail,border=1!

{column}
{section}

{section}
{column:width=30%}
*511.* 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.	 
{column}
{column:width=70%}
!3.png!
{column}
{section}

{section}
{column:width=30%}
*12.* Now you need to add metrics to your report. Click on the !expand.gif! 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 !step_right_on.png! at the top of the page to move to the next step.	 
{column}
{column:width=70%}
!reportData.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=30%}
*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.	 
{column}
{column:width=70%}
!ChartClick.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=30%}
*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.

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

{section}
{column:width=30%}
*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.

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

{section}
{column:width=30%}	 
*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.
{column}
{column:width=70%}
!generateChart.png|thumbnail,border=1!
{column}
{section}

{section}
{column:width=30%}
*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*.	

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

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