Days wise sale input box

[prma7799]

Hi All,

I have one chart in that dimension is day([Date]) and Expressions are CM , LM & PYM

Now sometimes user want see only last 7 days data using input box.

Say suppose I have select Apr Month so it will see only last 7 days

i.e

30

29

28

27

26

25

24

Thanks

[PrashantSangle]

In your expression try below

sum({<date={">=$(=date(max(date)-7))<=$(=date(max(date)))"}>}sales)

Note: Change date format as per your date format,

replace 7 with input variable to calculate dynamically

Regards,

[prma7799]

Hi Prashant,

I don't want to change the  expression. I want like Top 10 analysis sometime user will inter 5 , 12 , or 30 also in input box .

Thanks