Jump to content

Join on List of Counters widget


Alisha
 Share

Recommended Posts

Hello,

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,
Alisha

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,
Alisha

  • 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
 Share

×
×
  • Create New...