This content has been marked as final. Show 3 replies
The topic isn't worded really well, so I figured more explanation is necessary. v10.5 by the way.
I have a datasource that looks like this:
What I want is a field that, for each product, retrieves the maximum value of the date that is at least one week before the current row. Note that Ranker (in my workbook) might not (probably will not) exist in the data set, that was a helper column.
So in my head, I am looking at a row, filtering the datasource for rows where the Product matches the one in the current row AND the Date at least 7 days before, then getting the Max date of what is left.
note that it is NOT simply the row before, because the date cannot be within 6 or fewer days than the current one. Also, I understand that I can do this outside of Tableau, but I want to learn more data manipulation inside of it.
Thanks for your help.