Creating Custom KPIs

Every line of the data you feed into Castaway is accessible by Custom KPIs. This allows you to deliver tailor-made, immediate insights and powerful monitoring tools to your Team and Clients. This article will cover:

• Creating Account Monitor and Custom Formula KPIs
• An in-depth guide to the KPI Formula Builder 
• Organising and grouping KPIs with Categories

Create an Account Monitor KPI

Track an individual line from your accounts or Driver Data.

To create an Account Monitor KPI:

1. Go to KPIs > Setup tab
2. Click the green plus sign
3. Select Create an Account Monitor KPI
4. Name your KPI and select the account or driver you wish to track in the right-hand toolbar.
5. Click Track Account to finalise your KPI
6. To lock in any changes made in the Setup tab you must click Save KPIs
7. Once the KPI is created consider updating the higher/lower, total type and % display

Create a Formula KPI

Use the Castaway formula builder to tailor your KPI to your needs and monitor performance.

To create a Custom Formula KPI:

1. Go to KPIs > Setup tab
2. Click the green plus sign on the top of any Category Table
3. Select Create a Formula KPI
4. Name your Formula KPI and build your formula
5. Click Save to finalise your KPI
6. To lock in any changes made in the Setup tab you must click Save KPIs

Using the KPI Formula Builder

1. Name your Formula KPI
2. To input data into your formula, select the origin under the Add Data right-hand panel: Project KPIs to point to other KPIs, or Forecast Data for all your data financial data and drivers
3. Expand each section to view all the data lines, double clicking to bring it into the formula
4. Under the Forecast Data source, entire sections can be selected, also by double clicking
5. Click any of the mathematical functions to insert them into the formula
6. Bring in numerical values typing them into the Values box, or using the up and down arrows, and then confirming the value by hitting enter or clicking the green plus button
7. Castaway will tell you if your Formula is mathematically cogent and Valid, at which point it will be saveable. To remove any component of the formula click the cross in its corner
8. Once the KPI is created consider updating the higher/lower, total type and % display

For a comprehensive guide: The Formula Builder 

KPI Categories

Categories in KPIs allow you to group and organise your Custom KPIs, much like the Inbuilt KPIs. Ordering your KPIs within a category is the best way to illustrate the story of your financial and non-financial data. Reordering any KPI or Category, Custom or Inbuilt, by dragging and dropping.

Organising your KPIs in tables also brings benefits across other Castaway reports. When connecting a KPI widget into a Dashboard, the KPI Category table can be selected as a whole and will include your KPI Category title.

To add a KPI Category:

1. Go to KPIs > Setup tab
2. Click the blue plus sign
3. Input your Category Title and click the green tick
4. To lock in any changes made in the Setup tab you must click Save KPIs