Oracle Analytics and AI

User_OVUF9

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.

GabriellePrichard-Oracle

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?