How I can create last 90 days data extract in tableau ? required last 90 days data availability in the extract. Its give good performance for my dashborad with HIVE data
Create this calculation:
[Order Date] >= DATEADD('day', -90, TODAY())
Use it as a filter when you do your extract:
If you put an integer parameter in place of the 90 you can adjust the number of days back. If you're going back you'll have to keep the negative sign front of the parameter.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...