Hi, this issue seemed to start many versions ago - bars are overlapping. Hoping it’s a beginner mistake, thanks in advance-
Data is from mssql, summarized by day, one record per day
2020-08-20 20:00:00 2.6 6.4 0 0 6.2
2020-08-19 20:00:00 3.8 5 0 0 6.2
note i tried shifting time zone in browser and also TODATETIMEOFFSET so the times above land on midnight.
{
“type”: “graph”,
“title”: “Panel Title”,
“gridPos”: {
“x”: 0,
“y”: 0,
“w”: 12,
“h”: 9
},
“id”: 23763571993,
“fieldConfig”: {
“defaults”: {
“custom”: {}
},
“overrides”:
},
“pluginVersion”: “7.1.4”,
“datasource”: “g59-grafana”,
“targets”: [
{
“refId”: “A”,
“format”: “time_series”,
“alias”: “”,
“rawSql”: “SELECT date as ‘time’, u1,u2,u3,u4,u5 FROM [Management].[dbo].[dash_dailysummary]”
}
],
“renderer”: “flot”,
“yaxes”: [
{
“label”: null,
“show”: true,
“logBase”: 1,
“min”: null,
“max”: null,
“format”: “short”,
“$$hashKey”: “object:320”
},
{
“label”: null,
“show”: true,
“logBase”: 1,
“min”: null,
“max”: null,
“format”: “short”,
“$$hashKey”: “object:321”
}
],
“xaxis”: {
“show”: true,
“mode”: “time”,
“name”: null,
“values”: ,
“buckets”: null
},
“yaxis”: {
“align”: false,
“alignLevel”: null
},
“lines”: false,
“fill”: 1,
“fillGradient”: 0,
“linewidth”: 1,
“dashes”: false,
“hiddenSeries”: false,
“dashLength”: 10,
“spaceLength”: 10,
“points”: false,
“pointradius”: 2,
“bars”: true,
“stack”: true,
“percentage”: false,
“legend”: {
“show”: true,
“values”: false,
“min”: false,
“max”: false,
“current”: false,
“total”: false,
“avg”: false
},
“nullPointMode”: “null”,
“steppedLine”: false,
“tooltip”: {
“value_type”: “individual”,
“shared”: true,
“sort”: 0
},
“timeFrom”: “0d”,
“timeShift”: “0d”,
“aliasColors”: {},
“seriesOverrides”: ,
“thresholds”: ,
“timeRegions”: ,
“maxDataPoints”: 60,
“interval”: “1d”,
“hideTimeOverride”: false
}