-
1. Re: Count how many products are expired and approaching expiration date and track them by last 6 months
Patrick A Van Der HydeJul 6, 2017 12:17 PM (in response to Abdallah MJ Musmar)
1 of 1 people found this helpfulHello Abdallah,
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.
Patrick
-
2. Re: Count how many products are expired and approaching expiration date and track them by last 6 months
Yuriy FalJul 6, 2017 5:07 PM (in response to Abdallah MJ Musmar)
Hi Abdallah,
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.
Yours,
Yuri
-
expiration_data_YF.twbx 73.3 KB
-
-
3. Re: Count how many products are expired and approaching expiration date and track them by last 6 months
Abdallah MJ Musmar Jul 7, 2017 12:00 PM (in response to Patrick A Van Der Hyde)Thank you Patrick. This is very helpful
-
4. Re: Count how many products are expired and approaching expiration date and track them by last 6 months
Abdallah MJ Musmar Jul 7, 2017 12:01 PM (in response to Yuriy Fal)Thank you Yuri! I completely understand what you did and it is amazing! Works exactly as it should 10/10
-
5. Re: Count how many products are expired and approaching expiration date and track them by last 6 months
Yuriy FalJul 7, 2017 12:33 PM (in response to Abdallah MJ Musmar)
Abdallah, you're welcome.