Splunk Search

Merge 2 queries based on month

ninadbhaskarwar
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
1 Solution

somesoni2
Revered Legend

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

somesoni2
Revered Legend

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

DalJeanis
Legend

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

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...