Join on List of Counters widget

[Alisha]

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

[Bob Dickinson]

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

[Alisha]

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