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

Reporting on count of incomplete/complete Journeys in OTBI?

Received Response
311
Views
2
Comments
edited Feb 23, 2023 9:54PM in Reporting and Analytics for HCM 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". It seems like our count is invalidating the use of our filter and causing it not to respond in the analysis. Does anyone have any advice to fix this?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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