Hi all
I have a dataset with inventory data for different time ranges.
Now I need to know how many devices were installed for every month since 2022-01, based on the install date and retired date.
like
2022-01 = 5
2022-02 = 8
2022-03 = 9
..
..
2025-08 = 141
Some of the devices were installed only for some month within the time. (device 153/device 145/...). They must be counted only for this months.
I have attached an example dataset
Do you have eventual an idea how to calculate this ?
Many thanks in advance for your reply.
Steffen
