Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am struggling with a simple issue.
A table has a date as dimension and a value as expression. I would like to add an expression showing this value for the "day-7".
Trying this is not working:
sum({<date={"$(=date(max(date)-7))"}>}value)
Using "above" function is not the right solution as it will not work for the 6 first rows of my table.
Attached is an example. Does someone have the solution to this?
Thanks in advance
Fabio,
It's almost working, the problem is when you select a date, the table is still showing all values.
Ok, explain me please, why can't to create another field on script to bring the value you need.
Something like:
Peek(value,-7) as value1 |
Because my fact table is at order line level, not at day level. Peek(value,-7) would not give the amount 7 days ago.
Thanks
But you could create such consolidated extra table ... you will need make a compromise ...
- Marcus