Line Chart with Zero

[#1]

So I want to create a line chart but it has to handle zero values in months where we had no scratches in our fire department.  Essentially when a user selects a year my chart it should display a line chart thru the twelve months and draws the line segments.  There are some months we have no scratches so the chart skips that month and draws the wrong segement.  I need it draw the line down to zero. 

Can any one help.  Attached is my data I am working with.

Thanks

~Norman

[sunny_talwar]

Do you have a qvw which have the data loaded into it?? Seeing that will be more helpful, then just looking at the data.

[#3]

Here is my QVW filw.

Norm

[MarcoWedel · Accepted solution]

Hi,

one solution could be:

hope this helps

regards

Marco

[tschullo]

You will need to create zero (or near zero) values for each month if no data available for that month.

if you put in a value of .001 but tell chart to round to whole numbers ot will show a data point of zero and get you the desired results.

You can add the "zero" month values in the script as a second load where no vales are found for a given month.