forums

Use these forums to ask questions and discuss Tableau.

Set a number of weeks

Posted October 20th, 2008 by bbakhvalov
in Dates & Times

Hi,

I'm looking for how to create data set covered 6 last weeks time from now.

Thanks

Add new comment

Comments

On October 20th, 2008 James Baker said:

Filter discrete date, "Use All" plus Condition: "DATEDIFF('week', [Date], NOW() ) <= 6"

You're welcome.

reply
On October 21st, 2008 Erin Easter said:

The equation that James included above is what's known as a moving date filter. You can read more about these in the online help under the Create Moving Date Filters topic. There you'll find out how to show the current month, the current quarter, past 7 days, and son on.

--Erin

reply
Syndicate content Subscribe to the comments on "Set a number of weeks"