https://community.splunk.com/t5/Getting-Data-In/How-to-calculate-bytes-per-second-for-each-transaction-in-splunk/m-p/536678#M89963 <P>I want to calculate the download speed for each fetched transaction page in bytes per second.<BR />transaction pages consist of login page(that has user login details) and openloan pages consist of documents. I want to have data in bytes per second<BR />I have written the below query that gives&nbsp; me response time in second and i would like to add one more field here that would give me data in bytes per second for&nbsp; fetched&nbsp; transaction pages.<BR /><BR /></P><P>index=app_iis source=*Inetpub* (host=JTCOTWCEMPLW* OR host=JTCOTWCEMPPW* OR host=JTCEP1WPLOSW* OR host=JTCEP1WPPORW*) http_method=GET Uri="*LOSWeb*" Uri="*aspx*" Time_taken!="-"<BR />|eval APClientSource=split(Uri,"/"), APClientName=mvindex(APClientSource,1)<BR />|search APClientSource="Login.aspx" OR APClientSource="OpenLoan.aspx"<BR />|eval "Time_taken(s)"='Time_taken'/1000<BR />|bin _time span=5m |stats avg(Time_taken(s)) as avgURT,distinct_count(C_username) as usercount by host,APClientName,cs_uri_stem,_time<BR />|eval avgURT=round(avgURT,0),StdevURT=round(StdevURT,0)</P> Thu, 21 Jan 2021 13:21:47 GMT Aps17 2021-01-21T13:21:47Z https://community.splunk.com/t5/Getting-Data-In/How-to-calculate-bytes-per-second-for-each-transaction-in-splunk/m-p/536678#M89963 <P>I want to calculate the download speed for each fetched transaction page in bytes per second.<BR />transaction pages consist of login page(that has user login details) and openloan pages consist of documents. I want to have data in bytes per second<BR />I have written the below query that gives&nbsp; me response time in second and i would like to add one more field here that would give me data in bytes per second for&nbsp; fetched&nbsp; transaction pages.<BR /><BR /></P><P>index=app_iis source=*Inetpub* (host=JTCOTWCEMPLW* OR host=JTCOTWCEMPPW* OR host=JTCEP1WPLOSW* OR host=JTCEP1WPPORW*) http_method=GET Uri="*LOSWeb*" Uri="*aspx*" Time_taken!="-"<BR />|eval APClientSource=split(Uri,"/"), APClientName=mvindex(APClientSource,1)<BR />|search APClientSource="Login.aspx" OR APClientSource="OpenLoan.aspx"<BR />|eval "Time_taken(s)"='Time_taken'/1000<BR />|bin _time span=5m |stats avg(Time_taken(s)) as avgURT,distinct_count(C_username) as usercount by host,APClientName,cs_uri_stem,_time<BR />|eval avgURT=round(avgURT,0),StdevURT=round(StdevURT,0)</P> Thu, 21 Jan 2021 13:21:47 GMT https://community.splunk.com/t5/Getting-Data-In/How-to-calculate-bytes-per-second-for-each-transaction-in-splunk/m-p/536678#M89963 Aps17 2021-01-21T13:21:47Z https://community.splunk.com/t5/Getting-Data-In/How-to-calculate-bytes-per-second-for-each-transaction-in-splunk/m-p/536688#M89966 <P>Which fields in your data tell you how much data is downloaded per response? Does this include headers? Are you interested in these?</P> Thu, 21 Jan 2021 14:00:30 GMT https://community.splunk.com/t5/Getting-Data-In/How-to-calculate-bytes-per-second-for-each-transaction-in-splunk/m-p/536688#M89966 ITWhisperer 2021-01-21T14:00:30Z https://community.splunk.com/t5/Getting-Data-In/How-to-calculate-bytes-per-second-for-each-transaction-in-splunk/m-p/536694#M89967 <P class="lia-align-justify">I am trying to calculate it based on bytes_in and bytes_out information<BR /><BR />|eval MB=((bytes_in+bytes_out)/1024)<BR />|eval GB=(MB/1024)<BR /><BR /><BR />will this query give me the download speed for each response.</P> Thu, 21 Jan 2021 14:30:27 GMT https://community.splunk.com/t5/Getting-Data-In/How-to-calculate-bytes-per-second-for-each-transaction-in-splunk/m-p/536694#M89967 Aps17 2021-01-21T14:30:27Z