PA Breakdown - dependent value

[JK9903]

Hello everyone, 

I have a requirement where I need to show report based on 2 breakdowns. 

1. Group (assignment group)

2. Group members (assigned to)

In analytics hub, if I select a group, in the assigned to breakdown it should show only the members from the selected group. Is there any way to have this dependent value configuration in breakdown?

Steps taken

Created a record in breakdown relations

*in the below image it is not showing the actual group members.

[JK9903]

I'll explain what I'm trying to achieve

Requirement

In the Analytics Hub, the indicator should behave like this:

• Under the Assignment group breakdown → show all assignment groups normally.

• Under the Assigned to breakdown → show only the users in the selected assignment group whose incident reassignment count = 0.

Current setup

Indicator Source
1 Indicator Source for the Incident table.

Indicators
Total Incidents – counts all incidents.

Incidents with Reassignment Count = 0 – same indicator source, but with a condition on reassignment_count = 0.

Formula Indicator: ( [[Number of resolved incidents by first assigned group]] / [[Number of resolved incidents]] ) * 100