Jump to content

Reports, double groupings


HHH
 Share

Recommended Posts

I'm trying in vain to create a report in service manager that groups the data by both team and service, is this a bug or by design.

If by design it seems like a strange design decision since the data is there.

Link to comment
Share on other sites

Hi @HHH

Thanks for your post.

Are you referring to this Group By option?  Are you looking to be able to select two or more items from this list?

image.png

Only being able to select one Grouped By item is not a bug.  It is designed like this. 

I would be interested to understand exactly what output your are trying achieve would look like and how the report will be used.  I wasn't sure if you were looking for breaking the report into sub groups or if you are trying to specify two sets of criteria for a single group.  

Link to comment
Share on other sites

14 hours ago, James Ainsworth said:

I would be interested to understand exactly what output your are trying achieve would look like and how the report will be used.  I wasn't sure if you were looking for breaking the report into sub groups or if you are trying to specify two sets of criteria for a single group.  

Basically what I'm out for is "show the number of tickets reassigned between teams by team and by service"

Link to comment
Share on other sites

I was looking for this the other day... would really be great, especially if it comes out as grouped in a PDF report.

Link to comment
Share on other sites

I solved it by creating an SQL query in database direct and exporting results, but a nice PDF report would be preferred

Link to comment
Share on other sites

@samwoo
Here is my workaround, adjust timestamps as needed.

SELECT left(h_assignment_timestamp,7) as 'Month',
h_previous_team_id as 'From Team',
h_team_id as 'To Team',
h_itsm_requests.h_fk_servicename as 'Service',
count(distinct h_request_id) as 'Requests'
FROM h_itsm_request_team_assignment JOIN h_itsm_requests ON h_itsm_request_team_assignment.h_request_id = h_itsm_requests.h_pk_reference
WHERE h_previous_team_id <> h_team_id AND h_assignment_timestamp between '2022-01-01 00:00:00' AND '2022-10-31 23:59:59'
group by h_previous_team_id, h_team_id, h_fk_servicename, left(h_assignment_timestamp,7)
order by left(h_assignment_timestamp,7), h_team_id, h_previous_team_id

  • Thanks 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...