Page Comparison

{anchor:top}
{toc: class=contents}
h2. Create Report
{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%}
!01create.png!
{column}
{section}

{section}
{column:width=30%}
*2.* You should now be on the Initialisation page. Select the *Drag and Drop Builder* as the builder type.
{column}
{column:width=70%}
!02builderType.png!
{column}
{section}

{section}
{column:width=30%}
*3.* Select *Ski Team* as the View. This will now take you to the *Data* step of the builder.
{column}
{column:width=70%}
!03viewList.png|thumbnail,border=1!
{column}
{section}


h2. Data Setup
{styleclass: Class=topLink}[top|#top]{styleclass}
{section}
{column:width=30%}
You will now need to add the metric field to be monitored by the KPI to the report.

*4.* Drag the *Demographic* and *Invoiced Amount* fieldfields into the *Columns* list.

You will also need to provide a filter. This will ensure the data is restricted for each refresh.

*5.* Drag the *Invoiced Date* field into the *Filters* list.
{column}
{column:width=70%}
!05dataStep.png|thumbnail,border=1!
{column}
{section}


h2. Filter Setup
{styleclass: Class=topLink}[top|#top]{styleclass}
The Categorical KPI type requires a refresh schedule to be defined in order to take a snapshot of the metric value at regular points in time. This generates the trend line shown on the KPI Tab. In order to ensure each snapshot records the right range of data, a filter may need to be used as well. 

I this example we are going to set the refresh schedule to run on the first of each month. This means that we want the snapshot to capture a month's worth of data. In order to set this up we will add a filter to restrict the results to last month's data.
{section}
{column:width=30%}
*6.* Click on the *Settings* link in order to set up the filter.
{column}
{column:width=70%}
!06filterSettings.png!
{column}
{section}
{section}
{column:width=30%}
*7.* Click on the *Define Value* option and make use of the *Pre-Defined Period* option, selecting *Last Month*.

*8.* Click the *Submit* button.
{column}
{column:width=70%}
!07filterLogic.png|thumbnail,border=1!
{column}
{section}


h2. KPI Setup
{styleclass: Class=topLink}[top|#top]{styleclass}
{section}
{column:width=30%}
You will now need to navigate to the *Output* step of the builder to configure the KPI options.

*9.* Click the *Output* option in the main navigation bar.
{column}
{column:width=70%}
!08reportOutput.png!
{column}
{section}
{section}
{column:width=30%}
*10.* Click on the *KPI* menu from the main navigation bar on the *Output* step of the builder.
{column}
{column:width=70%}
!09KPImenu.png!
{column}
{section}

h3. Categorical
KPI reports require several components to be defined that are not required by standard reports. The metric to be monitored must be configured first.
{section}
{column:width=30%}
*11.*  To begin, enable the *KPI Functionality* option. This will show all the components required for the KPI.

*12.* Set the *KPI Type* to *Categorical*. 

*13.* Set the *Keyed On* to *Demographic*.

*14.* Set the *KPI Metric* to *Sum Invoiced Amount*.

*1415.* Set the *Desired Trend* to *Up*.

*1516.* Set the *Target Type* to *Manual* and the *Target* to *15000000*.
{column}
{column:width=70%}
!10KPIsetup.png|thumbnail,border=1!
{column}
{section}

h3. KPI Alerts
The next component required for KPI reports is the Conditional Formatting Alerts displayed to the left of the kpi on the Dashboard. This icon or colour displays an alert for the current status of the value.
{section}
{column:width=30%}
*1617.* Click on the *Setup* section to open the settings available. 

In this example we will be defining alerts using the icons. You can also use the Cell or Text options if you just wish to display a block of colour rather than an image.

*1718.* Set the *Style* to *Icon* and select the *Ticks* option as the *Icon Set*.

*1819.* Define the *Type* as *Value*. This will mean that the value in the cell is compared to the alert values to check the rule, rather than another field or function.

*1920.* Click on the *Alerts* section to open the alert rules list. This is where you will define the conditions.

*2021.* Create three alerts:
* Red Less than 12000000
* Orange Between 12000000 and 15000000
* Green Greater than 15000000
{column}
{column:width=70%}
!11KPIalert.png|thumbnail,border=1!
{column}
{section}

h3. KPI Refresh Schedule
{section}
{column:width=30%}
*2122.* Click the *Refresh* section to open the scheduling area. In standard reports the refresh schedule is defined in the Save menu, but KPI reports use the KPI menu instead.

*2223.* Set the *Refresh Settings* to be updated *Periodically*.

*2324.* Set the Schedule to be the *First day of each Month*.

*2425.* Close the KPI menu by clicking on the *x* in the top right corner of the menu.
{column}
{column:width=70%}
!12KPIschedule.png|thumbnail,border=1!
{column}
{section}


h2. Report Save
{styleclass: Class=topLink}[top|#top]{styleclass}
In order to complete the report and activate it the Save menu will need to be completed.
{section}
{column:width=30%}
*2526.* Click on the *Report* > *Save* option through the main navigation bar of the *Output* step.

*2627.* Set the Name to *KPI Categorical Report Tutorial*. 

*2728.* Type *This report was created as part of the KPI Report tutorial* into the Description box.  

*2829.* Set the *Category* to *Tutorial* and the *Sub Category* to *Training*.

*2930.* Click *Activate*.
{column}
{column:width=70%}
!13save.png|thumbnail,border=1!
{column}
{section}

Your KPI report is now complete and ready to be added to a KPI Dashboard Tab.
bq. See [KPI Tabs] for more information.

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