...
Calculated Indicators enable organizations to perform mathematical calculations from two or more source Project Indicators. For example, an organization might need to track the percentage of a population that was vaccinated with the formula (Number of people vaccinated/Total population)* 100. In this example, they used the results from two other (source) Project Indicators to perform the calculation.
...
Here are a couple of common terms we’ll use when setting up and managing Aggregated Calculated Indicators in Amp Impact:
Term | Description |
|---|---|
Calculated Project Indicator | A project indicator for which results are calculated by using source project indicator(s) in a mathematical formula. The operations available to create formulas are ‘+,’ ‘-,’ ‘*,’ and ‘/.’ Users may choose these operations from a dropdown picklist or may type them directly into the formula box. In addition to this, users may also type numbers or decimal points into the formula box. |
Dependent Calculated Project Indicator | A calculated project indicator that includes one or more calculated indicators in its formula. |
Source Project Indicator | A project indicator for which results are entered directly by the user on the AddResults page. This type of project indicator is used in the formula/calculation for a calculated project indicator. |
Batch | Users can run batches to process a bulk amount of data. “Batch is used to run large jobs (think |
Create Calculated Project Indicators
| Status | ||||
|---|---|---|---|---|
|
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
Calculated Indicators are only available as a LWC from Kalausi (v1.34) or later. If your organization is using the Visualforce ManageIndicators page, the interface will be slightly different. The logic for setting up Calculated Indicators is still the same. Reach out to your System Administrator if you have questions about creating Aggregated Indicators. |
| Info |
|---|
System Admin Note: If you want to use Calculated Indicators functionality in Lightning Web Component make sure ‘Lightning Web Security for Lightning web components and Aura Components’ is enabled in ‘Session settings’. |
Calculated Project Indicators can be set up for any numeric Project Indicator. This feature enables organizations to perform the following functions:
...
Here are the steps to create Project Indicators.
...
When creating source Project Indicators ensure that they:
have the same reporting frequency,
have the same geographic level, and
have the same level of disaggregation as the intended Calculated Indicator.
Create a Calculated Project Indicator
...
Navigate to the Manage Indicators page and click on the “Add New Custom Indicator” button.
For the “Data Type” field select from Number, Currency, or Percent. For Fill out the fields in the popup and select “Calculated” for the “Type of Results” field select Calculated. Fill out other required information to create a new Project Indicator.
...
.
Remember that the “Data Type” can only be Number, Percent or Currency when setting up Calculated Indicators.
On clicking “Save and Next”, the Calculation Formula popup will appear where user you can create the formula used to calculate results for this Project Indicator.
...
Once the Calculation Formula popup opens, the user can either create a formula immediately or select “Cancel”. Selecting “Cancel” will save the Project Indicator with no calculation formula, allowing the user to return and set the formula at a later time.
In the Calculation Formula popup, use the “Select Indicator”picklist to select the first source Project Indicator. Only active Project Indicators with the same geographic level, reporting frequency, and disaggregation level are shown in the picklist.
Use the “Select an Operation”picklist to select the desired operation.
...
Continue navigating between the dropdown and select additional Project Indicators or operators as needed. Users You can also enter numerical values from their keyboards to create more complex formulas as well.
...
Click on the “Edit” option in the dropdown located next to the particular Project Indicator in the “Selected Indicators”table.
In the popup, edit the field you want to, (for example: Guideline). In order to edit the Calculation Formula, click on “Save and Edit Calculation
...
We do not recommend editing the following fields once Results have been created for a particular indicator since it might lead to data inconsistencies.
...
Disaggregation by group
...
This will This will` open the “Customize Calculation” popup where the source indicators or operators can be edited.
Once a Project Indicator is deactivated, it cannot be used in the formula for a calculated Project Indicator. The calculation formula popup will not display the deactivated source Project Indicator when the user clicks into the search bar to create the formula. If the user types a deactivated Project Indicator in the search bar, the message “No matching records found” will display in the dropdown.
...
While the batch is processing, users will not be able to submit or update the results for these indicators. The “Submit Results” and “Update Results” buttons will be greyed out.
A clock icon will be displayed next to the Calculated and Aggregated Indicators to display that they are being updated.
| Info |
|---|
We recommend users to refrain from editing indicators and updating their results via the MaangeIndicator page while the the batch is running. |
The user is notified via email when the batch is complete and results are updated.
A success message is displayed once the batch is updated. The buttons will display again and users can refresh the Add Results page to see the most accurate results. The last calculation date field will also be updated.
| Info |
|---|
Time to wait: We recommend that users don’t edit or update results for Calculated and Aggregated Indicators indicators via ManageIndicators while the results are being updated. Users can navigate away from the AddResults screen until the batch is completed. |
...
Create & Manage Calculated Indicators
| Status | ||||
|---|---|---|---|---|
|
The logic for creating Aggregated Calculated Indicators from the Visualforce page is similar to the LWC described above. The only difference is the user interface for some of the steps:
The “Add New Custom Indicator” and “Aggregation Criteria” Formula popups have a slightly different interface.
To edit a Calculated Indicator from the Visualforce page, users can click on the “wrench icon” next to the corresponding indicator.
To update results for a single Calculated Indicator from the Visualforce page, users can click on the “refresh icon” next to the corresponding indicator.
Users can also update results for all Calculated and Aggregated Indicators using the “Refresh Indicators” button from the Manage Indicators page.
On the pop-up select “Calculated” to update results for only Calculated Indicators
...