Oracle Communities

Oracle Analytics and AI

Child Item

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

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?

Find more posts tagged with

Analytics

Analysis and Data Visualization

Analysis

Data Visualization

Oracle Analytics Cloud

Accepted answers

Chere-Oracle

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.

All comments

Chere-Oracle

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.

Marcelo G. Proaño

Thank you @Chere-Oracle. Let me see if I can apply that.

Marcelo G. Proaño

This is how I was able to get the results I was looking for. Was more simple than I thought. I think that is one of my problems. I complicate things more than they are.