I have a statistics table that only contains one row in my dashboard, but the table has more than 20 fields which are hard to view by end-users. I would like to find out if there is a workaround to layout the field name and its content vertically.
For instance, the current layout:
field_1 field_2 field_3 field_4
------- ------- --------- -------
a b c d
the new layout:
field_1: a
field_2: b
field_3: c
field_4: d
Or this:
field_1: a field_3: c
field_2: b field_4: d
Any suggestions?
Thanks.
Try one of these
base search returning 1 row | untable dummy fields values | fields - dummy
*OR*
base search returning 1 row | transpose | rename column AS fields "row 1" as values
|transpose
will lay them out vertically for you.
http://docs.splunk.com/Documentation/Splunk/6.5.0/SearchReference/Transpose
you'll probably want to use header_field
and int=0
options.