7 Replies Latest reply: Mar 2, 2017 7:13 AM by Anna fuksa RSS

    Fill up missing date values

    Hannes Peiffer

      Hi all,

       

      i have a very simple report, screenshot is attached

       

      Dimension is Date

      Expression is in the screenshot also

       

      My challenge is that I want to fill up all the dates that are missing in the chart with the value 0

       

      For example I want to have the dates between the 04.01.2017 and the 12.01.2017 filled up with the missing dates (05.01-11.01) and the value 0, something like this:

       

      DateValue

      05.01.2017

      0
      06.01.20170
      07.01.20170
      08.01.20170
      09.01.20170
      10.01.20170
      11.01.20170

       

      I can't do this in the script because of the set analysis in the expression, otherwise I would choose the "peek"-Function.

       

      Suppress Null-Values is deactivated everywhere

       

      Thanks for some input :-)

       

      Hannes