I am preparing report which has 2 weeks of data excluding weekends,weekstarting I assigned values as 80 next day target values80 - 8 = 72 , etc and last day which means end of 2nd week
target value is 8
when ever I open the report it should show on the day value
I am sure there are other ways to do it, but this is one way:
I created 3 fields:
ReportDayCount = DATEPART('day',[Date])-3
Starting Value = 80
Value = [StartingValue]-([ReportDayCount]*8)
Adjust DayCount if you need to exclude weekends
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...