Max, Min, Median not working as expected ??

User9127066-Oracle

Summary

Max, Min, Median not working as expected ??

Content

Hello, I'm quite new to Oracle DVD

I've just tried the Max, Min and Median calculation but they seem not to work

they all gave a simple sum

my version is Version 12.2.2.2.0-20170208162627

any idea ??

User9127066-Oracle

That's right but it's not what I'm asking.

FTisiot

Those calculations are happening post aggregations, so the formula applied is Max(Sum(Fare)). You have two options:

1) Declare "Fare" as attribute and not dimension and then calculate the formula as you are now (however i'm not sure how the distinct values will impact calculations)

2) Add other Fare columns to your data source and set different aggregations for each of the column in the "Inspect" window

FTisiot

Hi,

The default aggregation method in DVD is sum, however you can change it in Datasources->your data source name -> inspect.

In there for all the measures you can define one aggregation method.

User9127066-Oracle

Hello,

Thanks a lot for your answer. It is now making much more sense !