Help plotting data

Grafana
1

Hi,

I have a chart that displays failed/successful connection attempts - data source is MSSQL. When we have several failures / successes the chart displays as I would expect. As below.

image
image913×266 6.9 KB

However, when there is only 1 / 2 data points the graph is scaling across the whole X axis (as below).

image
image919×268 9.09 KB

The query within Grafana is:

SELECT
  $__timeEpoch(date),
  count as value,
  'Success' as metric
FROM
  ITKSendsBreakdown
WHERE
  $__timeFilter(date)
AND cms_service_code = 'RX8'
AND response_status = 200
ORDER BY
  date ASC

Any ideas why this may be happening? The database has grouped the data in 10 minute intervals

Columns (date, count and response_status).

Any help would be appreciated!

Danny

2

Is there an argument called fill(0) ?

In my charts, with InfluxDb I can add this argument to set the unknow datapoints