I would like to calculate the Work in Progress for my products so I would need to compare dates.
My table is :
I would like to draw a line chart showing the number of product that are between the beginning and the end date in function of generic dates. So I will have the number of product in the production line in function of dates.
Do you think I have to rearrane my table to do that ?
Could you please help me ?
You'll have to use intervalMatch in the script to build this:
Please try to refer to this to understand the intervalMatch function :
My data :
|ID product||beginning date||end date|
I would like to be able to have the following table :
|Date||Number of products in progress|
Number of products counts the number of product with beginningDate < current date < end date