Splunk Enterprise

How to combine two search queries where one query has to use a filter option?

Path Finder

I have a search query as

sourcetype="file.csv"|eval Created_Date = mvindex(split(Created," "),0)| stats count as Issues_created by Created_Date

which gives me output as 


Similarly another search query as 

sourcetype="file.csv" Resolved|eval Created_Date = mvindex(split(Created," "),0)|stats count as Issues_Resolved by Created_Date

basically i am filtering out events which have status as Resolved and creating  events

which gives me output as 


I want to combine these two queris to give me bar chart which will display the statistics as

Created_Date ---- Issues_created ---- Issues_Resolved



Kindly help me with this..

Labels (1)
Tags (3)
0 Karma
Get Updates on the Splunk Community!

Splunk Security Content for Threat Detection & Response, Q1 Roundup

Join Principal Threat Researcher, Michael Haag, as he walks through:An introduction to the Splunk Threat ...

Splunk Life | Happy Pride Month!

Happy Pride Month, Splunk Community! 🌈 In the United States, as well as many countries around the ...

SplunkTrust | Where Are They Now - Michael Uschmann

The Background Five years ago, Splunk published several videos showcasing members of the SplunkTrust to share ...