Oracle Fusion CX Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion AI Data Platform› Oracle Fusion CX Analytics

Categories

We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Filter to get the earliest date in the OTBI Analysis.

Received Response
71
Views
2
Comments
Ivony Ann Paula Salango
Ivony Ann Paula Salango Rank 5 - Community Champion
in Oracle Fusion CX Analytics

Hi, kindly asking for your help.

I am trying to get the earliest date per account/activity within my analysis.

It worked with a different account but once I am using 2 subject areas, it is not reflecting correctly.

I used the function MIN(Date by Account Number)


--using 2 subject areas

image.png


--it should be like this

image.png

"Activity Extension"."Extension Attribute Timestamp 003"=MIN("Activity Extension"."Extension Attribute Timestamp 003" by"Activity"."Activity Id") --this filter is not working when i use 2 subject areas.


Hoping for your response. Thank you!

Answers