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.
However, when there is only 1 / 2 data points the graph is scaling across the whole X axis (as below).
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!