Filter to get the earliest date in the OTBI Analysis.

Summary:

Content (please ensure you mask any confidential information):

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

--it should be like this

"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!

Version (include the version you are using, if applicable): Version 23C (11.13.23.07.0)