Missing Rows MySQL Database

I have a simluation that creates a local MySQL database of data. The issue is that if nothing occurs in the step of the simulation then no row is written in the MySQL database. For example this creates columns that could have the following series; 1,2,3,4,7,8,9,10 with 5 and 6 mising. When I try to make a bar chart in Spotfire it just doesn't create a bar for the missing data, and if I set the axis to continous the bars are very small, because the values are only integers. Is there a way to have Spotfire to create the missing rows with a value of zero? Or is there any other solutions?

(1) Answer