We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.
Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!
Filter to get the earliest date in the OTBI Analysis.
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!
Answers
-
Hello Ivony,
Since this is related to the Sales Analytics, could you please post it at the below forum location? That way, the right people can respond to you.
https://community.oracle.com/customerconnect/categories/cx-reporting-analytics-sales
This forum is for Fusion CX Analytics (Fusion Analytics Warehouse product). https://www.oracle.com/in/business-analytics/fusion-cx-analytics/
Thanks,
Hitesh
1 -
Hello Hitesh,
Thank you for the suggestion. Have a good day!
0
