Hi everyone,
I had a specific case related problem.
As you can see in the attached picture, I have created a report to show the no. of tickets related to my team. It's a team of 5 people. After I applied all the filters in report to get thew data I want, I need to plot a similar chart where I need team members names in columns & their assigned tickets in rows as per the priority & state.
But the problem I'm facing is some of the tickets are opened by me teammates that are assigned to themselves, some are opened by them that are unassigned & some are opened by others assigned to my teammates. This is creating multiple columns & sub columns in the table.
What I need in table is 5 columns of all team mates names showing all the tickets that are related to them (i.e. opened by & assigned to) in order of severity & state and not see any other names in the table.
Can anyone please suggest me appropriate fields & steps to use in table column filter to achieve the result ?
Hope someone can help with this.
