1 of 1 people found this helpful
The data in this is not snapshot data of the sort that a typical data warehouse would hold but is instead an attempt to create that sort of data from a single point in time. In Tableau, you could build an ongoing data base that does this for you per - Periodic Snapshots with Tableau Incremental Refresh – VizPainter but I would recommend backing up before each extract should something go wrong.
I do not know of a way to create this sort of a view with a single snapshot of data.
As Patrick had said, for this kind of analysis
you need a periodic snapshot data structure,
and what you have is an accumulating snapshot.
The necessary data transformation ("re-shaping")
could be done in Tableau -- using a Cross-Join
with the Calendar Dimension (at the granularity of Month).
Please find the attached as an example.
expiration_data_YF.twbx 73.3 KB
Thank you Patrick. This is very helpful
Thank you Yuri! I completely understand what you did and it is amazing! Works exactly as it should 10/10
Abdallah, you're welcome.