Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 43 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
How to get the Average for multiple months data.
I have a workbook to calculate average for monthly allocation. It is working fine for single month calculation, but I am not get the average data for selected months are greater than one month.
My expectation to get the average based on number of months.
Attached the workbook for quick reference.
Description.
Data showing for Jan month.
Data showing for Feb month:
Data showing for Jan & Feb Month:
My expectation if I select Jan & Feb Month:
Calculation for Capacity Avg:
Answers
-
You may try the aggregate by option on the workbook properties.
Refer attachment for an example
0 -
@KhaderBelgoud-Oracle I have already used "Sum" so ,it can't be re-used .
0 -
Does this output look correct?
Thanks
Gayathri
0 -
@GayathriAnand-Oracle It is not working. Also there is no way to do in workbook. I have created a Dataflow to achieve my results.
1
