You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to count number of incomplete/complete Journeys in OTBI?

Closed
52
Views
2
Comments
edited Mar 2, 2023 2:43PM in Journeys 2 comments

Summary:

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

Content (required):

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?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!