Missing value in charts

darpao

I have a problem with a chart in BIRT.<br />
<br />
I read data from an access database. I would like to do a chart that could give me a monthly time series, but when there is no value in the database for a given day, the chart don't consider it as a 0 value and draw a line from a day to another mistakenly.<br />
<br />
As you can see in this image:<br />
<br />
<a class='bbc_url' href='http://img706.imageshack.us/img706/1195/chart.jpg'>http://img706.imageshack.us/img706/1195/chart.jpg</a><br />
<br />
there are no value in day 3, 8, 9 and so on.<br />
<br />
I would like the line go to zero in this cases.<br />
<br />
I try everithing!! But I'm not able to solve this problem.<br />
<br />
Anyone could help me?<br />
<br />
Thanks.

mwilliams

Hi darpao,<br />
<br />
The following post from the devShare may help you with this.<br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/1006-add-missing-dates-to-chart-category-table/#description'>Add missing dates to chart category / table - Designs & Code - BIRT Exchange</a><br />
<br />
All you really need is a scripted dataSet that creates a row for each date in your range. Then you would do a join on the two datasets and create a computed column to put a 0 in for each date that doesn't have a value from your original dataSet. Hope this helps. Let me know if you have questions.