Splunk Search
Highlighted

Merge 2 queries based on month

Path Finder

One query give me data as
Month Closed-Issues
Jan 100
Feb 110
Mar 105

Second Query Give me data as

Month New-Issues
Jan 200
Feb 150
Mar 50

I need to join these two queries to get the result as

Month New Issue Closed-Issues
Jan 200 100
Feb 150 110
Mar 50 105

What should be query to get such result

0 Karma
Highlighted

Re: Merge 2 queries based on month

SplunkTrust
SplunkTrust

There may be a better solution to this but we need to see your current searches to figure that one out. Without seeing those, my suggestion would be like this

your search1 to get Month Closed-Issues
| append [Second Query to get Month New-Issues]
| stats values(*) as * by Month

View solution in original post

Highlighted

Re: Merge 2 queries based on month

SplunkTrust
SplunkTrust

Suggestion - Change your month format to 2017-01, so that they will sort correctly.

0 Karma