Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Adding Total Headcount and Response Percentage Columns in OTBI Report
Hi Community,
I am working on an OTBI report that aggregate responses from employees related to their self-identification.
Current Setup:
- The report currently includes columns based on Question from Questionnaire
- Logical SQL: This report is built with the help of logical SQL.
- Response Count (filtered to show only the count of responses) provided for entire Questionnaire
Issue:
- 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:
0