Splunk Search

I have a table created for a report, but how do I delete the first two rows of the chart since they contain no data?

minkyuk
Explorer

Hello,

I have a table I created for a report.
However, I'm trying to find a way to get rid of the first two rows of the chart, since they contain no information.

It seems like an issue that could be resolved with a quick touch, but I would appreciate any suggestions from you.

Jack

Tags (4)
0 Karma

somesoni2
Revered Legend

What is the search you're using to populate the table and when you say first 2 rows doesn't contain information, are all columns for those 2 rows empty/null?

0 Karma

jnussbaum_splun
Splunk Employee
Splunk Employee

Typically, you can append a search at the end of your search, to filter out results that don't contain a value such as: index=_internal | table user | search user!="" this will eliminate events from a table where the value for field user is "" or null. Please share your sanitized search string if you need further assistance.

0 Karma
Get Updates on the Splunk Community!

Observe and Secure All Apps with Splunk

  Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

Splunk Decoded: Business Transactions vs Business IQ

It’s the morning of Black Friday, and your e-commerce site is handling 10x normal traffic. Orders are flowing, ...

Fastest way to demo Observability

I’ve been having a lot of fun learning about Kubernetes and Observability. I set myself an interesting ...