chart date grouping with time values not in data

OK - so I have a report that does a running sum of some data over a period of time (the category, x-axis).
I have setup grouping on the category x-axis by month with an interval of 12 (essentially do a running sum for 12 months but display the month info on the axis as a label).
All works great, however, I'm seeing labels on the axis that represent time in the past.
My data starts at 1-JAN-08 and the last data point has a date value of 29-DEC-08.
However, the resulting chart has displays the first data point at what seems like 1-DEC-07.
What is going on here?

Find more posts tagged with

Comments

mwilliams

Hi robertl,

So, you have no data from back that far available, yet it still shows it?

robertl

I have data in the database from that far back, but the query that feeds that report doesn't fetch it.
I have verified this by running the SQL outside of the designer and ensuring that no data from 2007 exists in the data set...
It also seems weird to me that the series in the chart isn't starting right at the Y-axis. It seems to start a little to the right of the Y-axis...

mwilliams

robertl, 
 
I'm not sure why this would be happening. You can log a bug for this at <a class='bbc_url' href='http://www.eclipse.org/birt/phoenix/reportabug.php'>BIRT: Reporting Bugs and Requesting Enhancements</a>. 
 
As a workaround, you could probably add a filter to your chart as well. 
 
As for the way the chart is set up, you can go to plot -> area format in the chart editor and set the left inset to a negative number. That'll move the series closer to the y axis.