Possibly posted before but struggling to get to the answer.
Two dates for a given product -
Registration Date
Disposal Date.
Looking for thebest way to compare a count of the products by both dates on a time line, in order to show the purchase vs disposal cycle.
I.e
Registration DateDisposal DateAsset ID
| 01/01/2016 | 01/03/2020 | 123 |
| 01/01/2019 | 01/05/2021 | 111 |
| 23/09/2017 | 06/10/2024 | 144 |
Between date 1 and 2 purchased vs disposal counts of assets?
Thanks in advance
