Hi all,
I've created a Canonical Date dimension that contains continuous dates.
I'm trying to get forecast on a line chart which is using Month-Year as the dimension axis. However, I'm not getting the forecast option enabled in the Advanced Analytics pane of Vizlib line chart.
Can anyone suggest what can be the issue?
Function I'm using for Date Dimension -
=If(Date#(Canonical_Date, 'DD/MM/YYYY')> Date#('01/07/2021', 'DD/MM/YYYY'), (Date(monthstart(Canonical_Date), 'MMM-YY')))
