Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 230 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 86 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Forecast (Workbook and Data flow)
I have sales data with product, date, and quantity sold. I would like to generate a time series forecast for each product and export the results into a CSV file. When I create a forecast in a workbook, I can only generate a line chart, but I’m not able to convert the forecast into a table or export it. When I try using a data flow, I can get the forecast in table form, but I haven’t been able to generate the forecast per product. Is there a way to produce and export forecasts per product into CSV in Oracle Analytics Cloud?
Best Answers
-
Hi Julianne, I think it would be a brilliant idea to allow users to export or see in a table format the forecast created on a graph using ETS, Arima or Prophet. I would recommend you to add this idea to our lab. I will vote for it.
Idea Lab:
1 -
Hi @Julianne ,
Did you try using the
forecastfunction as in expression?I just added a table visualization in a workbook, added product, date, revenue and quantity and then added 2 calculations with a forecast for revenue and quantity. As you can see the forecast is at the product level, each product has its own forecast.
3 -
Thank you @Gianni Ceresa I learnt something! I tried with the ETS modelType and it's working perfectly. I was also able to create a calculation to put the forecast and the sales on the same column using CASE IF.
1
Answers
-
Added! Thanks @Benjamin Arnulf-Oracle. Would love to see it happen.
1 -
Hi @Gianni Ceresa ,
Thank you! It works with formula2 -
Glad it works.
Everything that can be done "graphically" has a "code" equivalent, it just isn't as direct as a click on a chart (could be interesting if there was a "generate code" option for those things).
2