What is the end goal? The chart you are showing can be accomplished using a LOOKUP function.
Is there any particular reason you are looking to use an LoD?
What I showed was a simplification to illustrate the issue. If I can get
the date sorted out with an LOD calc, it would enable a whole series of
secondary computations that I am sure would be easier and more elegant and
flexible with LOD calcs.
On Thu, Oct 1, 2015 at 7:25 PM, Rody Zakovich <
What you do here all depends on what the end goal is.
The only iterative calculation Tableau has is PREVIOUS_VALUE(), but we can use LOOKUP() as well in certain situations.
LoDs are simply a means of returning aggregated results to a row level based on the dimensions addressed in the calc (And the vizLoD for INCLUDE/EXLCUDE). So I'm not sure if an LoD would work for this particular situation.
Could you provide more detail on what you are trying to accomplish, as well as, an example workbook?
I know that what I do depends on the end goal, and I appreciate your desire to help solve my business problem. And I actually know how to solve it with table calcs.
I've been working a lot with LOD calcs lately, and I'm trying to try them out in different scenarios to see what they can do and how/if I can use them to address certain challenges. So the question I asked reflects the problem I want to solve - can a LOD calc be written to do what I want? That is my only end goal at this point. I know I can write one to give me the max value, and thus the one before the max, etc. I was looking at this as an extension of that but got stumped.
I could tear apart my data set to send an example, but I think the table I created is simple and shows everything necessary to illustrate the question.
Anyone else have an idea?
No, an LoD calc cannot do what you are trying to do here.