Forum Discussion
enabling forecasting
Anonymous Greg_Deckler
Whoops!
Anonymous Greg_Deckler When I go to change the Month to a Date Type all of the fields turn into an Error. When using the Order Date I made sure that this is the Date Type and I still do not see forecasting on the analytics pane.
- BhaveshPatel9 years agoSuper User
There are some considerations to keep in mind before using Forecasting feature. Please see the screenshot.Forecasting limitations
More on this can be checked out at HERE.
- BhaveshPatel9 years agoSuper User
You can also use R for forecasting. Check out this BLOG
- sshore9 years agoHelper IBhaveshPatel I have changed the Date to a Date/Time Type and the Value to the Whole Number Type. I am still not able to see the forecasting function. My query has more than 1000 rows. Do you think that this has to many values to use the forecasting option?
- sshore9 years agoHelper I
BhaveshPatel I have changed the Date to a Date/Time Type and the Value to the Whole Number Type. I am still not able to see the forecasting function. My query has more than 1000 rows. Do you think that this has to many values to use the forecasting option?
- sshore9 years agoHelper I
@BhaveshPatel I found out what the problem was.
I had our Order date in Months. When you have Months it does not allow for the forecasting option. When I choose year it does pop up. Unfortunetly I work for a Consumer Electronics Start Up so we do not have mass historical data. Do you know if the forecasting function will be enabled for Data grouped in Months?
Thank you for your help!
- v-qiuyu-msft9 years agoCommunity Support
Hi sshore,
Based on my test, we can add a forecast line when the X-axis displays Month values. You can place MonthNo which is number type in X-Axis instead of month names. See:
Best Regards,
Qiuyun Yu