I got a chart with the evolution of efficiency rate and I am trying to display forecast for the next month.
For the moment I am just using the trend of my line and displaying it in the future. I got this expression :
If( date >= Date(Now()),
I got dates of the next month with no value for the efficiency rate.
But if I select a value in one of my lists, the forecast is not displayed. Only dates with value are displayed (past values). Future dates are not available.
Forecast is not displayed if I delete the TOTAL key word in my expressin...
Is there a solution for having my forecast in all cases ?