Creating an automated drill-down breakdown by assignment group & group member

[mitzaka]

Hey SNC,

A pretty common scenario, but still something I challenged with, so I though I would share it.

The case was that I needed a way to have a breakdown by assignment group (for let's say sc_req_item table for the example) and then when I go to a group, to be able to have a second breakdown by the group members.

What I came with as a solution is the following:

1. created a breakdown source for the assignment groups called 'groups.active'

2. created a second breakdown source for the group members called 'group.members'

3. created a breakdown for the assignment groups called 'Assignment Group' with the corresponding breakdown mappings (for the tables which I want to map to), and most importantly - a BREAKDOWN RELATION, which is key to link the two breakdowns

4. The breakdown relationship called 'Group to Group Members' is configured like follows

Then once you add that breakdown to an indicator and present it on a widget / scorecard, you can actually drill-down by assignment group and within the selected assignment group, you will have a second breakdown by the members of that assignment group, which is quite nice.

Don't know if there is a more effective way to accomplish this. Please share if you have one for the sake of collaboration:)

Cheers!

[Naresh27]

Hi Dimitar,

I understood that you need to see results of a initial Breakdown with further breakdown possibilities.

what I usually do is

I create two breakdowns just as you shown,then attach them to my indicator.

instead of having a breakdown relation. you can turn Collect Breakdown Matrix 'ON' in your indicator.

This gives all possibilities of breakdown by breakdown listed from your indicator.

Thanks

Please mark correct or helpful depend upon the level of response

[Arnoud Kooi]

Nice tutorial!

The diffrence between the approaches is:

Breakdown relation

You hop from the first breakdown to the Group Members breakdown at first level.

If a Group Member is a assigned to tickets in multiple groups, you will see them all.

You keep the second drilldown available, to drilldown in.

Breakdown matrix

You drilldown to the second breakdown. You only see the Group Members tickets of the selected group. using the second breakdown.