I need to build a logic at front end using Set Analysis which will pick all those product Names which are missing in between the dates.
Let me explain the requirement. Here is the table:
Work_date
Prod_Name
Value
Date_Num
Date_Num_Product
30/1/2022
Mobile
40000
44591
44591-Mobile
30/1/2022
Charger
1000
44591
44591-Charger
30/1/2022
Cable
4000
44591
44591-Cable
31/1/2022
Mobile
50000
44592
44592-Mobile
31/1/2022
Charger
2000
44592
44592-Charger
31/1/2022
Cable
3000
44592
44592-Cable
4/2/2022
Mobile
10000
44596
44596-Mobile
4/2/2022
Cable
1000
44596
44596-Cable
15/2/2022
Mobile
50000
44607
44607-Mobile
15/2/2022
Cable
5000
44607
44607-Cable
7/3/2022
Mobile
60000
44627
44627-Mobile
7/3/2022
Charger
3000
44627
44627-Charger
7/3/2022
Cable
4000
44627
44627-Cable
7/3/2022
Insurance
6000
44627
44627-Insurance
30/01/2022 - It has 3 Products: Mobile, Charger & Cable 31/01/2022 - It has 3 Products: Mobile, Charger & Cable 04/02/2022 - It has 2 Products: Mobile & Cable 15/02/2022 - It has 2 Products: Mobile & Cable 07/03/2022 - It has 4 Products: Mobile, Charger, Cable & Insurance
If you see 30/01/2022 & 31/01/2022 has 3 products and 07/03/2022 all those 3 products available in it but if you see
04/02/2022 and 15/02/2022, they have only 2 products. So, in this one product is missing which is 'Charger'.
So, I want to highlight 'Charger' as missing product.
'Insurance' is not a missing product because it is not available in 30/01/2022 & 31/01/2022.
What I'm thinking & trying:
When a user selects some random date range then using Set analysis, the code will pick max & min date and compare all the products in-between those range with the min & max date products.
