Forum Discussion
Forecasting
So I have the July 2017 update and I'm trying to do some forecasting on a simple line graph. I have dates on my x-axis (1st of every month in date format) and a count value. So far, so good. I can see the Forecasting option on the Analytics tab and the graph looks very pretty, even if I haven't a clue what it actually tells me ....
Then I switch my x-axis to CATEGORICAL (so it shows me actual dates and not just years) and BOOM - the forecasting vanishes. Completely. WHY? Why on earth should it matter how I choose to display my dates?
Debbie
5 Replies
That's the functionality as I understand it. You have to have a date axis and it has to be continuous.
Hi Anonymous,
>>My date axis is continuous - it's just the display I'm trying to set. I want my months to be visible on the x-axis as well as the years.
So you want to show month year at the x-axis, right ?
If this is a case, you can refer to below steps:
1. Switch date column to hierarchy mode and only keep year and month.
2. Turn on the drill down mode, double click on one point to drill down.Regards,
Xiaoxin Sheng
So ... to get it to work, I had to do things in a *very* specific order - otherwise the Forecasting option doesn't even show up!
- Add line graph
- Add dimensions to x and y axis
- Swicth on max/min/average & forecast
- Switch x-axis to CATEGORICAL(which makes CONCATENATE LABELS visible)
- Switch CONCATENATE LABELS off
- Switch x-axis back to CONTINUOUS
If I mess with my x-axis *before* I set the forecast, the forecast option doesn't appear at all - even if I set it all back to default.
Debbie
