Jump to content
Sign in to follow this  
Alisha

Join on List of Counters widget

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

Share this post


Link to post
Share on other sites

Hi @Alisha

Just to confirm - should this counter be "live for today" i.e. if you look at it right now, it would potentially show "10 tickets that have been assigned more than once today"

And at midnight, this should reset back to 0?

Kind Regards

Bob

  • Thanks 1

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
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
Sign in to follow this  

×
×
  • Create New...