https://community.splunk.com/t5/Dashboards-Visualizations/Single-graph-from-Multi-search-index/m-p/343774#M39064 <P>Hi, I need a chart from multiple source and multiple search terms.</P> <P>search 1: index="SessionController" host = "abc01*" | stats distinct_count(session) by date_hour<BR /> search 2: index="CompleteSale" host = "xyz*" | stats distinct_count(order) by date_hour</P> <P>I want a line graph that will show number of requests (i.e. count of Session's) and the orders per hour.</P> <P>Thanks in advance.</P> Tue, 29 Sep 2020 15:10:34 GMT BharathKN 2020-09-29T15:10:34Z https://community.splunk.com/t5/Dashboards-Visualizations/Single-graph-from-Multi-search-index/m-p/343774#M39064 <P>Hi, I need a chart from multiple source and multiple search terms.</P> <P>search 1: index="SessionController" host = "abc01*" | stats distinct_count(session) by date_hour<BR /> search 2: index="CompleteSale" host = "xyz*" | stats distinct_count(order) by date_hour</P> <P>I want a line graph that will show number of requests (i.e. count of Session's) and the orders per hour.</P> <P>Thanks in advance.</P> Tue, 29 Sep 2020 15:10:34 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Single-graph-from-Multi-search-index/m-p/343774#M39064 BharathKN 2020-09-29T15:10:34Z https://community.splunk.com/t5/Dashboards-Visualizations/Single-graph-from-Multi-search-index/m-p/343775#M39065 <P>If the session and order fields are exclusively used on the source where you want to count them, you can simply combine your searches:</P> <PRE><CODE>(index="SessionController" host = "abc01*") OR (index="CompleteSale" host = "xyz*") | stats distinct_count(session) distinct_count(order) by date_hour </CODE></PRE> Tue, 01 Aug 2017 08:03:44 GMT https://community.splunk.com/t5/Dashboards-Visualizations/Single-graph-from-Multi-search-index/m-p/343775#M39065 knielsen 2017-08-01T08:03:44Z