Table: Day - 7 figures issue

[#1]

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

[#2]

Fabio,

It's almost working, the problem is when you select a date, the table is still showing all values.

[fsimoes81]

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

[#4]

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

[marcus_sommer]

But you could create such consolidated extra table ... you will need make a compromise ...

- Marcus