Aquasar
  • Home
  • Portfolio
  • Articles
  • Pricing
  • About
  • Contact
WEB DEVELOPMENT |SEO |DIGITAL ADS

Dynamic Dates in Tableau

Jul 27th, 2019

Alex Quasar

data analysis

Show Only The Last Full Week

[Created Actual] < [Monday This week] AND 
[Created Actual] >= [Monday two weeks ago]

Where we can use DateTrunc and Date function to get the Monday for this week.

DATE(DATETRUNC('week', TODAY()))

And to get the date for Monday two weeks ago