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
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
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
Suggestion - Change your month format to 2017-01, so that they will sort correctly.