Indicator disaggregation

For the purpose of this article, disaggregations and categorizations refer to the same concept. 

LogAlto allows to disaggregate:

  • The indicator's values 
  • The indicator's baseline
  • The indicator's target(s)

Disaggregating an indicator means that the indicator's value (and/or baseline/targets) is  broken down into categories (example: Number of x by gender...by district...by age group). 

This broken down data can later be aggregated to get the overall value for the indicator.

In this article you will learn:

  1. When is it useful to disaggregate an indicator?
  2. How to configure disaggregation for an indicator with 1 disaggregation?
  3. How to configure disaggregations for an indicator with multiple disaggregations?
  4. How to enter disaggregated values for the baseline?
  5. How to enter disaggregated values for the target(s)?
  6. How to enter disaggregated actual values?
  7. Details regarding disaggregated indicators in a global logframe
  8. FAQ: Why can't I see the "disaggregation" checkbox and list of disaggregations in the indicator form?
  9. FAQ: Why can't I remove disaggregation methods?

When is it useful to disaggregate an indicator?

Disaggregating an indicator can help you to:

  • Ensure that you are on track on some requirements (i.e. inclusion & equality regarding genders/race/etc.)
  • Get more details about what is composing the indicator's value
  • Notice "trends" or understand what is influencing the indicator's value 

Most users tend to " over-disaggregate". So keep in mind these 3 questions before you decide to disaggregate:

Is this useful? 

Ask yourself: 

    • Will you use that information? Will you create analytics reports comparing the various categories? Will it influence your evaluation process?
    • For that specific indicator, if you do not have baselines and targets for each disaggregation, is it really useful to know the disaggregated values?

Is this easily feasible? 

Collecting and entering the data for each category  could require more effort or may even be impossible, depending on the source of data or method of data collection.

Is the indicator's data entry table the only place where I will be able to get that information?

If curiosity is the main reason you are disaggregating the indicator, keep in mind that you may already have the ability to get the information somewhere else anyway. 

(Example: if the indicator is related to data stored in the "Forms" module, you can aggregate by any field in your form via the Analytics module.)

If the answer is "Yes" to all 3 questions, then disaggregating the indicator is probably a great idea!


How to configure disaggregation for an indicator with only 1 disaggregation?

Step 1: enable disaggregation for this indicator

Step 2: specify the disaggregation method

  • Either A) Click "Select" to select an existing disaggregation (Available disaggregations are system or project lists. For more information, refer to this article.)
  • OR B) Click "Add new" to create a new disaggregation
  • You can delete a disagggregation by clicking the trash can icon
  • You can view the categories (items) of a disaggregation and select only a sub-set to be used to disaggregate the indicator by clicking the pen icon (for instance: you could want to disaggregated by country, but only take 3 countries into account.)

Step 3: specify how the overall value will be calculated based on disaggregated values

  • If applicable, check the "Total is automatically calculated". This setting simply sets a "default" preference. But you will still be able to calculate the value OR enter it manually.
    • Box is checked: It means you generally prefer to generate (calculate) the indicator's overall value based on the values entered for each category. 
    • Box is  not checked: It means you generally prefer to manually enter the indicator's overall value. 
  • Select a calculation method: either "Sum" or "Average".
    • If you select Average, the indicator's overall value will be the Average of disaggregated values (Example: % of children attending school. M=70%, F=40%. Overall=55%)
    • If you select Sum, the indicator's overall value will be the Sum of disaggregated values (Example: Number of children attending school. M=1800, F=400. Overall=2200)

How to configure disaggregations for an indicator with multiple disaggregations?

Follow steps 1 to 3 as explained above.

During Step 2, select multiple disaggregation methods.

As soon as you select at least 2 disaggregations, another parameter will appear. "Combined categories" checkbox.

  • If the box is checked: it means that you will enter values for each combination of items from disaggregation A wth items from disaggregation B.
  • If the box is not checked: it means that you will enter values separately for items from disaggregation A, then for each items from disaggregation B.

Example No.1

Example No.2


How to enter disaggregated values for the baseline?

An indicator's baseline is actually stored in LogAlto as the indicator's first value

So entering disaggregated values for the baseline must be done through the data entry interface:

  • Access the logframe
  • Click "Data entry

  • Click the clock icon next to the indicator to open the indicator's history panel.

  • Click on the oldest value (which is the baseline value)

  • Now you can enter disaggregated baseline values:
    • Enter a value for each category (or combination of categories).
    • Either check the "Automatically calculated" checkbox or enter the total manually.
    • Click "Set empty values to 0" if an empty cell actually means "0" (There is a difference between an empty actual value or 0. This also influences the overall value - sum or average.). Of course, you can also simply put 0 manually when applicable, but this button saves time if you have many categories to fill.
    • Click "Done".

Note that a baseline cannot be set for indicators that only allow entering the progress for each period (indicators that do not allow entering cumulative values)
Read our article on editing indicators to learn more.

How to enter disaggregated values for the target(s)?

You can enter disaggregated targets using the indicator form (configuration panel) OR using the data entry grid:

Via the indicator form:

This can be done right after completing the 3 steps explained in the " How to configure disaggregation for an indicator with only 1 disaggregation?" section.

If you are not currently configuring the indicator, you need to first open the indicator form (indicator configuration panel).

Once in the indicator form:

  • Click "Add target".

  • A new target row will appear. (By default, the target date is the project's end date)
  • Click on the blank cell below "Target value".

  • Now you can enter disaggregated target values:
    • Enter a value for each category (or combination of categories).
    • Either check the "Automatically calculated" checkbox or enter the total manually.
    • Click "Set empty values to 0" if an empty cell actually means "0" (There is a difference between an empty actual value or 0. This also influences the overall value - sum or average.). Of course, you can also simply put 0 manually when applicable, but this button saves time if you have many categories to fill.
    • Click "Done".

Via the data entry grid:

If the indicator has already been configured, you can also enter disaggregated targets via the data entry grid:

Simply click on a "Target" cell in the grid. A panel will open, allowing you to enter a target for each category or combination.

(Of course, this is only feasible if the indicator is disaggregated)


How to enter disaggregated actual values?

To enter disaggregated actual values:

  • Access the logframe.
  • Click "Data entry".

  • In the data entry grid, click a "cumulative" or "progress" cell on your indicator's row. ("cumulative" means that you enter the overall number for the indicator and "progress" means that you enter how much the indicator increased since the last reporting period)
  • A panel will open and allow you to enter disaggregated values
    • Enter a value for each category (or combination of categories).
    • Either check the "Automatically calculated" checkbox or enter the total manually.
    • Click "Set empty values to 0" if an empty cell actually means "0" (There is a difference between an empty actual value or 0. This also influences the overall value - sum or average.). Of course, you can also simply put 0 manually when applicable, but this button saves time if you have many categories to fill.
    • Click "Done".


Details regarding disaggregated indicators in a global logframe

Disaggregation by project

Corporate indicators in the global logframe are automatically disaggregated by project.

Other disaggregations

Corporate indicators in the global logframe can have additional disaggregations. 

However, please note that if you add disaggregations to corporate indicators, the projects will not be able to remove the disaggregations.


FAQ: Why can't I see the "disaggregation" checkbox and list of disaggregations in the indicator form?

The "disaggregations" checkbox and list of disaggregations are not displayed when the indicator is a "corporate indicator" (identified by an earth icon) and already has disaggregations (configured via the global logframe).


FAQ: Why can't I remove disaggregation methods?

You may not be able to delete disaggregations:

  • If the indicator is a "corporate indicator" (identified by an earth icon) and disaggregations were configured via the global logframe.
  • If actual values have already been entered. If that is the case, you need to delete the actuals before you remove the disaggregation(s). To do so:
    • Click "Data entry" to access the data entry grid.
    • Click the clock icon next to the indicator.

    • Use the trash icon to delete the actuals.
    • Now you can go back to the indicator form to remove disaggregations.