Skip to main content

 

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.

Hi Daniel,

 

If you still need help, Can you give a little more detail to exactly what you are trying to accomplish here?

 

Regards,

 

Bob


replied on celopeers

Reply