Forecasting

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.

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

That's what I get if I use RSUM instead of SUM

Perfect! Thank you. Yes, so given a numeric value like SUM ( [Ticket Paid Amount] ) (which might also look like [Total Ticket Paid Amount] ), the Running Sum function, RSUM(), should surround that value like RSUM( SUM ( [Ticket Paid Amount] ) ).

Yahoo! Thank you - that fixed it!

Yahoo! Thank you - that fixed it!