Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

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

Create sum distinct aggregation

Needs Votes
28
Views
1
Comments
User_OVUF9
User_OVUF9 Rank 1 - Community Starter
in Oracle Analytics Cloud and Server Idea Lab

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
Up
7 votes

Needs Votes · Last Updated

Comments

  • GabriellePrichard-Oracle
    GabriellePrichard-Oracle Mod

    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?