I’m trying to create a simple heatmap which has the x axis as a column of data, the y axis as a column of data, and the hue as the third column. It’d be similar to this:
https://seaborn.pydata.org/generated/seaborn.heatmap.html
Essentially I’m looking to create a wafer map where the x and y are positions and the hue is a value from one of the columns.
It seems like the heatmap in grafana is time based. Is there a way to override this?
What is version of grafana and datasource?
Please peovide sample text csv data
I’m using the latest version of Grafana, 9.3.2
I’m not sure how to attach a CSV file, so below is an example:
| waferx | wafery | data |
|---|---|---|
| 3 | 3 | -5 |
| 3 | 2 | 2 |
| 3 | 1 | 3 |
| 3 | 0 | -4 |
| 3 | -1 | 0 |
| 3 | -2 | -5 |
| 3 | -3 | 3 |
| 2 | 3 | -1 |
| 2 | 2 | 5 |
| 2 | 1 | -1 |
| 2 | 0 | -3 |
| 2 | -1 | -2 |
| 2 | -2 | 3 |
| 2 | -3 | 3 |
| 1 | 3 | -1 |
| 1 | 2 | 1 |
| 1 | 1 | -2 |
| 1 | 0 | -5 |
| 1 | -1 | 0 |
| 1 | -2 | -1 |
| 1 | -3 | 4 |
| 0 | 3 | 1 |
| 0 | 2 | -4 |
| 0 | 1 | 3 |
| 0 | 0 | -2 |
| 0 | -1 | 1 |
| 0 | -2 | 2 |
| 0 | -3 | -1 |
| -1 | 3 | 1 |
| -1 | 2 | -3 |
| -1 | 1 | 0 |
| -1 | 0 | 3 |
| -1 | -1 | -1 |
| -1 | -2 | -5 |
| -1 | -3 | -2 |
| -2 | 3 | -5 |
| -2 | 2 | 1 |
| -2 | 1 | 0 |
| -2 | 0 | 0 |
| -2 | -1 | -5 |
| -2 | -2 | 2 |
| -2 | -3 | 3 |
| -3 | 3 | 2 |
| -3 | 2 | 3 |
| -3 | 1 | 2 |
| -3 | 0 | 5 |
| -3 | -1 | -3 |
| -3 | -2 | -4 |
| -3 | -3 | 1 |
waferx,wafery,data
3,3,-5
3,2,2
3,1,3
3,0,-4
3,-1,0
3,-2,-5
3,-3,3
2,3,-1
2,2,5
2,1,-1
2,0,-3
2,-1,-2
2,-2,3
2,-3,3
1,3,-1
1,2,1
1,1,-2
1,0,-5
1,-1,0
1,-2,-1
1,-3,4
0,3,1
0,2,-4
0,1,3
0,0,-2
0,-1,1
0,-2,2
0,-3,-1
-1,3,1
-1,2,-3
-1,1,0
-1,0,3
-1,-1,-1
-1,-2,-5
-1,-3,-2
-2,3,-5
-2,2,1
-2,1,0
-2,0,0
-2,-1,-5
-2,-2,2
-2,-3,3
-3,3,2
-3,2,3
-3,1,2
-3,0,5
-3,-1,-3
-3,-2,-4
-3,-3,1
Might want to look into this one
A grafana plugin
Is that something that can integrate into grafana? If not, I already have a way to make heatmaps using seaborn…
It looks like that may be a good solution, but I’m having trouble just getting the heatmap-cartesian example to render.
I copied this code exactly and it’s not working.
The first error I get is “SyntaxError: Identifier ‘data’ has already been declared” at which point I rename “data” to something else. Then it seems to be without error, however, I see nothing. It’s just a black screen.
I installed via the plugin manager so not sure what could be wrong. I’m mainly just looking to get something working.
So I realized if I put “return” in front of option = { that is apparently what’s needed? Where that’s stated I’m not sure.
The next issue I’m facing is how do I aggregate the data such that it’s displayed correctly on the heatmap. This seems awful complex compared to the heatmap functionality found in seaborn or other graphical libraries.
Well for first time use it is complex. But it might not be for you
Requires some js skill
Sure, possibly. So Grafana has no other heatmap solution but through third party plugins then?