@jason1028,
It seems like the x-values that are passed to the chart are null. X-Values can either be numeric or date-time. Please take a look at this sample project with data for an example on drilldown chart with data from database. You can change the structure of the database table according to your requirements, update query accordingly and pass datapoints to the chart-options.
—-
Manoj Mohan
Team CanvasJS