Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Aggregate function using 'BY'

Received Response
11
Views
1
Comments
Helan Kumar
Helan Kumar Rank 4 - Community Specialist
edited Aug 13, 2024 6:09PM in Oracle Analytics Forum

I'm able to do 'aggregation group by' from answers using below syntax,

Max("Date of manufacture" BY "Lot Number") -- Works perfect from answers. i wanted to implement same in RPD to allow user to make use of this column for ad-hoc reporting.

But the word "BY" is not a key word and admin tool is not recognising the above syntax.

Please suggest an alternate solution for this.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    In the RPD you can set the aggregation to MAX on the logical measure and then by setting the correct content level force the "by" or let it free based on the analysis the users build.