Splunk Search

need to delete column from the result generated after timechart command

venky1544
Builder

i have a timechart query which is giving me the below result 

i want to exclude the columns with Zero like 02gdysjska2 ,2shbhsiskdf9

Not these names can change and or not fixed 

_time003hfhdfs89huk02gdysjska213hdgsgtsjwk21dhsysbaisps2shbhsiskdf95hsusbsosv
2024-01-23T09:45:00.000+0000000000
2024-01-23T09:50:00.000+0000000000
2024-01-23T09:55:00.000+00000001796100
2024-01-23T10:00:00.000+0000001183000
2024-01-23T10:05:00.000+00000000055
2024-01-23T10:10:00.000+0000000000
2024-01-23T10:15:00.000+0000000000
2024-01-23T10:20:00.000+0000000000
2024-01-23T10:25:00.000+0000428000000
2024-01-23T10:30:00.000+0000000000
2024-01-23T10:35:00.000+0000000000
Labels (1)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
| untable _time name value
| where value != 0
| xyseries _time name value
| fillnull value=0

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust
| untable _time name value
| where value != 0
| xyseries _time name value
| fillnull value=0
Get Updates on the Splunk Community!

Mastering Data Pipelines: Unlocking Value with Splunk

 In today's AI-driven world, organizations must balance the challenges of managing the explosion of data with ...

The Latest Cisco Integrations With Splunk Platform!

Join us for an exciting tech talk where we’ll explore the latest integrations in Cisco + Splunk! We’ve ...

AI Adoption Hub Launch | Curated Resources to Get Started with AI in Splunk

Hey Splunk Practitioners and AI Enthusiasts! It’s no secret (or surprise) that AI is at the forefront of ...