Issue With Line Chart Forecasting

dquintana — Mon, 18 Sep 2023 19:25:58 GMT

Hello,

I have a line chart consisting of a 'Date' dimension and a 'Daily Risk Score' calculated master measure. I have a filter named 'User ID' which filters everything based on a selected user. I am having an issue when I enable the "Forecast" option on the measure. Before enabling, the measure data points match up just fine with their corresponding dates. Note the Daily Risk Score on 12/17/2021 is 1.3:

However, when I enable Forecasting, it compresses the above data points into a very small date range, usually between January and April. The data points do not correctly line up with their corresponding Date anymore, as shown below:

Note how the same Daily Risk Score that was for 12/17/2021 is now on the Date 4/14/2021.

Can someone explain why this may be happening and how I can fix it? For reference, here is how the table looks with the User ID, Date and Daily Risk Score:

And here are my Forecast settings for the 'Daily Risk Score' measure:

and for the Date dimension:

topic Issue With Line Chart Forecasting in App Development

Issue With Line Chart Forecasting