Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
How to show only the MAX response attempt for a questionniare response in OTBI analysis — 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 show only the MAX response attempt for a questionniare response in OTBI analysis

Accepted answer
22
Views
3
Comments

Summary:

We have an OTBI Analysis that returns information based on a checklist questionnaire. Employee can be asked to review and revise this content. We then want to present the final input (last attempt) in a summarized report. I cannot find a way to filter the analysis output on the maximum response attempt only

Content (required):

I have an analysis with a single subject area: Workforce Management – Checklist Real Time

Trying to use MAX("Checklist Questionnaire"."Response Attempt Number") but system seems to 'randomly select' what it returns as the Maximum value

It is important to our organization to keep this analysis in OTBI.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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