What's new in Customer Journeys?

Connect and learn more! ×
How to filter the column values by another column? — Cloud Customer Connect
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 filter the column values by another column?

Received Response
edited Oct 20, 2023 1:00PM in Reporting and Analytics for HCM 4 comments


I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time

I want to filter employees which have these Response Answers: Staff and Supplier

I used the Filter formula under Edit Column Formula tool:

However, the syntax is invalid:

Here's the error message:

Formula syntax is invalid.

[nQSError: 10058] A general error has occurred. (HY000)

[nQSError: 43113] Message returned from OBIS. (HY000)

[nQSError: 22032] Function FILTER requires at least one measure column in its first argument. (HY000)

SQL Issued: SELECT FILTER("Worker"."Person ID" USING ("Checklist Questionnaire"."Response Answer" IN ('Staff', 'Supplier'))) FROM "Workforce Management - Checklist Real Time"

Howdy, Stranger!

Log In

To view full details, sign in.


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