Default value on X

Hi all,

I'm a bit new to BIRT, and I had one question about using charts :

I use an area chart to display data coming for a database,
on X-Axis I have date/time value serie and a custom value on y-axis.

But in this database ( date, value ) I dindn't have a value for each
date/time value ( eg each minute ).

How can I setup the chart to display nothing when there's no data
for y-axis and just to leave it blank instead of having a plain chart.

for example :

14:01 -> 123
14:05 -> 345
14:57 -> 43
15:07 -> 98
...

So I would have a blank area between 14:57 and 15:07

Thanks a lot for any help.

Find more posts tagged with

Comments

bhanley

Does your data have an entry for each minute regardless if there is value to map onto the Y-Axis? If so, just add a filter to your data set to remove the entries where Y equals zero.

moh

It's not the case, It is possible that I didn't have
date/time record for each minute.

Is there a way to add those missing records dynamically ?
or an option to just say to birt to leave it blank on the chart ?

thanks.

moh

I missed something : I'm using birt 2.3.2