cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Debbie Regular Visitor
Regular Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Debbie Regular Visitor
Regular Visitor

Re: Forecasting

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

5 REPLIES 5
Super User
Super User

Re: Forecasting

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


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Debbie Regular Visitor
Regular Visitor

Re: Forecasting

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

 

Debbie Regular Visitor
Regular Visitor

Re: Forecasting

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

Community Support Team
Community Support Team

Re: Forecasting

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.

7.PNG


2. Turn on the drill down mode, double click on one point to drill down.

8.PNG

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Debbie Regular Visitor
Regular Visitor

Re: Forecasting

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