cancel
Showing results for 
Search instead for 
Did you mean: 

help with Time Series Forecasting

cchen-pm2
Partner
Partner

I have a materialized view with daily sales totals from July 2018 through Feb 2022 and I can't get the time series forecasting to work in a Line insight.  I've done the steps in the Getting Started with Machine Learning PDF posted here, but there's no prediction values just the source data.

The date value is in the Grouping Dimension tray, sum of total sales amounts in the Measure tray, Time Series Forecasting and Anomaly Detection in the Machine Learning tray.  There are some days without any sales so I inserted a row for those days with total sales amount of $0 to ensure the date range is fully populated, but that didn't make a difference.  Restricting the date values to a subset did not solve the issue either.

I am using an Incorta Cloud cluster, version 2022.4.0

Any suggestions?

Thanks,
Chris

1 REPLY 1

Wadeyy03
Ranger

You would need to model the data in a certain manner like converting the date column to the index column , attached a screenshot as well for your understanding. Hope it gives you a general idea.