How to create a report where I can get the State & Assignment Group it is assigned to at one place
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-25-2023 10:49 AM
Hi,
There is a requirement ,
where in a report we can see the "State" and "Assignment Group" of all the Open tickets at one place.
I have tried Multiple dataset but it not very useful and understandable.
Thanks,
Vaishnavi

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-25-2023 01:59 PM
Hi Vaishnavi,
Not sure I understand your requirement.
Have you tried a Multi_Level Pivot table report where Column = State and Row = Assignment Group, aggregating on Count ?
JP
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-26-2023 03:35 AM
Hi,
I get it, we can create a Multi level pivot but there I can see in which month the tickets were created. Like a trend report.
I have created a report of "Column" type on Incident table where I can see the month where the tickets were open and the state they are in. I want to see the Assignment Group in the same graph along with the trend and State values.
I hope I was clear.
Thanks,
Vaishnavi
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-25-2023 02:10 PM
Hi @Vaishnavi35 ,
If you're referring to an incident, you can just utilize the incident table to create your report based on - this will give you both the state and the assignment group. Or has I misunderstood your question?
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Best regards
Anders
If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.
Best regards
Anders
Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-26-2023 03:34 AM
Hi,
I have created a report of "Column" type on Incident table where I can see the month where the tickets were open and the state they are in. I want to see the Assignment Group in the same graph along with the trend and State values.
I hope I was clear.
Thanks,
Vaishnavi