I was having a review of the wonderful sales pacing dash and thinking about targets and forecast.
I'm wondering if/how people have gone about forecasting a final position based on prior performances and what they used in formulas.
eg:
I was keen to play with sames pacing based on an adjusted forecast target.
Can you tell I'm keen for v16 and predictive modeling?
Does anyone have a shareable dash for forecasting? I've been trying to follow the documentation but not getting results. Additionally, the "analyze this" options are greyed out for me, so I'm obviously missing something!
I was advised that we need a 'Date' Row in place, not a 'Year to Date' or other variant.
That piece is fine - it's when I go to "analyze this" - instead of having the three options, all I have is Forecast Settings. The other two are greyed out. Additionally, the forecast doesn't seem to be showing anything that I would expect, so something is off (I'm sure it's user error....)
You may need to open a help ticket if you aren't seeing the settings that should be there. But it could be you are on a version that is older than what is in documentation? When I open the widget editor, I hover over the values, click on the owl icon, click on forecast and I get this screen.
Hmm, not sure about what to do with that. Good luck!
Yes, I don't have the two lines under Forecast Period
Did you take the path I described? Click the pencil to edit the widget first? If you click "analyze it" on the outside of the widget(not in editor mode) you get this screen
I also see that yours allows you to use RSUM. Mine gives an error when I try that.
Hi Tracey,
You have 11 weeks in the widget and are trying to forecast the next 30 weeks. Forecasting (without an explaining variable) can only output up to 10% of the number of periods in the widget. So, with 11 weeks, you can forecast at most 1 week out. If you hit Apply on the widget as you have it, there should be a little, red, lightening bolt on the (i) information bubble. Mouse over it and you'll see errors similar to this:
Ah, ok. So I've managed to get that piece functioning. Still having a tough time getting my head around exactly what it's showing me (that's a me thing). Any reason why it won't allow me to use RSUM?
Can you provide more detail of what you have in place and does it render the RSUM without doing a forecast? Images encouraged :)
Eg. Do you have RSUM ( [Ticket Paid Amount] ) or RSUM ( [Total Ticket Paid Amount] ) or RSUM ( SUM ( [Ticket Paid Amount] ) )
RSUM ( [Ticket Paid Amount] )
RSUM ( [Total Ticket Paid Amount] )
RSUM ( SUM ( [Ticket Paid Amount] ) )