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

    Line chart and date range

    Andreas Jensen

      Hi,

       

      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.

      forecast.PNG

      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!