Forum Discussion

Kai_PBI's avatar
Kai_PBI
New Member
1 year ago
Solved

Forecasting tool - issue using 'ignore the last'

I've been struggiling with this issue for some time now and not sure what the issue is. I have got monthly data extracts, which provide submission data. One column provides 'start of the week' and...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Kai_PBI ,
    I agree with SamWiseOwl , and here's what I'd like to add.

    The first thing that needs to be applied to the x-axis is the date hierarchy

    Then on top of that you need to drill down to the month level

    Then turn on the predict button to make it happen

    As you reported, it is not possible to make predictions without regular intervals, just as if you drill down to the day level again, it will suggest that it is not possible to make predictions because the date of the previous data point, is not the same as the date interval of the next date point. The only way to do normal separation is by month, year or quarter.

    Best regards,
    Albert He


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly