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
||Option||Description||
|Label|This is the time field that will be used to identify days of the week and hours of the day.|
|Series|Typically a numeric value such as $.  An item that you want to measure on your Chart|


h2. Week Density Chart Tutorial
{styleclass: Class=topLink}[top|#top]{styleclass}
h3. Summary
In order to set up a Week Density Chart you will need:
# Create a report with chart display
## Select a field to use as the *Label*
## Select a field to use as the *Series*
# Create your chart, selecting *Special Purpose* as the type, and *Week Density* as the chart
# Provide the *Label* and *Series* 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%}
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 *CSV Import* as the build tool.
{column}
{column: width=70%}
!02.png! 
{column}
{section}

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

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