Transpose a table in Grafana

Grafana Time Series Panel
1

I have the table below
|Field|Total|
|—|—|
|UNICAST Total|1179|
|MULTICAST Total|7107|
|UNICAST Failed|107|
|MULTICAST Failed|754|

How do I transpose it using transform or other to the below?

|Field|UNICAST Total|MULTICAST Total|UNICAST Failed|MULTICAST Failed|
|---|---|---|---|---|
|Total|1179|7107|107|754|
2

Hi @hatman,

What datasource are you using, and what version of grafana?

Can you include any screenshots of your table?

3

image
image895×690 18.5 KB

Hi @mattabrams pic attached of the table i have.
data source is elastic search.
version is 7.5.7.
tks, appreciate your reply.

1 Like
4

ok, great, thanks.

Can I ask: why are you trying to transform this data? In other words, what are you trying to achieve and why?

I ask because Grafana’s data frame model is columnar oriented, and was originally designed to visualize time-series data.

1 Like
5

image
image1153×177 12 KB

to answer your question on what and why, I wanted to create a table like the transposed in the pic so I could easily create a success rate in the columns.

Maybe I am not using grafana as it was meant. tks I will look into the data frames.

6

not necessarily. Grafana can support non time-series data like this, to varying degrees. What are your elastic queries, out of interest?

7

I’d also take a look at all these example dashboards built using Elastic queries.

1 Like
8 
eventType:DeviceRequestResponseEvent
AND (_exists_:payload.cattle.name)
AND farmId:*
AND payload.deviceRequestResponseEvent.payloadType:COMMAND_REQUEST_TYPE

example query, the query is just count of certain criteria. the above would be query A and then I would have another queryB …query N and then just calculate on them accordingly using transforms in grafana.

9

Ok. I would also suggest checking out the new Bar Chart that is getting released with Grafana 8. It is designed to handle non-time series data:
https://play.grafana.org/d/YI95GyqMz/1-new-features-in-v8-0?orgId=1&viewPanel=73&editPanel=73

10

I notice that now we have a ‘Transpose’ transformation since Transformations: Add 'transpose' transform by jmdane · Pull Request #88963 · grafana/grafana · GitHub (2024-8).