I've hit a wall and am hoping you can help. I've got a transactional table of Assets that have Created Dates and End of Life Dates and Asset Status (Live, Failed). I've been asked to create a simple bar graph that shows how many assets were alive for a given month. In order to do so, I need to tie these assets to months (which aren't in the data) and do a distinct count of assets which were online between their Born On date and End of Life Date.
The data looks similar to this:
I'm trying to transform it to something like this:
Count of Assets
How do I create this YearMonth field and count the assets for each of the months if the month falls between the assets created and EOL date?