(Version 9.1 here)
I'm looking at this.
Tableau has a cool function called PREVIOUS_VALUE that lets you look at and interact with whatever was in the same calc in the previous index location. (So in this example your index is running table(down).)
See attached. Work is done in [Calculation1].
I'll leave it up to you to hack with Sat/Sun/Mon, but you may need to do another PREVIOUS_VALUE calc to set "Delay" vs "No Delay" for those three days. You can probably do something in your Date Delay Tag to set all three based on each other.
And then I created a [Calculation2] that pulls the largest value of Calc1 in the data set. I displayed that in the Title of the sheet.
Thanks Joe, that's a huge help. Is there a way to show how many times there were consecutive days without a delay?
For example, if these were the instances with consecutive days without a delay we'd like to see a value of 3.
1/1/2017 No Delay
1/2/2017 No Delay
1/23/2017 No Delay
1/24/2017 No Delay
1/25/2017 No Delay
1/26/2017 No Delay
2/11/2017 No Delay
2/12/2017 No Delay
2/13/2017 No Delay
1 of 1 people found this helpful
I made two more calcs. Calc3 looks forward when we have a run-number greater than 1. (Which I interpret to mean that we have an actual run.) When the next cell goes back to zero (or it comes back null, meaning we're at the last cell) then we have detected the end of a run. I set the value to "X". (Otherwise the value is null.) Then I have another calc that counts up the number of X values. I display that in the title.
Such a cool solution. Thanks for the help Joe, I really appreciate it.