Breakdowns by assigned to

[moses5]

I am trying to create a breakdown to see opened incidents broken down by assigned to. I have not been able to do this. Any advice will be appreciated.

THe main issue is in creating the breakdown source with no success. Clicking on the "Configure Label" on the "Assigned to" field suggests that Fact table = Task and Element = assigned_to.

I tried to use this combination to create the Breakdown source but is not working.

THank you.

[pieter_goris]

Moses,

the purpose of the breakdown source is to get a list of breakdown elements. In your case you want users that can be Assigned to persons. So do not the 'user' table as that will give you more breakdown elements than you are interested in but use the 'Group member' table:

       

When setting the 'Field' select the User folder.

Next, in your breakdown mapping, relate the breakdown source to the incident table by selecting the column/field that holds references to the Assigned to user:

        (the form might look a bit different in your instance, it depends on the release you are running)

       

Hope this helps.

Cheers, Pieter

[moses5]

Thank you Pieter. I did as you suggested and it works!

Appreciate your your time.

[mitzaka]

I managed to get the breakdown, but when I want to see the data by the breakdown, it does not show by default the tasks on different group members. It shows them only after you select an element. How did you manage to work over that one?

[Roger11]

Tried this way, but the breakdown gets disabled due to too many records (480k+)

Also, you cannot then select change_request in related list to trim the number of users down even further.