Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 53 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 293 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.5K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 116 Oracle Analytics and AI Trainings
- 21 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
grand total on time series metrics
Answers
-
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?
0 -
if i change it to serve complex aggregate,it throws an error
i can only do 'sum'
0