nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Filtering data by aggregation like group by ...having count(*) >1

fabryddorf-Oracle

Hi All,

On the below report I am trying to filter by guests who stayed in more than one hotel. Theoritically I should display only guest where the sum by guest >1

Any idea? I obtained the some simply in Pivot table on Guest name

Find more posts tagged with

Accepted answers

All comments

ArijitC

You can use selection step by clicking in the analysis.

Then do something like this ..

Thanks

Arijit

fabryddorf-Oracle

Good idea. I never explored this before ! Thanks.

The measure option however doesn't offer to group by the SUM of stays and this is what I am looking for. They are only listed simple measures.

Regards

ArijitC

Did you try selection on Guest Name column ?

Gianni Ceresa

Hi,

Just use the SUM(... by Guest) > 1 in your filter of the analysis.

Just make sure the calculation is right by adding the formula in a column first and validate it, then you just filter on that column and then you can delete the column itself as the filter will copy the formula.

Martin van Donselaar

You can try using something like COUNT (DISTINCT "Resort" BY "Guest Name") > 1 OR SUM("Stays" by "Guest Name") > 1 in your filter section

fabryddorf-Oracle

that was it

COUNT(DISTINCT "Property"."Resort" by "Guests"."Guest Name" )

Filtered >1

Thanks again

fabryddorf-Oracle

Thanks , that helped!

The solution was

COUNT(DISTINCT "Property"."Resort" by "Guests"."Guest Name" )

and filter >1

Upcoming Event

AI Data Platform - Creating High Code Agents and Using Developer Tools in AI Data Platform
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…

Top Leaders

Mallikarjuna Kuppauru-Oracle 80