Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Can you filter the MAX of a data set that uses RCOUNT and FLOOR functions

Accepted answer
41
Views
3
Comments
Marcelo G. Proaño
Marcelo G. Proaño Rank 5 - Community Champion
in Oracle Analytics Cloud and Server

Hello Oracle Analytics Community,

Was hoping someone can help me with this question. Is there a way to only show the Max number of a data set created using RCOUNT and FLOOR? In the screen shot below there are two columns, the "RCOUNT Copy" numerates or groups by Emp ID so for Jazmine there are 4 records and for Rachel there are 9. Then you have the "FLOOR Copy" which groups the "Form Type" so for every 30-60-90 it's 1 group. Jazmine has 1 full group and started on the 2 while Rachel has 3. How can I keep the MAX of the FLOOR count so that only those highlighted will show?

image.png
Tagged:

Best Answer

  • Chere-Oracle
    Chere-Oracle Rank 5 - Community Champion
    edited Aug 19, 2025 3:43PM Answer ✓

    Many of the regular aggregation functions (as opposed to the running aggregation functions) can use the BY keyword with a list of columns. Here are examples:

    COUNT( DISTINCT "Form Type" BY "Emp ID" )

    max( COUNT( DISTINCT "Form Type" BY "Emp ID" ) by "Emp ID" )

    These examples only have one column after the BY keyword, but there can be multiple.

Answers