Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Max, Min, Median not working as expected ??

Received Response
111
Views
4
Comments
User9127066-Oracle
User9127066-Oracle Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

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 ??

Answers

  • User9127066-Oracle
    User9127066-Oracle Rank 3 - Community Apprentice

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

  • FTisiot
    FTisiot Rank 6 - Analytics Lead

    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
    FTisiot Rank 6 - Analytics Lead

    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
    User9127066-Oracle Rank 3 - Community Apprentice

    Hello,

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