Breakdown matrices in formula indicators

  • Release version: Yokohama
  • Updated January 30, 2025
  • 1 minute to read

    • Formula indicators inherit breakdown matrices from indicators in the formula.

    If all the indicators in the formula collect breakdown matrices, second-level breakdowns are available for the formula indicator. If none of the indicators in the formula collects breakdown matrices, second-level breakdowns are not available for the formula indicator. If only some of the indicators in the formula collect breakdown matrices, only those indicators can be broken down at a second level.

    Formula with two contributing indicators where breakdown matrices are calculated for one or both indicators

    Consider the case when breakdown matrices are collected for the indicators 'Summed age of open incidents' and 'Number of open incidents.' You now create an indicator with the following formula:

    [[Summed age of open incidents]]/[[Number of open incidents]]/24
    On a particular day, the score for this formula indicator is 170, calculated as follows:
    Summed age of open incidents with Category = Software and Priority = 2: 8,152 hours
Number of open incidents with Category = Software and Priority = 2: 2
Formula: 8152/2/24=170
    What if the breakdown matrix is calculated only for 'Summed age of open incidents'? In this case, the 'Number of open incidents' is broken down only by Category and not by Priority. The score for the same formula indicator on the same day is 11, calculated as follows:
    Summed age of open incidents with Category = Software and Priority = 2: 8,152 hours
Number of open incidents with Category = Software: 31
Formula: 8152/31/24=11