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

OTBI Report showing result in multiple rows

Received Response
117
Views
1
Comments
edited Dec 12, 2022 8:42AM in Taleo Learn 1 comment

Content

Hi All,

We are looking to create a report for Fusion Learn where the columns will contain the questions and a single row will have response for each of the questions answered by a Learner. But in the output we are getting responses in individual rows rather than all being in a row and in respective column. Please refer the image and suggest how we can fix this issue.

For the columns we have used Formulas as 

CASE WHEN "Learning Evaluations"."Question Text" = 'I am satisfied with the training facility (venues, rooms etc.).' THEN "Learning Evaluations"."Response List LongText" ELSE '' END

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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