Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am looking to create a cumulative bar chart with a set of data. I've looked at other posts, but nothing seems to fit my circumstances.
I have a range of products and their installed dates:
Dimensions: Year, Month and Product Name
Expression: rangecount(above( TOTAL Count(EmployerProduct_id), 0, rowno(Total)))
The chart is set to 'Full Accumulation'
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.
Your help is appreciated!
Thanks,
M
could you prepare small sample qv file with your data ?
Hi Pari,
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.
Thanks.
M
Hi
sorry for late response...
1. You should create separate table for calendar with all the possible values CalcYM
2. ....still working on it....
No problem, thanks!
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?
Thanks again.
M
as i look at your data table, I suggerst to do crosstable load to make the table like:
Product_Name | Date | Status | Date | Type |
A87 | 24010 | In Service | 14/01/2007 | Calc |
A87 | 24010 | In Service | 14/01/2007 | CAT |
A87 | 24010 | In Service | Null | Commission |
A87 | 24010 | In Service | Null | Deliver |
A87 | 24010 | In Service | Null | Install |
A87 | 24010 | In Service | 11/09/2006 | Ship |
A87 | 34986 | In Service | 16/01/2007 | Calc |
A87 | 34986 | In Service | Null | CAT |
A87 | 34986 | In Service | Null | Commission |
A87 | 34986 | In Service | Null | Deliver |
A87 | 34986 | In Service | Null | Install |
A87 | 34986 | In Service | 16/01/2007 | Ship |
A65 | 14301 | Decommissioned | 17/01/2007 | Calc |
A65 | 14301 | Decommissioned | Null | CAT |
A65 | 14301 | Decommissioned | Null | Commission |
A65 | 14301 | Decommissioned | 17/01/2007 | Deliver |
A65 | 14301 | Decommissioned | 17/01/2007 | Install |
A65 | 14301 | Decommissioned | Null | Ship |
A66 | 30855 | In Service | 17/01/2007 | Calc |
A66 | 30855 | In Service | Null | CAT |
A66 | 30855 | In Service | Null | Commission |
A66 | 30855 | In Service | 17/01/2007 | Deliver |
A66 | 30855 | In Service | 17/01/2007 | Install |
A66 | 30855 | In Service | Null | Ship |
A24 | 97241 | In Service | 26/01/2007 | Calc |
A24 | 97241 | In Service | Null | CAT |
A24 | 97241 | In Service | Null | Commission |
A24 | 97241 | In Service | 08/05/2006 | Deliver |
A24 | 97241 | In Service | 26/01/2007 | Install |
A24 | 97241 | In Service | Null | Ship |
or even delete rows with Date=null
then try to create simple calendar (starting from 01-01-1970) with:
Date | YM |
01/01/1970 | 19701 |
02/01/1970 | 19701 |
03/01/1970 | 19701 |
04/01/1970 | 19701 |
05/01/1970 | 19701 |
06/01/1970 | 19701 |
07/01/1970 | 19701 |
08/01/1970 | 19701 |
09/01/1970 | 19701 |
10/01/1970 | 19701 |
11/01/1970 | 19701 |
12/01/1970 | 19701 |
13/01/1970 | 19701 |
… | … |
… | … |
… | … |