Merge 2 queries based on month

[ninadbhaskarwar]

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

[somesoni2 · Accepted solution]

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]

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