Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Oracle Analytics Cloud and Server

Categories

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

Filter in analysis between 2 different fields

21

Views

2

Comments

User_8PPKU

User_8PPKU Rank 2 - Community Beginner

Mar 25, 2021 10:05AM edited Aug 13, 2024 5:15PM in Oracle Analytics Cloud and Server

Hallo,

in Oracle BI (ver 12c):

I have created a new analysis,

in the section "Filter" I want to add a filter that compares 2 different fields

(for example: "field1" < "field2" ).

How is it possible to do this filter ?

Regards.

0

Comments

Gianni Ceresa Mod

Mar 25, 2021 11:51AM

Hi,

With a SQL filter you can write the filter condition you want.

0
User_8PPKU Rank 2 - Community Beginner

Mar 25, 2021 2:17PM

Thank you

0