I have two PQL statements i want to factor into a clickable link:
currently have this as the Component filter:
I have two PQL statements i want to factor into a clickable link:
I currently have this count:
count(case When "_CEL_ENG_LATEST_EVENT"."ACTIVITY_EN" = 'new change' Then 1 else null end)
This is tracking cases where the latest event type matches "new change".
currently have this as the Component filter:
filter(WORKDAYS_BETWEEN("_CEL_ENG_LATEST_EVENT"."EVENTTIME","_CEL_ENG_LATEST_EVENT"."LAST_UPDATED",
WEEKDAY_CALENDAR ( MONDAY 09:00 - 17:00 TUESDAY 09:00 - 17:00 WEDNESDAY 09:00 - 17:00 THURSDAY 09:00 - 17:00 FRIDAY 09:00 - 17:00))) > 3
This is displaying the cases that breach my SLA of 3 days
I want to be able to have a clickable link that can carry those filters through.