How can I get my forecast to work?

[HamidBee]

I am trying to create a forecast but this is the error that I get:

I am working with about 300,000 rows of data. Most of the report has already been built. My data just doesn't cotain certain dates. How can I solve this issue as quickly and efficiently as possible?.

Thanks in advance.

[Arul · Accepted solution]

@HamidBee ,

You need to have continuous date where each date should have data pointers then only it will work.

For example,

Case 1:

If you want show data by keeping date as a lower granularity then each date should have atleast one data value for that particular row. If that exists then forecasting would work as expected or else it would throw the above error.

Case 2:

If you want show data by keeping month as a lower granularity then each date may not have atleast one data value for every date since we are aggregating them on a month level. In this case it forecast would work eventhough we don't have data value value for each data point.

I hope it will help you!!

Thanks,

Arul