Oracle Fusion CX Analytics

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Fusion Data Intelligence› Oracle Fusion CX Analytics

Categories

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
50
Views
2
Comments
Ivony Ann Paula Salango
Ivony Ann Paula Salango Rank 3 - Community Apprentice
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