I am trying to create a scoreboard query to show tickets that have an SLA that will expire in the next 48 hours.
There is an existing query,
active = 1 AND attached_slas.time_to_violation < EndAtTime(\'TODO_TODAY\')
for tickets that will expire today that I would like to customize for my 48 hour timeframe.
I am having trouble figuring out the format to define the time. I have tried things like
EndAtTime(\'NEXT_48_HOURS\') and EndAtTime(\'NEXT_48hours\'), based on other queries I've seen but have not had success.
Thanks for any assistance!