topic Re: How can we exclude weekends from the count of the number of days for the age of a ticket? in Splunk Search https://community.splunk.com/t5/Splunk-Search/How-can-we-exclude-weekends-from-the-count-of-the-number-of-days/m-p/231321#M68610 <P>Try this</P> <PRE><CODE>... | eval end=_time | eval start=end-(aging*86400)| eval range=mvrange(start, end, 86400) | convert ctime(range) timeformat="%+" | eval BusinessDays=mvcount(mvfilter(NOT match(range,"(Sun|Sat).*"))) </CODE></PRE> Mon, 27 Jun 2016 21:49:20 GMT sundareshr 2016-06-27T21:49:20Z How can we exclude weekends from the count of the number of days for the age of a ticket? https://community.splunk.com/t5/Splunk-Search/How-can-we-exclude-weekends-from-the-count-of-the-number-of-days/m-p/231320#M68609 <P>Hi , </P> <P>We have a field called <STRONG>AGING</STRONG> which tells how many days a ticket exists.</P> <P>In order to get the accurate age, we want to subtract weekends from the AGING field.</P> <P>For example: If aging has value of 30 days, we need to exclude all Saturdays and Sundays from these 30 days and need to output the results.</P> <P>Can you please help?</P> <P>Thanks.</P> Mon, 27 Jun 2016 21:20:58 GMT https://community.splunk.com/t5/Splunk-Search/How-can-we-exclude-weekends-from-the-count-of-the-number-of-days/m-p/231320#M68609 splunker9999 2016-06-27T21:20:58Z Re: How can we exclude weekends from the count of the number of days for the age of a ticket? https://community.splunk.com/t5/Splunk-Search/How-can-we-exclude-weekends-from-the-count-of-the-number-of-days/m-p/231321#M68610 <P>Try this</P> <PRE><CODE>... | eval end=_time | eval start=end-(aging*86400)| eval range=mvrange(start, end, 86400) | convert ctime(range) timeformat="%+" | eval BusinessDays=mvcount(mvfilter(NOT match(range,"(Sun|Sat).*"))) </CODE></PRE> Mon, 27 Jun 2016 21:49:20 GMT https://community.splunk.com/t5/Splunk-Search/How-can-we-exclude-weekends-from-the-count-of-the-number-of-days/m-p/231321#M68610 sundareshr 2016-06-27T21:49:20Z Re: How can we exclude weekends from the count of the number of days for the age of a ticket? https://community.splunk.com/t5/Splunk-Search/How-can-we-exclude-weekends-from-the-count-of-the-number-of-days/m-p/231322#M68611 <P>Brilliant; I learned <CODE>mvrange</CODE> today!</P> Tue, 28 Jun 2016 14:36:16 GMT https://community.splunk.com/t5/Splunk-Search/How-can-we-exclude-weekends-from-the-count-of-the-number-of-days/m-p/231322#M68611 woodcock 2016-06-28T14:36:16Z