Page History

1. Click on the Create link and select Report to begin building your report.

2. You should now be on the Initialisation page. Select the Drag and Drop Builder as the builder type.

3. Select Ski Team as the View. This will now take you to the Data step of the builder.

You will now need to add the metric field to be monitored by the KPI to the report.

4. Drag the Invoiced Amount field 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.

6. Click on the Settings link in order to set up the filter.

7. Click on the Define Value option and make use of the Pre-Defined Period option, selecting Last Month.

8. Click the Submit button.

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.

10. Click on the KPI menu from the main navigation bar on the Output step of the builder.

11. To begin, enable the KPI Functionality option. This will show all the components required for the KPI.

12. Set the KPI Type to Spot.

13. Set the KPI Metric to Sum Invoiced Amount.

14. Set the Desired Trend to Up.

15. Set the Target Type to Manual and the Target to 15000000.

16. 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.

17. Set the Style to Icon and select the Ticks option as the Icon Set.

18. 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.

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

20. Create three alerts:

• Red Less than 12000000
• Orange Between 12000000 and 15000000
• Green Greater than 15000000

21. 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.

22. Set the Refresh Settings to be updated Periodically.

23. Set the Schedule to be the First day of each Month.

24. Close the KPI menu by clicking on the x in the top right corner of the menu.

25. Click on the Report > Save option through the main navigation bar of the Output step.

26. Set the Name to KPI Spot Report Tutorial.

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

28. Set the Category to Tutorial and the Sub Category to Training.

29. Click Activate.