Splunk Enterprise

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

priyaramki16
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 

priyaramki16_0-1592372188607.png

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 

priyaramki16_1-1592372379128.png

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

Created_Date ---- Issues_created ---- Issues_Resolved

01-01-202088
01-02-202090
01-03-202061

 

Kindly help me with this..

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

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...