Calculate Produce Life cycle and amount by range
I have a set of data showing the daily production quantity of the product and the factory location. Like the image below
I need to build a dataset to show for each product by country level,
the first day and the last day for the production, and how long is the production period.
Also, I need to show production time by range.
1-1000 pc, how long does it take, then 1001 -2000,2001-3000…
Just like the chart below
I want to use Group By but then I cannot keep the date column.
Or should I do it like the image shows. find the first day and the last day, and then minus them?
And also how do I build the range (1-1000,1001-2000…)
Thank you so much.