https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466253#M131293 <P>@sudeep5689, I am converting my comment as Answer. Please accept this if it helps.</P> Fri, 29 May 2020 10:09:22 GMT 493669 2020-05-29T10:09:22Z https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466242#M131282 <P>Hi i am having two search queries with a difference of only the time range. I want to show the results of both the queries in a single dashboard. I s there a way to do it</P> Mon, 08 Jun 2020 19:28:29 GMT https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466242#M131282 sudeep5689 2020-06-08T19:28:29Z https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466243#M131283 <P>You can create two separate panel and run each panel query on separate timerange in single dashboard.</P> Thu, 28 May 2020 08:19:39 GMT https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466243#M131283 493669 2020-05-28T08:19:39Z https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466244#M131284 <P>i want the results in same panel</P> Thu, 28 May 2020 08:33:56 GMT https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466244#M131284 sudeep5689 2020-05-28T08:33:56Z https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466245#M131285 <P>you can use earliest and latest within your query to run on separate timerange like below example-</P> <PRE><CODE>index=abc earliest=-1d@d latest=now() |&lt;your calculation&gt;|append [search index=abc earliest=-5d@d latest=now()] </CODE></PRE> Thu, 28 May 2020 08:37:59 GMT https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466245#M131285 493669 2020-05-28T08:37:59Z https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466246#M131286 <P>Ok<BR /> Can we show the results as separate rows using this combined search. i mean month wise</P> Thu, 28 May 2020 08:39:58 GMT https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466246#M131286 sudeep5689 2020-05-28T08:39:58Z https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466247#M131287 <P>like count of events i need to show on a monthly basis</P> Thu, 28 May 2020 08:40:54 GMT https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466247#M131287 sudeep5689 2020-05-28T08:40:54Z https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466248#M131288 <P>you can show count on a monthly basis using single query . Is there any other reason for running two query?</P> Thu, 28 May 2020 09:23:17 GMT https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466248#M131288 493669 2020-05-28T09:23:17Z https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466249#M131289 <P>yes need to show comparison across months for count basis.</P> Thu, 28 May 2020 09:33:47 GMT https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466249#M131289 sudeep5689 2020-05-28T09:33:47Z https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466250#M131290 <P>in a single query using append right or anyother way you are hinting at</P> Thu, 28 May 2020 09:39:46 GMT https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466250#M131290 sudeep5689 2020-05-28T09:39:46Z https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466251#M131291 <P>Ideally splunk has created two fields - <CODE>date_month</CODE> and <CODE>date_year</CODE>. If these fields are present then you can use below stats command-</P> <PRE><CODE>...| stats count by date_month, date_year </CODE></PRE> Thu, 28 May 2020 10:01:39 GMT https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466251#M131291 493669 2020-05-28T10:01:39Z https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466252#M131292 <P>The solution provided worked out</P> Fri, 29 May 2020 10:06:33 GMT https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466252#M131292 sudeep5689 2020-05-29T10:06:33Z https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466253#M131293 <P>@sudeep5689, I am converting my comment as Answer. Please accept this if it helps.</P> Fri, 29 May 2020 10:09:22 GMT https://community.splunk.com/t5/Splunk-Search/How-to-club-and-display-the-results-of-two-queries-in-a-single/m-p/466253#M131293 493669 2020-05-29T10:09:22Z