Dear Wiki user, You have subscribed to a wiki page or wiki category on "Jakarta-jmeter Wiki" for change notification.
The "LogAnalysis" page has been changed by Brenda Bell. http://wiki.apache.org/jakarta-jmeter/LogAnalysis?action=diff&rev1=58&rev2=59 -------------------------------------------------- 2. Convert Timestamps to Excel Format - Once the data is in Excel, I convert the timestamp column from Jmeter's Unix timestamp format (base year 1970) to the Excel format (base year 1900) using this following formula. This formula is applied to the entire timestamp column. + Once the data is in Excel, I convert the timestamp column from Jmeter's Unix timestamp format (base year 1970) to the Excel format (base year 1900 or 1904 depending on the Excel version and underlying OS) using this following formula. This formula is applied to the entire timestamp column. - ''For GMT time'' + ''For GMT time on Windows'' {{{ - =(x/1000+((365*70+17)*86400))/86400 + =((x/1000)/86400)+(DATEVALUE("1-1-1970") - DATEVALUE("1-1-1900")) }}} + ''For GMT time on Mac OS X'' + {{{ + =((x/1000)/86400)+(DATEVALUE("1-1-1970") - DATEVALUE("1-1-1904")) + }}} + - ''For local time'' (replace t with your current offset from GMT) + ''For local time on Windows'' (replace t with your current offset from GMT) {{{ - =(x/1000+(t * 3600)+((365*70+17)*86400))/86400 + =(((x/1000)-(4*3600))/86400)+(DATEVALUE("1-1-1970") - DATEVALUE("1-1-1900")) }}} + ''For local time on Mac OS X'' (replace t with your current offset from GMT) + {{{ + =(((x/1000)-(4*3600))/86400)+(DATEVALUE("1-1-1970") - DATEVALUE("1-1-1904")) + }}} 3. Now sort rows on the operation name (i.e. JMeter sampler name) --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
