We are creating some indicators and we need to access more than 2 levels - breakdown.
With Breakdown Relation, it is possible to access more than 2 levels, but the filter is lost and we cannot see the "complete" detail.
With Breakdown Matrix it is only possible to access up to the 2nd level.
In the community I saw that there is the option to do Breakdown Rollup. But the only example you have is a Rollup with the same field (Location).
In our case, it would be the Rollup in different fields.
Example:
Indicator: Start Value (Table sn_gf_goal_target)
Breakdown: I want to access the 'Grupo' and with the group selected, I want to see the 'OKR' and from these OKRs, I want to see the 'Target'.
Has anyone done this or something similar?
Fields infos:
Target: sys_id the table sn_gf_goal_target
OKR: field 'goal' of type reference (sn_gf_goal) that is in table sn_gf_goal_target
Grupo: field 'Assigned entity' that is located in table sn_gf_goal (goal field)
Links I saw about Breakdown Rollup:
https://www.servicenow.com/community/platform-analytics-articles/breakdown-matrix-or-breakdown-relat....
https://www.servicenow.com/community/performance-analytics-blog/leveraging-hierarchies-in-performanc...
