Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Forecasting the data

Hi All,   I'm getting the below error while trying to forecast data but couldnt see any anormility in my dataset.   Can someone help here?    
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    Have you solved your problem? If not, please refer to the following blog.

    • Merge in another data set with all possible dates for the date range I wanted for the report, then use the dates from that 2nd data set for the X-Axis so every date in the range would have a data point.  
    • On the Merge dialog box, shown below, we select our Join/Merge key (ExcelNumericDate), and select our “Join Kind”, eg: INNER, LEFT, RIGHT etc… Be careful here to pick the correct type of join, Right or Left, depending on which order the data sets are in.

    More details: when your “Data is too irregular to forecast 

     

    Best Regards

    Community Support Team _ Polly

     

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