Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Average in a pivot table not displaying values as intended
Have a basic pivot above that counts attendances for particular days of the year. (ignore the column Attendances AVG ..)
i would like to have another total/summary/measure that calculates the running average for a day, week by week
so in example above for Monday:
Week 27 45 Attendances Avg: 45
Week 28 31 Attendances Avg : 38 (45 + 31 /2)
Week 29 43 Attendances Avg: 39.6 (45+31+ 43 /3)
Week 30 46 Attendances Avg: 41.25 (45+31+43+ 46 /4)
etc - is this possible?
If not how can i get an average for Monday for the whole period?
i have duplicated the measure Attendances above and set the aggregation rule to AVG but get result above in Columns Attendances AVG.
thanks
Answers
-
Is this what you are looking for =>
OBIEE 11g/12c and ODI12c: Mavg (Moving Average)
Other alternatives are using the BY clause to manually create aggregations; - https://gerardnico.com/dat/obiee/obis/logical_sql/group_by
You could also achieve this using filter function in a similar way.
Finally; and arguably best; you could build this in the rpd to have average by month, year etc, by building a physical average measure on top of your base measure and then by reproducing it and pinning it to the appropriate level of the time hierarchy; so drag to month level for average by month etc.
0