Essentially the issue I have is that where there has been no install taken place for any given day (which I converted into Year, Month), this does not show an accumulation of that record in that month (see .png attachment of screenshot).
I'd prefer not to use an inline table to populate the days where no install has taken place with a product record of '0' (which won't work anyway since I am counting the records, not summing) as new products are added to this periodically and it is a large enough data table already.
Can anyone help? Please let me know if you require further information.
Please find attached a sample fo the data. The second graph is the cumulative chart, but as you can see where there have been no installations in certain year/months, it does not accumulate the product from the previous months.
In addition, once this is done I need to find a way to then take a product away from the chart at the point of it being decommissioned so that I can see a true reflection of the installed base for whatever month I am looking at. So if product A20 was installed in May 2007 but then decomissioned in May 2012 I would want to see it from May 2007-May 2012 in my chart but not beyond June 2012.
I was afraid you would say that! So there seems to be no other way... Just to be clear I would need to create circa 500 records for every calendar day since 1970 and then maintain these when a new product comes along?