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

Adding Total Headcount and Response Percentage Columns in OTBI Report

in Reporting and Analytics for HCM 1 comment

Hi Community,

I am working on an OTBI report that aggregate responses from employees related to their self-identification.

Current Setup:

  1. The report currently includes columns based on Question from Questionnaire
  2. Logical SQL: This report is built with the help of logical SQL.
  3. Response Count (filtered to show only the count of responses) provided for entire Questionnaire

Issue:

  1. The challenge I am facing is that due to the filter applied on the report to show only the count of responses. the "Total Headcount of Business Unit" column is also reflecting the filtered count instead of the actual total headcount of the business unit.
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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