Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 9 Oracle Analytics Lounge
- 187 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.4K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 63 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Create sum distinct aggregation

User_OVUF9
Rank 1 - Community Starter
Hello team,
From Colombia team, I noticed with many work partners that the sum distinct aggregation is needed. Same as a SQL query, because there are some cases where you have duplicated values in a DB in which you do not have write permissions. This function would be very useful to help users with different aggregation methods.
Best regards.
Tagged:
7
Comments
-
Hello @User_OVUF9 I believe we do allow select sum distinct aggregation when creating datasets via manual sql. Here's an example of a syntax that should work:
SELECT region, SUM(DISTINCT amount) AS total_unique_amount
FROM SH.Sales
GROUP BY region;Is there somewhere else that you're trying to use this aggregation method?
1