Generate a table
To generate a table, write a search that includes a transforming command. From the Search page, run the search and select the Statistics tab to view and format the table.
You can use the table
command in a search to specify the fields that the table includes or to change table column order.
Search examples
- Transforming search
This search uses thechart
transforming command.index = _internal | chart avg(bytes) over sourcetype
- Transforming search with the table command
This search generates a table withaction
,host
, andcount
columns.index = _internal | stats count by action, host
To change the columns that appear in the table or to change column order, add the
table
command to this search. For example, add| table host count
to generate a table with only thehost
andcount
columns.index = _internal | stats count by action, host | table host count
Table sparklines
Sparklines show data patterns or trends in a results set. To generate a table sparkline, usestats
or chart
with the sparkline
function in a search.
Sparkline width is determined by default data binning. You can adjust data binning as a parameter of the sparkline
command.
For more information, see Add Sparklines to your search results in the Search Manual.
Table visualization overview | Format table visualizations |
This documentation applies to the following versions of Splunk Cloud Platform™: 9.2.2406 (latest FedRAMP release), 8.2.2201, 8.2.2203, 8.2.2112, 8.2.2202, 9.0.2205, 9.0.2208, 9.0.2209, 9.0.2303, 9.0.2305, 9.1.2308, 9.1.2312, 9.2.2403
Feedback submitted, thanks!