Line charts

cypherdj

Hi,

I've created a report with a line chart, which displays the count of records grouped by date (x-axis).

However, there may be dates when there are no records at all.

Would it be possible to get the line to dip to 0 in this case, so the trend appears more accurate?

Thanks,
Cedric

mwilliams

Hi Cedric,<br />
<br />
There's not a real good solution to that I don't think. You should go to <a class='bbc_url' href='http://www.eclipse.org/birt/phoenix/reportabug.php'>http://www.eclipse.org/birt/phoenix/reportabug.php</a&gt; and submit an enhancement request for the scaling on the charts to cover this.<br />
<br />
For now, one thing you could do would be to create a scripted datasource or a datasource of some other type that can bring in all the dates for you. Then you can do an outer join on your two datasets and chart based off the new joint dataset. There may be other possible work-arounds, but that's one I know will work for sure.<br />
<br />
Hope this helps.