Forecasting

[Debbie]

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

[Debbie]

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!

1. Add line graph
2. Add dimensions to x and y axis
3. Swicth on max/min/average & forecast
4. Switch x-axis to CATEGORICAL(which makes CONCATENATE LABELS visible)
5. Switch CONCATENATE LABELS off
6. 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

[Greg_Deckler]

That's the functionality as I understand it. You have to have a date axis and it has to be continuous.

[Debbie]

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.

Debbie

[v-shex-msft]

Hi @Debbie,

>>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

[Debbie · Accepted solution]

Thanks, @v-shex-msft  I've got it working. But as I said, I had to do everything in a very specific order! It's flaky, but I'm sure it will settle down in future releases ...

Debbie