Multiple filters on analysis criteria in separate columns — Oracle Analytics

Oracle Transactional Business Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Multiple filters on analysis criteria in separate columns

31
Views
2
Comments

Description

It would be great if, in OTBI, we had the functionality to have multiple filters on analysis criteria in separate columns. 

This would be especially beneficial for requisitions where we have pre-screening questions where we would like to export these questions to a spreadsheet in a user-friendly way to fast track our shortlisting. We could have 2 columns with different filters for the criteria of 'Question Text' and 'Question Response Long Description' so we can see the answers to two questions side by side.

I have attached an example of a spreadsheet that I manually manipulated in Excel. 

 

 

Use Case and Business Need

This would save us having to manually manipulate reports to make it an easier process to shortlist candidates. 

Original Idea Number: c7e2da9b43

Multiple filters in columns.PNG

2
2 votes

Submitted · Last Updated

Comments

  • Ashleigh Mansbridge
    Ashleigh Mansbridge Rank 1 - Community Starter

    Yes, this would be very useful!

  • Stefan P
    Stefan P Rank 1 - Community Starter

    I am surprised I am not seeing this question pop up more in the community.

    Essentially, when you have question response and question answers, you filter all results by one pre-screening question answer. Then you do not see any of the other values captured at the time. We have complex situations where we need to capture information that is not in a delivered field or flex field and we can only get the information via pre screening questions. Allowing us to set up the pre-screening questions as columns would be helpful.

    I don't know if this is possible but there should be questions to have specific conditions that create rows for only one pre-screening question with it's answer. However, I don't think this functionality exists unless there is another way of creating the conditions.