Link indicator to form (update based on form data)

• What is the purpose of linking an indicator to a form?
• How do you link an indicator to a form?
• How do we update the indicator's value?
  • Example
• Example: Percentage (numerator/denominator)
• Example: Unicity field
• Example: Disaggregated indicator
• Various examples

When an indicator is linked to a form, the indicator's value can be calculated based on the data contained in a custom form.

For example, suppose the indicator is "% of participants satisfied with the training," this information is available in a "training evaluation form." In that case, linking it to this form may be helpful so that LogAlto can calculate the indicator's value.

This will reduce the risk of errors by manually inputting the values to the indicator.

• Open the indicator configuration panel.
• Check the "Link to custom form" box.

• Select the form that contains the data to be used to calculate the indicator.
• Select a calculation method:
  • Sum: This method will add all the records' values in the form.
  • Percentage: This method calculates a rate for specific values in your form (see the example in a section below).
  • Count:  This method counts the number of records entered, regardless of value.
  • Average: This method will take all the records and make an average of the values
• Select a unicity field: select a field to ensure that certain items are unique and are not counted twice. This field is optional.
• If the calculation method is Sum or Average, Select a Value field.
• Other fields appear if your indicator is disaggregated, allowing you to match the form fields to your indicator categories.
• The filter can also be added (so that only records corresponding to the filters will be used in the calculation).
• Save the indicator form once the link has been configured.

Once you have configured your indicator, if you want to update the indicator value:

• Open the logframe
• Click the “Data Entry” tab. 
• When you click on the cell, a calculator icon will appear.

• When you click on the calculator icon, a window opens:

• You can use all the data or only those entered before a specific date.
• Finally, click on "Calculate and apply".

In our example, we will create a form called “Zoo,” in which we want to know how many elephants and lions are in each zoo and their gender.

• Create your form.

• Link the form you wish to disaggregate in the indicator menu.

• In your custom form, you will need to make sure the data matches correctly to what's in your system list. In our example, we'll go to the system list and add our animals. Add the disaggregation to your system list.

• Choose your disaggregation from the indicators menu. Make sure that the disaggregation corresponds correctly to your forms. In our example, we want to disaggregate our data by animal and gender, as shown below.

• You must select the calculation method as sum or average to obtain your disaggregation.

  

• You can choose your preferred method, either by disaggregation or by category. 

By category: allows the user to choose a calculation method and value field for each item/category, corresponding to the value in the customized form.

By disaggregation: allows the user to match the disaggregation with the form field. An example is gender. Users wish to check the list of gender systems in the custom form.

• Go to data entry.

• In your indicator, you should see the selected disaggregation.

• Fill it out automatically by clicking on the calculator symbol. This will feed the indicator the data found in the form.

• We can see that the values correspond to the sum of the forms.

If you select "Percentage," you must specify the numerator and denominator.

The indicator value is then calculated as 100 x A/B (or 100 X Numerator/Denominator).

• A is the numerator (small group = those who meet the conditions)
• B is the denominator (larger group = all elements).

Example: the indicator is the percentage of female beneficiaries earning more than 200 USD annually.

• Calculation = 100 X Numerator/Denominator
• Numerator = female beneficiaries with annual income over 200 = 60
• Denominator = female beneficiaries = 300
• The indicator value is 100x(60/300) = 20%.

• 100 participants have attended three courses (=300 records in the participation form)
• 350 participants attended one course (=350 records in the participation form)
• 50 participants did not attend the course (=0 records in the attendance form)

• Suppose you want to count each participant who attended only once (=100+350=450). In this case, the unicity field is the "participant ID."
• OR if you want to count each attendance (=300+350=650). In this case, the unicity field is left empty.

The form is: Beneficiaries who participated in trainings

1. In the project logframe, we click the pen icon next to the corresponding indicator. 
2. In the indicator's configuration panel, we make sure to disaggregate the indicator if necessary (in the example, we need to disaggregate by gender).
3. Check the “Link to custom form” box. 
4. From the list of custom forms, we select the "Beneficiaries who participated in training" form.

Various examples

Here are some examples of the indicators supported by this link and how to configure them: