Creating report with Groups as a condition
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-05-2023 02:17 AM
Hello, I am trying to create a "articles by department" report that separates data by Groups instead.
The issue we have now in our team is that we have all merged into 1 department but are identified in different Groups in ServiceNow.
Is there a way to add a condition to a report based on "Groups"?
Here is an old report I created (attached) that previously worked when users were separated by "department", though now I need to do this based on Groups. Any help here would be appreciated!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-05-2023 07:17 AM
Hi @salgrov
I am not sure , but you want to get report of KB created by a specific group ? If yes, do you any field on KB assignment group ?
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-05-2023 07:25 AM - edited ‎10-06-2023 02:06 AM
Could you do it the other way and do a report on the Groups table or group members then dotwalk to the articles? Or do a report on the knowledge table but add a drilldown with author group? If this is not possible then you're going to have to ask someone to script it (i can't do this myself, i've attached a picture to show something similar) https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0832058.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-05-2023 11:16 AM
Hi @salgrov
There are any number of ways to accomplish this based on your configuration, most of them involve dot-walking to the required field. Are you OOB or do you have customizations? Can you dot-walk to the Author's group instead of the department? Perhaps you might have an owning group assigned to the article based on a related CI and that could be used to group by in the report.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-10-2024 11:02 AM
Apologies for the late response.
I realise what I need to do is to create a report that shows articles in current workflow state Published, filtered down to specific knowledge bases (all easy so far), but group the graph by Assignment Groups, this is where I seem to have trouble figuring out how to group. Perhaps I should use a different graph than the Horizontal bar?
The result should display total articles published and grouped by Assignment Group, since there is no other way to separate teams (such as department, because technically we are all 1 department) based on their user data.
