Oracle Analytics Cloud and Server

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

grand total on time series metrics

Received Response
11
Views
12
Comments
2»

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    There are 2 aggregations.

    When you create any measure in the rpd you specify its aggregation.

    Independent of this there is also the aggregation of what answers should do as an aggregation when you add a total specifically to a report field, or to an area in a presentation or similar.

    It does not always make sense for the two aggregations to be the same, and sometimes you will want to / need to override the defaulted aggregation on an answers based aggregation.

    In your case summing month to date will produce a spurious result, as the last month is the sum of all proceeding months.

    On that basis I might suggest that the best suggestion for that column is not to have a total.

    Out of interest what number does 'Server Complex Aggregate' produce?

  • 3577602
    3577602 Rank 2 - Community Beginner

    if i change it to serve complex aggregate,it throws an error

    i can only do 'sum'