In Tableau How to sum the last 7 days of the value

Question

How to sum the last 7 days of the value from orders? ( Data set used:  Global superstore 2016)

Answer 1

It can be achieved easily by creating a calculated field, here is how it goes:

1. Create a calculated field :

2. Use calculation:

   SUM(IIF(DAY(TODAY())-DAY([Order Date]) <=6, [Sales], 0))

3. Then you will get the sum of last 7 days as wanted.

Hope this helps you.

For an in-depth explanation check out Tableau Training Course details.