davidrb84 Posted November 14, 2022 Share Posted November 14, 2022 Hi All, I'm looking to calculate a "bounce rate" for each ticket, essentially how many times was it assigned to another team. I currently pull various tables out of hornbill via the API to interrogate them via Power BI. Has anyone done something similar? I can't see an existing column that generates this within Hornbill, but not sure of the best way to approach the problem. I could look for key words in the buz_activities table but that feels a little open to errors. Link to comment Share on other sites More sharing options...
Steve Giller Posted November 14, 2022 Share Posted November 14, 2022 The h_itsm_request_team_assignment table will probably assist here. 1 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now