1 of 1 people found this helpful
Very difficult to tell anything from that screenshot. You'll need to post a package workbook with sample/dummy data for us to help you in more than a generic way. You could try:
DATEDIFF('day', LOOKUP(ATTR([Date], -1),ATTR([Date])
Shawn - amazing, thanks! Furthermore to my newness to tableau, the calculations are working, however I need the new field I have created from your calc to reset after every change in the first field in the row. I'll try to create a package, but essentially the rows are
Right now the calculation keeps running as normal, but needs a reset on Item. I'm working on it, but not strong on partitioning and addressing!
Hope to hear back from you!
If you're still tinkering with this, you might find these kb articles useful:
When you reference a previous row, you are making your calculated field a table calculation.
You will see a little triangle appear on the pill when it's used in the view.
You can edit how it computes and change the levels at which it calculates, the sort method, etc.