I am trying to use the sets method from Jim Dehner's blog, See it your way https://jimdehner2.blogspot.com/2019/12/yoy-three-different-approaches.html. Using this method, I can use the view to filter another view. It works using Superstore data, but not with this scaffolded data.
Data used here is made to be daily using scaffolding technique described in Sasha Singh's blog, Scaffold data with Tableau Prep https://www.tableau.com/about/blog/2018/12/scaffold-data-tableau-prep-fill-gaps-your-data-set-99389.
In the Superstore data, the sets method works without including the dates in the view. In this data, current and prior year values appear if I include admit year, but the difference calculations are incorrect. Once I exclude the admit year, then nothing is appearing in the view.
Any help is appreciated!
I just noticed that the workbook had inner join like you said. I meant it to be a right outer join. Here is a corrected workbook.
