help with Time Series Forecasting

cchen-pm2 — Mon, 13 Jun 2022 18:53:06 GMT

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

Re: help with Time Series Forecasting

Wadeyy03 — Fri, 31 Mar 2023 11:08:14 GMT

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.

topic Re: help with Time Series Forecasting in Dashboards & Analytics Discussions

help with Time Series Forecasting

Re: help with Time Series Forecasting