Need Help?

[paulwalker]

HI Community,

How to calculate last 7 days data... based on selection.

scripting and layout..

PFA,

[maxgro]

sum({$<Year=,Month=,Day=,date={">=$(=date(max(date)-7))<=$(=date(max(date)-0))"}>} cost)

PFA

[rubenmarin]

Hi Paul, you can flag last 7 dates, adding to the script:

Left Join (Test)

First 7 LOAD date, 1 as _IsLast7Days

Resident Test Order By date desc;

Then you can use this in graph expression:

sum({<_IsLast7Days={1}>} cost)

[its_anandrjs]

Hi,

Try to write

sum({<Year={'$(=Max(Year))'}, Day={'>=$(=Max(Day)-7) <=$(=Max(Day)) '}  >} cost)

Regards

Anand

[its_anandrjs]

For exactly last 7 days try this

sum({<Year= {'$(=Max(Year))'}, Day={'>$(=Max(Day)-7) <=$(=Max(Day)) '}  >} cost)

Regards

Anand

[paulwalker]

Hi Anand,

is it possible write in script level..???