Here's a calculation and a filter that accomplishes the goal:
The lookup table calc gives the previous value (you'll have to set the fact that it restarts every Employee #):
The filter is just a check to see if it is different from the current value.
I've attached the workbook and am happy to supply any additional explanation!
Change from Prior Week.twbx.zip 62.5 KB
Simple, yet brilliant...thanks Joshua
I have a question about your solution here. (http://community.tableau.com/message/196866#196866) How did you restrict your lookup of the previous value to within the records for a single employee? I downloaded your example workbook and tried to replicate it for a somewhat similar problem, but my implementation is picking up the previous row, which is for a different entity (in my case, it is farms, not employees).
This may be related to the fact that I bring in 4 (months, 1 record/month) worth of records for each farm, but I do a quick filter on the months so that I can see only the current month. When I define the "previous values" for my field of interest, it then picks up the previous farm instead of the previous month value for the same farm?
I can send a packaged workbook, but I would need to pare it down considerably due to confidentiality restrictions, and I am never sure if just hiding fields removes them from a refreshed extract and subsequently created twbx file?
Anyway, would appreciate your insight on this if you had time.
I'll have to refresh my memory on what I was doing and get back to you on what I was doing (ping me if I don't get back to you in a day or two). In the meantime, check out Jonathan Drummey's explanation of table calculations: http://community.tableau.com/message/202808#202808. It is one of the best explanations I've seen.
Hello Joshua (and Buzz) - I am super glad I found this thread as I have been grappling with this same issue. Unfortunately, I have run into the same problem that Buzz ran into - which is that it is looking at the value of the previous row, not restricting its lookup to the same employee.
In my instance, I have prospects moving through stages and between group - same construct. I have one row per prospect per month with a stage and a group field. I need to measure movement from specific groups and stages to other groups and stages as part of performance management.
I would love any assistance in conquering this obstacle if either of you ever found a proper solution. Many thanks!
I was wondering if you could help me with a similar problem. I have tried a multitude of different things to try and get exactly what I want but have had no luck so far. I have a this problem in question posted on the forum but haven't had any luck with the responses so far and was wondering if you had any insight that could help.
Here is the posted question: Lookup Value
Any guidance and/or insight would be much appreciated!
I Have column [X] and I want to return the last updated value for this column, not the last inserted value !!!