In This Article

Editing a KPI

Configuration 

Calculation

Access

Next Steps


Overview

Now that you have successfully created a KPI (for reference, see - Add a KPI). In this article on editing a KPI, you will find a guide on how to edit and customize a KPI. This is for the purpose of offering flexibility to adapt to changing business goals and strategies, make real-time adjustments based on current data, and continuously improve performance measurement. We will address the following topics: Configure the Settings, KPI Calculation and how to set the required Access for the KPI.


Editing a KPI

Navigate to Analysis > KPIs, then click on the Name of the KPI you want to edit. This will open to one of the KPI Toolbar sections. Next, follow these steps in the Configuration toolbar settings:


Configuration 



Navigate to the Configuration toolbar settings on the three-bar menu. This will open the Configuration settings screen, similar to the screenshot above. Then, navigate to the Settings section towards the bottom of the screen. Expand the Settings section by clicking on the drop-down arrow to view the options, similar to the screenshot below:



On the following Settings screen, you can specify the 1Baseline Start Date and 2Baseline End Date to define the data display duration, alongside selecting the reporting 3Target Frequency for the KPI (for further explanation of the Impact of Target Frequency, please see this article: Target Frequency Explained). You can also set the 4Performance Period. The Performance Period is used to calculate the value of a KPI (actual and target) for a period relative to a reporting date. The calculated actual and target values for the period are compared and used to determine the status of the KPI. In addition, you can also specify the number of 5Decimal places to display as well as check the 6Allow Zeros box to display fields with zero values on the chart. The settings also include the options to determine the 7Number of Bars to display on the chart for each field. Additionally, you can check additional boxes under the different 8Time Periods to include extra data on the chart as well set minimum and maximum amounts for the chart display under 9Chart Options. Enabling the 10Do you want to specify performance ranges option allows you to set Below Target and Above Target figures on the chart to indicate if the data is on track or at risk. Enabling this option displays the following screen below:



Calculation


Convert the KPI to a calculated KPI by adding references and specifying the applicable formula to be used. A Calculated Key Performance Indicator (KPI) provides a more comprehensive and insightful measurement of specific aspects of an organization's performance by combining or manipulating existing data. Calculated KPIs are designed to offer a deeper understanding of various processes, operations, or objectives within a business.


In the same Configuration toolbar settings, navigate to the Calculation section towards the bottom of the screen. Expand the Calculation section by clicking on the drop-down arrow to view the options, and tick on the check-box for Do you want to create a calculated KPI. This opens a section similar to the screenshot below:

If you would like to manually capture 1Targets, 2Baselines, and 3Forecasts, check the respective boxes. To select the KPIs you want to use, click on 4+Add option under Formula References. This opens the screen similar to the screenshot below. You can search for the KPI by name, owner, or portfolio. Once you have found the desired KPI, click on it, then click the add button. Repeat these steps to add multiple KPIs.


Note: To create a calculated KPI, you are only able to add KPIs from the current site



Once these KPIs have been added, they will appear under the 1Formula References section in the Configuration screen. These KPIs may now be used in the creation of a formula for the calculated KPI. You can then 2enter the formula to calculate the new KPI, such as subtracting B from A to get the difference of the values, followed by clicking 3Test Formula to confirm whether the arithmetic is correct. With these configurations and values, the new calculation methods will generate a value for the calculated formula (see screenshot below for reference). The values of this KPI will be automatically calculated and will appear as read-only on the KPI values section. 


Warning: Remember to click Save at the top right to avoid changes being lost.



Access




Under Configuration toolbar section, click on the 1Access tab towards the end of the screen to expand the section. Under Access, select one of the following options, 2Default and 3Confidential are customisable, while choosing 4Global will grant access to everyone. The 5Name of the User or Role will be displayed here, and Type will indicate whether the permission is for a User or a Role. To add specific Users or Roles to the access profile, click 6+Add and search for them.


Warning: Remember to click Save at the top right to avoid changes being lost.

Next Steps


Now that KPI has been created and edited the next stop is to add values to your KPI, see article KPI Values.