OTBI – Calculate Percentage of Responses per Question in Learning Evaluation Surveys

Hi everyone,

I'm building an analysis in OTBI using the Workforce Learning – Learning Records Real Time subject area, and I’m looking to better understand how learners respond to post-learning evaluation surveys.

Specifically, I want to:

• Display each question only once
• Group the various free-text or list responses submitted by learners
• Count how many learners provided each response
• Calculate the percentage of responses relative to the total number of learners who received that same question

For example, for the question “Would you recommend this experience to others?”, I’d like to see how many responded “Yes”, “No”, or left it blank — along with their respective percentages.