Forum Discussion
Forecasting tool - issue using 'ignore the last'
- Anonymous1 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 HeIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly
The forecast line dissapears entirely. I then get a error staying the data is too irregular.
- SamWiseOwl1 year agoSuper User
Would it possible to provide a sample of the data with the dates but with any private data removed.
- Kai_PBI1 year agoNew Member
Usually there are staff numbers inbetween this. I also had to strip alot of data out to fit in below. But you should be able to replicate my visual with the data below:
Month Signed off by employee(Yes/No) 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 14 October 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 27 November 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 09 December 2024 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes 06 January 2025 yes