0 Replies Latest reply: Oct 19, 2018 5:11 AM by Andreas Jensen RSS

    Line chart and date range

    Andreas Jensen



      I'm trying to make a Vizlib line chart for my forecasting model. But as you see below, as soon as the future dates begins, Actual values hits zero.


      How can I make a set analysis date range only for Actual values, thus I only get a range of dates where I also have records.


      My code

      Forecast = Sum({<hovedbranche_kode={$(vValgtBranche)}>}yhat)

      Actual values = Sum({<hovedbranche_kode={$(vValgtBranche)}>}[Brancheomsætning])


      I have records until 01/08/2018.


      Thanks in advance!