How to calculate the distinct sum of a spend by a category?

JobDeLuna

Hi,

How to calculate the distinct sum of a spend by a category?

So basically, I want to have the distinct base spend 2 by CONCAT3

I am aiming to have the Base Spend 2 Summary result I boxed in red below.

JoseP-Oracle

@JobDeLuna - For the Base Spend 2 SUMMARY, add again the Base Spend 2 column in the visualization. Then go to the Properties view of the visualization -> Values -> select the added column and change the Aggregation Method property to Average Distinct . This will result in the desired outcome.

See example below (column SUMMARY):

JobDeLuna

Thanks @JoseP-Oracle ! How about the grand total? I need to create a tile visualization of the sum of the 'Base Spend 2 SUMMARY'. On your example, I need to total 23, 34 and 46 having a total of 103.

JoseP-Oracle

The Grand Totals follow the aggregation rule of the column values (Average Distinct) hence the total will give the average and not the sum. There is not possible to override the aggregation type just for the Totals/Grand Totals.

You can enter a request at the Oracle Analytics Cloud and Server Idea Lab for having an enhancement to have Sum Distinct in the options for Aggregation Method in the canvas visualization, and this voted by other users and reviewed by our product team.