How to count number of incomplete/complete Journeys in OTBI?
For OTBI analyses - our organization needs to be able to report on the following in the Workforce Management - Checklist Real Time subject area:
1) Total number of Journeys in the system distributed by person number (we don't want count of tasks)
2) Count of incomplete journeys in system
3) Count of complete journeys in system
We have this equation built out for our incomplete count:
FILTER(COUNT("Allocated Checklist"."Person Number") USING ("Allocated Checklist"."Status Code" <> 'COM'))
We are taking the count of allocated checklists by person number and filtering for checklists that are NOT complete.
Our count comes out to read "1". Does anyone have any advice to fix this?