Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Trying to do what I thought would be pretty straight forward but having no luck.
Hopefully putting this in front of some fresh eyes will get me where I want to be.
I have FullDate as my dimension and then two expressions. First expression is a simple Sum(MetricValue) and the second is the same sum but for seven days prior. Something like this: Sum({<FullDate= {'$(=Date(FullDate-7),'MM/DD/YYYY'))'}>}MetricValue)
Unfortunately this is not working.
Trying to avoid using If statement as the data is extremely high volumes. I cannot create it in the script as the number of days could vary. Below is a table of expected results.
Thanks so much for any creative ideas that someone my have.
FullDate | Sum | Sum Prior 7 | |
---|---|---|---|
10/19/2018 | 9 | 40 | |
10/18/2018 | 78 | 9 | |
10/17/2018 | 114 | 20 | |
10/16/2018 | 101 | 11 | |
10/15/2018 | 24 | 8 | |
10/14/2018 | 4 | 8 | |
10/13/2018 | 3 | 4 | |
10/12/2018 | 40 | ||
10/11/2018 | 9 | ||
10/10/2018 | 20 | ||
10/09/2018 | 11 | ||
10/08/2018 | 8 | ||
10/07/2018 | 8 | ||
| 4 |
Hi,
You could try this
1st Exp:= sum(sum)
2nd Exp:= Below(Sum(sum),7)
Excellent suggestion although I should have provide more detail. I would only want to see the first seven lines. When using dimension limits it's unable to reference. I would be ideal to somehow utilizing set analysis.
Hi Steve,
For the above requirement you could Hide the second column in the presentation.
Also limit the max Number to 7 in the presentation for the 3rd column.
Hope this is helpful.Thanks