I saw there was a potential solution in that thread. Are you still looking for feedback and help?
I'm done in that thread.
As far as I'm concerned there really wasn't a solution there.
At this point I have no need for what is being asked here, but it would be interesting to know if there is a way to do a PREVIOUS_VALUE type of function that looks back x-many cells. (And no, LOOKUP wasn't the solution. We needed the recursive capability of PREVIOUS_VALUE. LOOKUP doesn't do that.)
1 of 1 people found this helpful
I'm a little late to this (I follow @Patrick so just saw his response). I've seen this kind of recursion need about once per year on the forums where someone is trying to do some complicated simulation/modeling, it's just not possible in "vanilla" Tableau because we only get the single recursion from PREVIOUS_VALUE() that just goes back one address in the partition. What we'd really need for things like this are more loop constructs.
In these cases my suggestion to users at this point is to:
a) Bang at it until something really hacky can come out like what Joshua did in the post (which I think might be more complicated than it needs to be, but I haven't looked closely enough).
b) Use the R (or as of v10.1 Python) integrations since those have loop constructs.
Thanks for the confirmation, Jonathan. I never like to say, "Tableau can't do that." Which is why I started this thread -- to confirm it in this case.
Thank you Jonathan.. It's good to know you are always looking over my shoulder. Keeps me honest.