Jump to content

Join on List of Counters widget


Recommended Posts


I'd like to use a List of Counters to count how many times a request has been assigned for the first time to a different team on a daily basis (all requests that are not first time fixes). I think I need to join h_itsm_requests with h_itsm_request_team_assignment, but can't see a way of using a join on a COUNT in List of Counters. Is this possible please? I'm still new to this, so any help would be much appreciated.

Many thanks,

Link to comment
Share on other sites

  • 2 weeks later...

Hi @Bob Dickinson,

I managed to get around this by doing a count on all the requests logged today by the Service Desk minus all requests resolved today by the Service Desk, which gave me a number and it seemed to add up. Not sure if this is correct or not! But yes, the counter should only be live for today, and then reset back to 0 at midnight.

There is something else that I would still like help with if that's okay please?

Thank you very much,

  • Like 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
  • Create New...