topic Re: is it possible to transpose the values of the table in the dashboard? in Dashboarding

Transpose the values of the table in the Dashboard

Arunkumarbnp — Thu, 04 Dec 2025 12:57:16 GMT

is it possible to transpose the values of the table in the dashboard?

Re: is it possible to transpose the values of the table in the dashboard?

marco_irmer — Tue, 13 May 2025 21:17:08 GMT

Behind the scenes, each table row is a separate 'record'. In order to transpose, you'd have to likely perform some specific transformations in DQL. Happy to try and help you with that if you want to share your current DQL.

Re: is it possible to transpose the values of the table in the dashboard?

Arunkumarbnp — Wed, 14 May 2025 10:32:08 GMT

@marco_irmer thanks for your reply

I'm using browser monitoring metrics to be added as a table for a browser monitoring.

Table output is

Re: is it possible to transpose the values of the table in the dashboard?

kumaravel — Thu, 15 May 2025 13:25:13 GMT

Hello,

I also had a similar usecase to transpose the table to have a better comparison for 2 records and was able to achieve it with some workaround.

Default working in DQL -

Below is a sample code of the table visualisation

data record(content="{\"host\":\"host1\",\"cpu\":\"67\",\"memory\":\"80%\"}"), record(content="{\"host\":\"host2\",\"cpu\":\"33\",\"memory\":\"44%\"}") | parse content,"json:jsonContent" | fields host = jsonContent[host], cpu = jsonContent[cpu], memory = jsonContent[memory]

For example, I have taken cpu and memory fields but I had around 10 fields of comparison and wanted to transpose the table to have a better view of the data.

Workaround in DQL:

data record(content="{\"host\":\"host1\",\"cpu\":\"67\",\"memory\":\"80%\"}") | parse content,"json:host1Content" | fields host1Content, state = "true" | fieldsAdd temp = lookup([ data record(content="{\"host\":\"host2\",\"cpu\":\"33\",\"memory\":\"44%\"}") | parse content,"json:contentJson" | fields contentJson, state = "true" ], sourceField:state, lookupField:state) | fields host1Content, host2Content = temp[contentJson] | fields array= array( concat("cpu::",host1Content[cpu],"::",host2Content[cpu]), concat("memory::",host1Content[memory],"::",host2Content[memory]) ) | expand array | parse array,"LD:Host'::'LD:Host1'::'LD:Host2" | fields Host, Host1, Host2

NOTE: The above workaround example works with only 2 records, so the dql fetch should be limited to return 1 record in the sample

I hope it can be used for your requirement as well

Re: is it possible to transpose the values of the table in the dashboard?

Arunkumarbnp — Fri, 16 May 2025 05:30:07 GMT

@kumaravel Thanks for your reply.

How can it be done on dashboard classic

Re: is it possible to transpose the values of the table in the dashboard?

kumaravel — Fri, 16 May 2025 08:45:11 GMT

I have not tried this use case in classic dashboard. Will share if I find a solution.