Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Would like to seek advise on how to write correct set analysis with this situation.
I have # Sales per day.
The results I want is the sum of the running 7 day sales
Sample Data
Date | Sales |
---|---|
Oct 1 | 5 |
Oct 2 | 10 |
Oct 3 | 8 |
Oct 4 | 9 |
Oct 5 | 7 |
Oct 6 | 5 |
Oct 7 | 6 |
Oct 8 | 4 |
Oct 9 | 2 |
Oct 10 | 34 |
Oct 11 | 1 |
Oct 12 | 2 |
Oct 13 | 3 |
Oct 14 | 4 |
Oct 15 | 4 |
Oct 16 | 5 |
Desired Result
Date | 7 days sale |
---|---|
Oct 7 | 50 (sum of oct 1-7) |
Oct 8 | 49 (oct 2-8) |
Oct 9 | 41 (oct 3-9) |
Oct 10 | 67 (oct 4-10) |
Oct 11 | 59 |
Oct 12 | 54 |
Oct 13 | 52 |
Oct 14 | 50 |
Oct 15 | 50 |
Oct 16 | 53 |
Hi
small change in Liron Baram exression.
rangesum(above(sum([Sales]),0,7))
hi
use this expression
rangesum(above(sum([Sales]),0,6))
Hi
small change in Liron Baram exression.
rangesum(above(sum([Sales]),0,7))