4 Replies Latest reply: Jan 15, 2017 1:13 PM by Stefan Wühl RSS

    a count value dated yesterday

    Fabio Mazzarelli

      Hi,

       

      howto to count a value dated Yesterday?

       

      Example:

      N°     STATUS          PROGRC          day

      1          Closed        10                    monday

      2          Closed         6                     tuesday

      3          New              72                  wednesday

      4          Closed          23                   thursday

      5          Closed         1                    friday

      6              -                    -                    -

      7              .                    -                    -

      ......

       

      Normally I use (UI) (char bar)

      x: day

      y: sum({<STATUS = {'Closed'}>} [PROGRC])

       

      now I have to add the value of the previous day

      x: day

      y: sum({<STATUS = {'Closed'}>} [PROGRC]) + value of previous day if status is Closed

       

      So that

      Monday 10 + 0

      Tuesday 6 + 10

      Wednesday 72

      Thursday: 23 + 72

      Friday: 1 + 23

       

      Howto calculate it?