Charting Un-Recorded Points

[ahorta86]

I have created a graph which measures non-conformance incidents relative to each week. However, every single week has not received a non-conformance incident. So far there is one week with no reported incidents and, therefor, nothing plots for that week. As you can see in the image below, there is no data point recorded for week 16. Is there any way to change something in the chart query or maybe even write another query to get around this? I would like for my chart to show a value of "0" for any week that does not receive an incident.

[June7]

Nope, need record. Could have a table of all possible weeks then include that dataset in query.