I'm trying to calculate the Weighted average for yesterday and last seven days from Yesterday. my calculation is valid but still it isnt showing up any value.
For Yesterday weight average i have a created calculated field :
IF ATTR([Day.of.Actual.Order.Date]) = TODAY()-1
Case2: For Past seven days of weight average
For Yesterday weight average I have a created calculated field :
IF ATTR([Day.of.Actual.Order.Date]) <= TODAY()-2 AND
ATTR([Day.of.Actual.Order.Date]) > TODAY() - 8
they return this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...