---
sourceDocument: Yokohama Platform Analytics
sourceDocumentLink: https://www.servicenow.com/docs/r/yokohama/now-intelligence

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Platform Analytics

ft:clusterId :

    - par

bundleId :

    - par

workflow :

    - Platform


---

# Breakdown matrices in formula indicators

# Breakdown matrices in formula indicators {#ariaid-title1}

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 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](https://www.servicenow.com/docs/ZaIJQWV6_9ZI1JkGkx2LHA#contributing-indicator "An indicator that is used in the formula of a formula indicator. A contributing indicator can be an automated or a formula indicator.") 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

**Related concepts**   

* [Prevent a contributing indicator in a formula from following breakdowns](https://www.servicenow.com/docs/s8ljte6mrexHKh2RQ7_NMg "You can select contributing indicators in a formula to not be broken down. When a user applies a breakdown to the formula indicator, the breakdown does not apply to these indicators.")
* [Applying time series to result or to contributing indicators](https://www.servicenow.com/docs/A6kYN_wh~lEuloMoUTj4hw "For a formula indicator, a time series aggregation can apply either to each indicator in the formula individually or to the formula result.")
* [Indexing multiple indicators in a formula](https://www.servicenow.com/docs/VYmydZ5TL5kYu_EANq_obA "You can write a formula to measure what the gap is to the overall target of multiple, combined indicators. Such a formula indicator is called an 'index indicator'.")
* [Changes to score_start/end because of different user time zones](https://www.servicenow.com/docs/ma4MQztYPUSBzKgw0TBKSQ "For formula indicators, the values of the variables score_start and score_end are calculated based on the time zone of the user who is executing the formula. If users in different time zones execute the same formula, the values of score_start and score_end change.")  
**Related tasks**   

* [Create a formula indicator](https://www.servicenow.com/docs/F4~PyPNRMXTRaprFi6_~mA "Create a formula indicator to produce a new computed score from one or more other indicators. Besides indicator scores, the formula can include calculations such as the gap between an indicator score and the indicator target.")
* [Get analytics methods in formulas](https://www.servicenow.com/docs/dEqtnDLxw90DrtUEtV_uaw "To insert a calculated value from the Analytics Hub into a formula, use a method in the formula.")
* [Detect indicators with no scores in a formula](https://www.servicenow.com/docs/9cDjXPBkHxBbcGkk6ajR2g "As the formula creator, you can handle contributing indicators that have null scores. First set the formula indicator to calculate the formula even when it contains a null score.")