Hey everyone!
I am using Grafana v11.1.0
I am new to Grafana and have a few visualizations wherein I want to create a pivot table. It should be in the following format:
This is just an example of how I want the data to look like.
I am using my input as Elasticsearch (Which is being fed into by PostgreSQL). I am unable to make any changes to the base data (For this use-case).
I delved into using the “grouping to matrix” transformation but am unable to achieve the expected output. Is there any other way I can leverage Grafana transformations to achieve this final visualization in the form of a pivot table? Any help would be greatly appreciated! 
what does the source data look like?
Hi,
Sorry for not including this earlier. The source looks something like this:
I have taken some pseudo values for representation purpose in this case (They don’t represent the actual values that I have on my end).
Basically I want to merge the rows that have the same value into a single cell and display the result as a pivot table. Does that make sense?
Thank you in advance!
I am not sure that is a pivot in the purest sense. but that said look at using Business Text plugin and some html and css to get what you want
Thank you so much for that!
This looks promising, although I am having some issue with passing variable names instead of the “Cell 1” and “Cell 2” placeholders. Can you kindly guide me with how to pass variables from my actual Elasticsearch data.
Input:
Expected output:
Thanks once again!
guidance from the plugin docu itself, try out what it shows in this docu and then when stuck post back
