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!

Devesh Logendran, Splunk, and the Singapore Cyber Conquest

At this year’s Splunk University, I had the privilege of chatting with Devesh Logendran, one of the winners in ...

There's No Place Like Chrome and the Splunk Platform

WATCH NOW!Malware. Risky Extensions. Data Exfiltration. End-users are increasingly reliant on browsers to ...

Customer Experience | Join the Customer Advisory Board!

Are you ready to take your Splunk journey to the next level? 🚀 We invite you to join our elite squad ...