I am new to Grafana, I am using elastic search DB … i am trying with below scenario unfortunately i am not able to do it… Can you please help me to do the needfull
Consider am having table with logs based on timestamp so i need to transform table A to Table B
Table A
| @Timestamp | Data 1 | Data 2 | Count |
|---|---|---|---|
| 10:00 | a1 | b1 | 10 |
| 10:01 | a1 | b2 | 14 |
| 10:02 | a2 | b1 | 10 |
| 10:03 | a2 | b2 | 14 |
| 10:04 | a3 | b1 | 10 |
| 10:05 | a3 | b2 | 10 |
Table B
| Total count b1 | Total count b2 | |
|---|---|---|
| a1 | 10 | 14 |
| a2 | 10 | 14 |
| a3 | 10 | 10 |
I want this to display like
|Channel. Keyword|Info|Warning |Critical|
|SEAT | |20| |20| |20|
|IRIS| |20| |20| |20|