Splunk Search

how to get 2 fields by taking on field

renuka
Path Finder

Hello 
I have table  in my dashboard
      

IDJan_TargetJan_Actual
15060
20N/A


In similar way  for all months
now i need a filter.If i select a january it should show both Jan_Target and Jan_actual
 My query
|inputlookup ABC
|table Id"
Jan - Target" "Jan - Actual"
"Feb - Target" "Feb - Actual"
"Mar - Target" "Mar - Actual"
"Apr - Target" "Apr - Actual"
"May - Target" "May - Actual"
"Jun - Target" "Jun - Actual"
"Jul - Target" "Jul - Actual"...
I tried  using search Jan*  but no results found
 can you please help me with this?

Labels (3)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| table id Jan*
0 Karma

renuka
Path Finder

@ITWhisperer 
Thank you for response
But i want it as filter 
 when i pass filter Jan
it should give me results jan_target and jan_actual
i tried with command |search Jan*
but it is showing no result found

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| untable id month count
| search Jan
| xyseries id month count
0 Karma

renuka
Path Finder

@ITWhisperer 

Thank you for help I took it in static way in filters

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Data Persistence in the OpenTelemetry Collector

This blog post is part of an ongoing series on OpenTelemetry. What happens if the OpenTelemetry collector ...

Introducing Splunk 10.0: Smarter, Faster, and More Powerful Than Ever

Now On Demand Whether you're managing complex deployments or looking to future-proof your data ...

Community Content Calendar, September edition

Welcome to another insightful post from our Community Content Calendar! We're thrilled to continue bringing ...