-
What Grafana version and what operating system are you using?
- 12.1.0 on HA OS
-
What are you trying to achieve?
-
get a heatmap with days and hours on diferne axis, like this:
-
-
How are you trying to achieve it?
- with a heatmap visualization
-
What happened?
- I am unable to define axis values and by default system only show me 1 line:
- I have this Data:
-
What did you expect to happen?
-
Can you copy/paste the configuration(s) that you are having problems with?
{
"id": 9,
"type": "state-timeline",
"title": "New panel",
"gridPos": {
"x": 0,
"y": 0,
"h": 8,
"w": 12
},
"fieldConfig": {
"defaults": {
"custom": {
"lineWidth": 0,
"fillOpacity": 70,
"spanNulls": false,
"insertNulls": false,
"hideFrom": {
"tooltip": false,
"viz": false,
"legend": false
},
"axisPlacement": "auto"
},
"color": {
"mode": "continuous-GrYlRd"
},
"mappings": [],
"thresholds": {
"mode": "absolute",
"steps": [
{
"value": null,
"color": "green"
},
{
"value": 80,
"color": "red"
}
]
}
},
"overrides": []
},
"pluginVersion": "12.3.0",
"targets": [
{
"datasource": {
"type": "influxdb",
"uid": "S0Cx63T4z"
},
"refId": "A",
"policy": "default",
"resultFormat": "time_series",
"orderByTime": "ASC",
"tags": [
{
"key": "entity_id::tag",
"value": "totalpower",
"operator": "="
}
],
"groupBy": [
{
"type": "time",
"params": [
"$__interval"
]
},
{
"type": "fill",
"params": [
"0"
]
}
],
"select": [
[
{
"type": "field",
"params": [
"value"
]
},
{
"type": "mean",
"params": []
}
]
],
"measurement": "W"
}
],
"datasource": {
"uid": "S0Cx63T4z",
"type": "influxdb"
},
"options": {
"mergeValues": true,
"showValue": "auto",
"alignValue": "left",
"rowHeight": 0.9,
"legend": {
"showLegend": true,
"displayMode": "list",
"placement": "bottom"
},
"tooltip": {
"mode": "single",
"sort": "none",
"hideZeros": false
}
}
}
-
Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
- No, just not exepexted result
-
Did you follow any online instructions? If so, what is the URL?
-
i consulto your documentaiton for heatmap: Heatmap | Grafana documentation
Thanks!