Max, Min, Median not working as expected ??

Question

Summary

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 · Answer

Hello,

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

User9127066-Oracle · Answer

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

FTisiot · Answer

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