Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

Welcome to the Oracle Analytics Community

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

Comments

Wow, Including/Excluding cust_id, do the magic: Without this, I've got only ones and zeros: I suppose it changes the grouping of the aggregation. Thanks, asim cholas

in OBIEE to calculate the number of customers with 1 to 10 orders Comment by KonstantinB Jul 31, 2017 5:28AM
In my answer, I get one number for each country. seems like not grouped by cust_id or what ?

in OBIEE to calculate the number of customers with 1 to 10 orders Comment by KonstantinB Jul 31, 2017 3:56AM
Here it is:

in OBIEE to calculate the number of customers with 1 to 10 orders Comment by KonstantinB Jul 31, 2017 2:58AM