https://community.splunk.com/t5/Splunk-Search/How-to-compare-data-between-two-business-weeks-using-time-chart/m-p/646430#M223745 <P>Hello Team,</P> <P>Could you please suggest on how to create an overlapping graph which compares this week's data and previous week's data excluding weekends.<BR /><BR />Any help is very much appreciated.</P> <P>My base search is very simple.<BR />index=my index source=/.log '#search string#'<BR />| time chart span=1h count(_raw) by host</P> <P>&nbsp;</P> Fri, 09 Jun 2023 12:21:47 GMT Devi13 2023-06-09T12:21:47Z https://community.splunk.com/t5/Splunk-Search/How-to-compare-data-between-two-business-weeks-using-time-chart/m-p/646430#M223745 <P>Hello Team,</P> <P>Could you please suggest on how to create an overlapping graph which compares this week's data and previous week's data excluding weekends.<BR /><BR />Any help is very much appreciated.</P> <P>My base search is very simple.<BR />index=my index source=/.log '#search string#'<BR />| time chart span=1h count(_raw) by host</P> <P>&nbsp;</P> Fri, 09 Jun 2023 12:21:47 GMT https://community.splunk.com/t5/Splunk-Search/How-to-compare-data-between-two-business-weeks-using-time-chart/m-p/646430#M223745 Devi13 2023-06-09T12:21:47Z https://community.splunk.com/t5/Splunk-Search/How-to-compare-data-between-two-business-weeks-using-time-chart/m-p/646502#M223769 <LI-CODE lang="markup">| eval day= strftime(_time,"%w") | where day &gt; 0 AND day &lt; 6 | timechart span=1h count by host | timewrap 1w align=end</LI-CODE> Sat, 10 Jun 2023 11:10:20 GMT https://community.splunk.com/t5/Splunk-Search/How-to-compare-data-between-two-business-weeks-using-time-chart/m-p/646502#M223769 ITWhisperer 2023-06-10T11:10:20Z https://community.splunk.com/t5/Splunk-Search/How-to-compare-data-between-two-business-weeks-using-time-chart/m-p/646504#M223771 <P>Hello,&nbsp;</P><P>Thank you so so much , it works like a charm.</P><P>But I still get weekends in the results, is there a way to exclude them?</P> Sat, 10 Jun 2023 13:07:37 GMT https://community.splunk.com/t5/Splunk-Search/How-to-compare-data-between-two-business-weeks-using-time-chart/m-p/646504#M223771 Devi13 2023-06-10T13:07:37Z https://community.splunk.com/t5/Splunk-Search/How-to-compare-data-between-two-business-weeks-using-time-chart/m-p/646505#M223772 <P>Repeat the first two lines - timechart adds the times back in, but the good thing about it is that if there are any hours without any events, you still get zeroes for those hours. If you use chart or stats instead, the times without events don't appear at all.</P> Sat, 10 Jun 2023 13:49:39 GMT https://community.splunk.com/t5/Splunk-Search/How-to-compare-data-between-two-business-weeks-using-time-chart/m-p/646505#M223772 ITWhisperer 2023-06-10T13:49:39Z https://community.splunk.com/t5/Splunk-Search/How-to-compare-data-between-two-business-weeks-using-time-chart/m-p/646506#M223773 <P>Greatt! Thank you so muchh for your help <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>&nbsp;</P> Sat, 10 Jun 2023 15:42:45 GMT https://community.splunk.com/t5/Splunk-Search/How-to-compare-data-between-two-business-weeks-using-time-chart/m-p/646506#M223773 Devi13 2023-06-10T15:42:45Z