I am trying to give users a grid view with "Last week sales", "Yesterday Sales", "Month till date" sales and "Year till date sales".
Month till date, year till date and yesterday were easy to calculate with datediff.
But wasn't able to figure out, how to give them last business week sales.
So that would be Monday to Friday last week.
Hoping someone can help with this calculation.
Here are two threads that you may find helpful:
DateDiff for Working days only
How to show the most recent FULL week only?
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...