Build On-Time Numerator

[fayazlucky786]

In the standard Performance Analytics Indicator Source does not support comparing Actual End Date against Planned End Date directly. The condition builder only allows comparison against a fixed date value. But I need field value.

The exact issue is with the numerator filter. In the UI available to me, I do not see the Field toggle you referenced. The condition builder only allows calendar/date values.

I also tried the encoded query approach to locate a place to paste the query, but we were unable to find a field on the Indicator Source form that accepts an encoded query.

[Mark Manders]

What exactly are you trying to do? What is the business case? 
ServiceNow allows for a lot (and, I have to admit, also a lot that is lacking). You are describing a solution that doesn't work or you can't figure out. Knowing the problem you are trying to resolve can help in providing a solution that does work, maybe even a solution that is completely different from your initial one.

[fayazlucky786]

I am configuring a Performance Analytics Indicator Source on the Change Request [change_request] table.

Requirement:

Work End (work end) <= Planned End Date (end date)

Show more lines

I can create conditions like:

Assignment Group starts with MSCloud

State = Closed

Work End is not empty

However, when I add:

Work End at or before

the condition row only shows 3 fields:

Field | Operator | Value

and the Value field immediately opens a calendar/date picker.

I do not see the Value → Field → Dynamic → Choices dropdown that would allow comparing:

work_end <= end_date

directly.

I have already checked:

• Classic UI
• Admin / PA Admin roles
• Indicator Source form in the platform UI (not Analytics Hub)
• Change Request list filters

but the field comparison option is not displayed.