首页 > 技术文章 > JMeter学习-020-JMeter 监听器之【聚合报告】错误率、吞吐量、传输速率实例计算

fengpingfan 2016-06-01 22:06 原文

上文 对聚合报告的结果字段进行了概要的讲述释义,同时对吞吐量、传输速率、分位数等进行了详细的阐述,此文针对上文中描述的吞吐量及传输速率的计算进行详细的实例计算演示。

多不闲述,直入主题!

 

实际操作步骤如下所示:

1、获取聚合报告结果文件和聚合报告

在聚合报告页面中添加聚合报告结果保存文件,添加方法如下图所示:

  

1464075524271.00,85.00,001-聚合报告-8040,200,OK,聚合报告 1-2,text,false,343.00,10,10,85.00,0,1464075524356
1464075524270.00,256.00,001-聚合报告-8040,200,OK,聚合报告 1-4,text,true,340.00,10,10,256.00,0,1464075524526
1464075524268.00,276.00,001-聚合报告-8040,200,OK,聚合报告 1-7,text,true,340.00,10,10,275.00,1,1464075524544
1464075524271.00,314.00,001-聚合报告-8040,200,OK,聚合报告 1-5,text,true,340.00,10,10,314.00,0,1464075524585
1464075524269.00,337.00,001-聚合报告-8040,200,OK,聚合报告 1-3,text,true,340.00,10,10,336.00,1,1464075524606
1464075524265.00,349.00,001-聚合报告-8040,200,OK,聚合报告 1-9,text,true,340.00,10,10,348.00,1,1464075524614
1464075524268.00,362.00,001-聚合报告-8040,200,OK,聚合报告 1-6,text,true,340.00,10,10,362.00,0,1464075524630
1464075524268.00,364.00,001-聚合报告-8040,200,OK,聚合报告 1-1,text,false,343.00,10,10,139.00,225,1464075524632
1464075524272.00,531.00,001-聚合报告-8040,200,OK,聚合报告 1-8,text,true,340.00,10,10,303.00,228,1464075524803
1464075524271.00,582.00,001-聚合报告-8040,200,OK,聚合报告 1-10,text,true,340.00,10,10,361.00,221,1464075524853
1464075524867.00,131.00,003-聚合报告-8050,200,OK,聚合报告 1-3,text,false,343.00,10,10,131.00,0,1464075524998
1464075524861.00,172.00,003-聚合报告-8050,200,OK,聚合报告 1-7,text,false,349.00,10,10,171.00,1,1464075525033
1464075524866.00,299.00,003-聚合报告-8050,200,OK,聚合报告 1-8,text,true,427.00,10,10,299.00,0,1464075525165
1464075524865.00,308.00,003-聚合报告-8050,200,OK,聚合报告 1-6,text,true,427.00,10,10,308.00,0,1464075525173
1464075524861.00,314.00,003-聚合报告-8050,200,OK,聚合报告 1-5,text,true,427.00,10,10,314.00,0,1464075525175
1464075524864.00,324.00,003-聚合报告-8050,200,OK,聚合报告 1-1,text,true,427.00,10,10,324.00,0,1464075525188
1464075524863.00,328.00,003-聚合报告-8050,200,OK,聚合报告 1-2,text,true,427.00,10,10,328.00,0,1464075525191
1464075524862.00,362.00,003-聚合报告-8050,200,OK,聚合报告 1-10,text,true,427.00,10,10,362.00,0,1464075525224
1464075524863.00,371.00,003-聚合报告-8050,200,OK,聚合报告 1-9,text,true,427.00,10,10,371.00,0,1464075525234
1464075524868.00,368.00,003-聚合报告-8050,200,OK,聚合报告 1-4,text,true,427.00,10,10,368.00,0,1464075525236
1464075525242.00,127.00,001-聚合报告-8040,200,OK,聚合报告 1-1,text,false,343.00,10,10,127.00,0,1464075525369
1464075525241.00,133.00,001-聚合报告-8040,200,OK,聚合报告 1-3,text,false,343.00,10,10,133.00,0,1464075525374
1464075525241.00,146.00,001-聚合报告-8040,200,OK,聚合报告 1-7,text,true,340.00,10,10,146.00,0,1464075525387
1464075525242.00,168.00,001-聚合报告-8040,200,OK,聚合报告 1-2,text,false,343.00,10,10,168.00,0,1464075525410
1464075525243.00,325.00,001-聚合报告-8040,200,OK,聚合报告 1-9,text,true,340.00,10,10,324.00,1,1464075525568
1464075525243.00,326.00,001-聚合报告-8040,200,OK,聚合报告 1-10,text,true,340.00,10,10,326.00,0,1464075525569
1464075525242.00,358.00,001-聚合报告-8040,200,OK,聚合报告 1-5,text,true,340.00,10,10,358.00,0,1464075525600
1464075525241.00,374.00,001-聚合报告-8040,200,OK,聚合报告 1-4,text,true,340.00,10,10,374.00,0,1464075525615
1464075525242.00,373.00,001-聚合报告-8040,200,OK,聚合报告 1-8,text,true,340.00,10,10,373.00,0,1464075525615
1464075525242.00,573.00,001-聚合报告-8040,200,OK,聚合报告 1-6,text,true,340.00,10,10,346.00,227,1464075525815
1464075525826.00,61.00,003-聚合报告-8050,200,OK,聚合报告 1-7,text,false,343.00,10,10,60.00,1,1464075525887
1464075525828.00,69.00,003-聚合报告-8050,200,OK,聚合报告 1-10,text,false,343.00,10,10,69.00,0,1464075525897
1464075525830.00,106.00,003-聚合报告-8050,200,OK,聚合报告 1-8,text,false,343.00,10,10,106.00,0,1464075525936
1464075525826.00,185.00,003-聚合报告-8050,200,OK,聚合报告 1-3,text,true,427.00,10,10,185.00,0,1464075526011
1464075525828.00,209.00,003-聚合报告-8050,200,OK,聚合报告 1-9,text,true,427.00,10,10,209.00,0,1464075526037
1464075525827.00,222.00,003-聚合报告-8050,200,OK,聚合报告 1-6,text,true,427.00,10,10,221.00,1,1464075526049
1464075525826.00,274.00,003-聚合报告-8050,200,OK,聚合报告 1-1,text,true,340.00,10,10,274.00,0,1464075526100
1464075525829.00,283.00,003-聚合报告-8050,200,OK,聚合报告 1-4,text,true,340.00,10,10,283.00,0,1464075526112
1464075525829.00,479.00,003-聚合报告-8050,200,OK,聚合报告 1-5,text,true,427.00,10,10,479.00,0,1464075526308
1464075525828.00,494.00,003-聚合报告-8050,200,OK,聚合报告 1-2,text,true,340.00,10,10,494.00,0,1464075526322
1464075526325.00,48.00,001-聚合报告-8040,200,OK,聚合报告 1-10,text,false,343.00,10,10,48.00,0,1464075526373
1464075526327.00,214.00,001-聚合报告-8040,200,OK,聚合报告 1-4,text,true,340.00,10,10,214.00,0,1464075526541
1464075526328.00,215.00,001-聚合报告-8040,200,OK,聚合报告 1-5,text,true,340.00,10,10,215.00,0,1464075526543
1464075526325.00,229.00,001-聚合报告-8040,200,OK,聚合报告 1-2,text,true,340.00,10,10,229.00,0,1464075526554
1464075526325.00,241.00,001-聚合报告-8040,200,OK,聚合报告 1-9,text,true,340.00,10,10,241.00,0,1464075526566
1464075526327.00,277.00,001-聚合报告-8040,200,OK,聚合报告 1-1,text,false,343.00,10,10,45.00,232,1464075526604
1464075526326.00,298.00,001-聚合报告-8040,200,OK,聚合报告 1-6,text,true,340.00,10,10,298.00,0,1464075526624
1464075526329.00,296.00,001-聚合报告-8040,200,OK,聚合报告 1-8,text,true,340.00,10,10,296.00,0,1464075526625
1464075526325.00,458.00,001-聚合报告-8040,200,OK,聚合报告 1-7,text,true,340.00,10,10,232.00,226,1464075526783
1464075526325.00,468.00,001-聚合报告-8040,200,OK,聚合报告 1-3,text,true,340.00,10,10,245.00,223,1464075526793
1464075526797.00,66.00,003-聚合报告-8050,200,OK,聚合报告 1-4,text,false,343.00,10,10,66.00,0,1464075526863
1464075526801.00,82.00,003-聚合报告-8050,200,OK,聚合报告 1-8,text,false,349.00,10,10,82.00,0,1464075526883
1464075526797.00,98.00,003-聚合报告-8050,200,OK,聚合报告 1-5,text,false,343.00,10,10,98.00,0,1464075526895
1464075526798.00,358.00,003-聚合报告-8050,200,OK,聚合报告 1-9,text,true,427.00,10,10,358.00,0,1464075527156
1464075526800.00,359.00,003-聚合报告-8050,200,OK,聚合报告 1-3,text,true,427.00,10,10,359.00,0,1464075527159
1464075526799.00,377.00,003-聚合报告-8050,200,OK,聚合报告 1-1,text,true,427.00,10,10,377.00,0,1464075527176
1464075526800.00,382.00,003-聚合报告-8050,200,OK,聚合报告 1-6,text,true,427.00,10,10,381.00,1,1464075527182
1464075526797.00,393.00,003-聚合报告-8050,200,OK,聚合报告 1-10,text,true,427.00,10,10,393.00,0,1464075527190
1464075526797.00,398.00,003-聚合报告-8050,200,OK,聚合报告 1-2,text,true,427.00,10,10,398.00,0,1464075527195
1464075526801.00,407.00,003-聚合报告-8050,200,OK,聚合报告 1-7,text,true,427.00,10,10,407.00,0,1464075527208
1464075527212.00,71.00,001-聚合报告-8040,200,OK,聚合报告 1-8,text,false,343.00,10,10,71.00,0,1464075527283
1464075527218.00,65.00,001-聚合报告-8040,200,OK,聚合报告 1-10,text,false,343.00,10,10,65.00,0,1464075527283
1464075527213.00,110.00,001-聚合报告-8040,200,OK,聚合报告 1-5,text,false,343.00,10,10,110.00,0,1464075527323
1464075527219.00,195.00,001-聚合报告-8040,200,OK,聚合报告 1-3,text,true,340.00,10,10,195.00,0,1464075527414
1464075527218.00,305.00,001-聚合报告-8040,200,OK,聚合报告 1-2,text,true,340.00,10,10,305.00,0,1464075527523
1464075527217.00,319.00,001-聚合报告-8040,200,OK,聚合报告 1-1,text,true,340.00,10,10,319.00,0,1464075527536
1464075527211.00,338.00,001-聚合报告-8040,200,OK,聚合报告 1-7,text,true,340.00,10,10,338.00,0,1464075527549
1464075527217.00,529.00,001-聚合报告-8040,200,OK,聚合报告 1-6,text,true,340.00,10,10,305.00,224,1464075527746
1464075527211.00,545.00,001-聚合报告-8040,200,OK,聚合报告 1-4,text,true,340.00,10,10,324.00,221,1464075527756
1464075527216.00,553.00,001-聚合报告-8040,200,OK,聚合报告 1-9,text,true,340.00,10,10,332.00,221,1464075527769
1464075527772.00,168.00,003-聚合报告-8050,200,OK,聚合报告 1-1,text,true,427.00,10,10,168.00,0,1464075527940
1464075527771.00,289.00,003-聚合报告-8050,200,OK,聚合报告 1-9,text,false,343.00,10,10,289.00,0,1464075528060
1464075527772.00,295.00,003-聚合报告-8050,200,OK,聚合报告 1-2,text,false,349.00,10,10,294.00,1,1464075528067
1464075527772.00,458.00,003-聚合报告-8050,200,OK,聚合报告 1-5,text,true,427.00,10,10,458.00,0,1464075528230
1464075527772.00,470.00,003-聚合报告-8050,200,OK,聚合报告 1-3,text,true,427.00,10,10,470.00,0,1464075528242
1464075527773.00,744.00,003-聚合报告-8050,200,OK,聚合报告 1-6,text,true,427.00,10,10,743.00,1,1464075528517
1464075527771.00,746.00,003-聚合报告-8050,200,OK,聚合报告 1-10,text,true,427.00,10,10,746.00,0,1464075528517
1464075527774.00,760.00,003-聚合报告-8050,200,OK,聚合报告 1-4,text,true,427.00,10,10,760.00,0,1464075528534
1464075527773.00,767.00,003-聚合报告-8050,200,OK,聚合报告 1-7,text,true,427.00,10,10,767.00,0,1464075528540
1464075527771.00,793.00,003-聚合报告-8050,200,OK,聚合报告 1-8,text,true,427.00,10,10,793.00,0,1464075528564
1464075528566.00,184.00,001-聚合报告-8040,200,OK,聚合报告 1-2,text,false,343.00,10,10,183.00,1,1464075528750
1464075528571.00,181.00,001-聚合报告-8040,200,OK,聚合报告 1-4,text,false,343.00,10,10,181.00,0,1464075528752
1464075528571.00,202.00,001-聚合报告-8040,200,OK,聚合报告 1-7,text,false,343.00,10,10,202.00,0,1464075528773
1464075528566.00,274.00,001-聚合报告-8040,200,OK,聚合报告 1-1,text,true,340.00,10,10,274.00,0,1464075528840
1464075528566.00,286.00,001-聚合报告-8040,200,OK,聚合报告 1-8,text,true,340.00,10,10,286.00,0,1464075528852
1464075528568.00,294.00,001-聚合报告-8040,200,OK,聚合报告 1-9,text,true,340.00,10,10,294.00,0,1464075528862
1464075528570.00,305.00,001-聚合报告-8040,200,OK,聚合报告 1-10,text,true,340.00,10,10,305.00,0,1464075528875
1464075528578.00,305.00,001-聚合报告-8040,200,OK,聚合报告 1-5,text,true,340.00,10,10,304.00,1,1464075528883
1464075528569.00,320.00,001-聚合报告-8040,200,OK,聚合报告 1-3,text,true,340.00,10,10,320.00,0,1464075528889
1464075528569.00,553.00,001-聚合报告-8040,200,OK,聚合报告 1-6,text,true,340.00,10,10,328.00,225,1464075529122
1464075529126.00,71.00,003-聚合报告-8050,200,OK,聚合报告 1-3,text,false,343.00,10,10,70.00,1,1464075529197
1464075529124.00,168.00,003-聚合报告-8050,200,OK,聚合报告 1-6,text,true,427.00,10,10,168.00,0,1464075529292
1464075529127.00,265.00,003-聚合报告-8050,200,OK,聚合报告 1-8,text,false,343.00,10,10,265.00,0,1464075529392
1464075529126.00,271.00,003-聚合报告-8050,200,OK,聚合报告 1-5,text,false,343.00,10,10,270.00,1,1464075529397
1464075529125.00,484.00,003-聚合报告-8050,200,OK,聚合报告 1-9,text,true,427.00,10,10,484.00,0,1464075529609
1464075529125.00,498.00,003-聚合报告-8050,200,OK,聚合报告 1-4,text,true,427.00,10,10,498.00,0,1464075529623
1464075529124.00,513.00,003-聚合报告-8050,200,OK,聚合报告 1-2,text,true,427.00,10,10,513.00,0,1464075529637
1464075529124.00,525.00,003-聚合报告-8050,200,OK,聚合报告 1-7,text,true,427.00,10,10,525.00,0,1464075529649
1464075529124.00,559.00,003-聚合报告-8050,200,OK,聚合报告 1-1,text,true,427.00,10,10,558.00,1,1464075529683
1464075529126.00,569.00,003-聚合报告-8050,200,OK,聚合报告 1-10,text,true,427.00,10,10,569.00,0,1464075529695
1464075529699.00,260.00,001-聚合报告-8040,200,OK,聚合报告 1-1,text,false,343.00,10,10,260.00,0,1464075529959
1464075529698.00,263.00,001-聚合报告-8040,200,OK,聚合报告 1-5,text,false,343.00,10,10,263.00,0,1464075529961
1464075529697.00,382.00,001-聚合报告-8040,200,OK,聚合报告 1-3,text,true,340.00,10,10,382.00,0,1464075530079
1464075529698.00,393.00,001-聚合报告-8040,200,OK,聚合报告 1-9,text,true,340.00,10,10,393.00,0,1464075530091
1464075529697.00,410.00,001-聚合报告-8040,200,OK,聚合报告 1-10,text,true,340.00,10,10,410.00,0,1464075530107
1464075529698.00,453.00,001-聚合报告-8040,200,OK,聚合报告 1-6,text,true,340.00,10,10,453.00,0,1464075530151
1464075529698.00,472.00,001-聚合报告-8040,200,OK,聚合报告 1-2,text,true,340.00,10,10,472.00,0,1464075530170
1464075529699.00,472.00,001-聚合报告-8040,200,OK,聚合报告 1-8,text,true,340.00,10,10,472.00,0,1464075530171
1464075529699.00,647.00,001-聚合报告-8040,200,OK,聚合报告 1-4,text,true,340.00,10,10,432.00,215,1464075530346
1464075529699.00,683.00,001-聚合报告-8040,200,OK,聚合报告 1-7,text,true,340.00,10,10,459.00,224,1464075530382
1464075530385.00,92.00,003-聚合报告-8050,200,OK,聚合报告 1-10,text,false,343.00,10,10,92.00,0,1464075530477
1464075530387.00,97.00,003-聚合报告-8050,200,OK,聚合报告 1-9,text,false,349.00,10,10,97.00,0,1464075530484
1464075530385.00,189.00,003-聚合报告-8050,200,OK,聚合报告 1-6,text,true,427.00,10,10,189.00,0,1464075530574
1464075530384.00,203.00,003-聚合报告-8050,200,OK,聚合报告 1-5,text,true,427.00,10,10,203.00,0,1464075530587
1464075530386.00,215.00,003-聚合报告-8050,200,OK,聚合报告 1-2,text,true,427.00,10,10,215.00,0,1464075530601
1464075530384.00,230.00,003-聚合报告-8050,200,OK,聚合报告 1-7,text,true,427.00,10,10,230.00,0,1464075530614
1464075530385.00,233.00,003-聚合报告-8050,200,OK,聚合报告 1-1,text,true,427.00,10,10,233.00,0,1464075530618
1464075530386.00,241.00,003-聚合报告-8050,200,OK,聚合报告 1-8,text,true,427.00,10,10,241.00,0,1464075530627
1464075530386.00,253.00,003-聚合报告-8050,200,OK,聚合报告 1-4,text,true,427.00,10,10,253.00,0,1464075530639
1464075530384.00,267.00,003-聚合报告-8050,200,OK,聚合报告 1-3,text,true,427.00,10,10,267.00,0,1464075530651
1464075530654.00,50.00,001-聚合报告-8040,200,OK,聚合报告 1-5,text,false,343.00,10,10,50.00,0,1464075530704
1464075530654.00,75.00,001-聚合报告-8040,200,OK,聚合报告 1-2,text,false,343.00,10,10,74.00,1,1464075530729
1464075530653.00,151.00,001-聚合报告-8040,200,OK,聚合报告 1-9,text,true,340.00,10,10,150.00,1,1464075530804
1464075530656.00,155.00,001-聚合报告-8040,200,OK,聚合报告 1-4,text,true,340.00,10,10,155.00,0,1464075530811
1464075530653.00,171.00,001-聚合报告-8040,200,OK,聚合报告 1-6,text,true,340.00,10,10,171.00,0,1464075530824
1464075530655.00,176.00,001-聚合报告-8040,200,OK,聚合报告 1-7,text,true,340.00,10,10,176.00,0,1464075530831
1464075530655.00,188.00,001-聚合报告-8040,200,OK,聚合报告 1-8,text,true,340.00,10,10,188.00,0,1464075530843
1464075530655.00,189.00,001-聚合报告-8040,200,OK,聚合报告 1-1,text,true,340.00,10,10,189.00,0,1464075530844
1464075530653.00,202.00,001-聚合报告-8040,200,OK,聚合报告 1-10,text,true,340.00,10,10,202.00,0,1464075530855
1464075530655.00,261.00,001-聚合报告-8040,200,OK,聚合报告 1-3,text,false,343.00,10,10,43.00,218,1464075530916
1464075530921.00,62.00,003-聚合报告-8050,200,OK,聚合报告 1-7,text,false,343.00,10,10,62.00,0,1464075530983
1464075530921.00,97.00,003-聚合报告-8050,200,OK,聚合报告 1-10,text,false,343.00,10,10,97.00,0,1464075531018
1464075530920.00,188.00,003-聚合报告-8050,200,OK,聚合报告 1-6,text,true,427.00,10,10,188.00,0,1464075531108
1464075530921.00,397.00,003-聚合报告-8050,200,OK,聚合报告 1-1,text,true,427.00,10,10,397.00,0,1464075531318
1464075530920.00,402.00,003-聚合报告-8050,200,OK,聚合报告 1-8,text,true,427.00,10,10,402.00,0,1464075531322
1464075530919.00,420.00,003-聚合报告-8050,200,OK,聚合报告 1-9,text,true,427.00,10,10,420.00,0,1464075531339
1464075530919.00,427.00,003-聚合报告-8050,200,OK,聚合报告 1-3,text,true,427.00,10,10,427.00,0,1464075531346
1464075530919.00,434.00,003-聚合报告-8050,200,OK,聚合报告 1-4,text,true,427.00,10,10,434.00,0,1464075531353
1464075530919.00,440.00,003-聚合报告-8050,200,OK,聚合报告 1-2,text,true,427.00,10,10,440.00,0,1464075531359
1464075530920.00,446.00,003-聚合报告-8050,200,OK,聚合报告 1-5,text,true,427.00,10,10,446.00,0,1464075531366
1464075531369.00,39.00,001-聚合报告-8040,200,OK,聚合报告 1-5,text,false,343.00,10,10,39.00,0,1464075531408
1464075531370.00,51.00,001-聚合报告-8040,200,OK,聚合报告 1-8,text,false,343.00,10,10,51.00,0,1464075531421
1464075531371.00,182.00,001-聚合报告-8040,200,OK,聚合报告 1-3,text,true,340.00,10,10,182.00,0,1464075531553
1464075531369.00,184.00,001-聚合报告-8040,200,OK,聚合报告 1-7,text,true,340.00,10,10,184.00,0,1464075531553
1464075531371.00,193.00,001-聚合报告-8040,200,OK,聚合报告 1-2,text,true,340.00,10,10,193.00,0,1464075531564
1464075531370.00,218.00,001-聚合报告-8040,200,OK,聚合报告 1-1,text,true,340.00,10,10,218.00,0,1464075531588
1464075531370.00,217.00,001-聚合报告-8040,200,OK,聚合报告 1-6,text,true,340.00,10,10,217.00,0,1464075531587
1464075531370.00,231.00,001-聚合报告-8040,200,OK,聚合报告 1-10,text,true,340.00,10,10,231.00,0,1464075531601
1464075531371.00,232.00,001-聚合报告-8040,200,OK,聚合报告 1-4,text,true,340.00,10,10,232.00,0,1464075531603
1464075531371.00,244.00,001-聚合报告-8040,200,OK,聚合报告 1-9,text,true,340.00,10,10,244.00,0,1464075531615
1464075531616.00,60.00,003-聚合报告-8050,200,OK,聚合报告 1-9,text,false,343.00,10,10,60.00,0,1464075531676
1464075531616.00,90.00,003-聚合报告-8050,200,OK,聚合报告 1-3,text,false,343.00,10,10,90.00,0,1464075531706
1464075531616.00,110.00,003-聚合报告-8050,200,OK,聚合报告 1-7,text,false,349.00,10,10,110.00,0,1464075531726
1464075531616.00,200.00,003-聚合报告-8050,200,OK,聚合报告 1-8,text,true,427.00,10,10,200.00,0,1464075531816
1464075531617.00,209.00,003-聚合报告-8050,200,OK,聚合报告 1-10,text,true,427.00,10,10,209.00,0,1464075531826
1464075531617.00,211.00,003-聚合报告-8050,200,OK,聚合报告 1-2,text,true,427.00,10,10,211.00,0,1464075531828
1464075531617.00,507.00,003-聚合报告-8050,200,OK,聚合报告 1-6,text,true,427.00,10,10,507.00,0,1464075532124
1464075531617.00,508.00,003-聚合报告-8050,200,OK,聚合报告 1-1,text,true,427.00,10,10,508.00,0,1464075532125
1464075531616.00,527.00,003-聚合报告-8050,200,OK,聚合报告 1-5,text,true,427.00,10,10,527.00,0,1464075532143
1464075531617.00,538.00,003-聚合报告-8050,200,OK,聚合报告 1-4,text,true,427.00,10,10,538.00,0,1464075532155
1464075532159.00,44.00,001-聚合报告-8040,200,OK,聚合报告 1-2,text,false,343.00,10,10,44.00,0,1464075532203
1464075532157.00,93.00,001-聚合报告-8040,200,OK,聚合报告 1-9,text,false,343.00,10,10,93.00,0,1464075532250
1464075532159.00,158.00,001-聚合报告-8040,200,OK,聚合报告 1-8,text,true,340.00,10,10,158.00,0,1464075532317
1464075532161.00,168.00,001-聚合报告-8040,200,OK,聚合报告 1-1,text,true,340.00,10,10,168.00,0,1464075532329
1464075532161.00,169.00,001-聚合报告-8040,200,OK,聚合报告 1-5,text,true,340.00,10,10,169.00,0,1464075532330
1464075532159.00,186.00,001-聚合报告-8040,200,OK,聚合报告 1-10,text,true,340.00,10,10,185.00,1,1464075532345
1464075532158.00,193.00,001-聚合报告-8040,200,OK,聚合报告 1-3,text,true,340.00,10,10,193.00,0,1464075532351
1464075532157.00,199.00,001-聚合报告-8040,200,OK,聚合报告 1-4,text,true,340.00,10,10,199.00,0,1464075532356
1464075532160.00,203.00,001-聚合报告-8040,200,OK,聚合报告 1-6,text,true,340.00,10,10,203.00,0,1464075532363
1464075532158.00,380.00,001-聚合报告-8040,200,OK,聚合报告 1-7,text,true,340.00,10,10,159.00,221,1464075532538
1464075532541.00,55.00,003-聚合报告-8050,200,OK,聚合报告 1-3,text,false,343.00,10,10,54.00,1,1464075532596
1464075532542.00,60.00,003-聚合报告-8050,200,OK,聚合报告 1-6,text,false,349.00,10,10,60.00,0,1464075532602
1464075532542.00,170.00,003-聚合报告-8050,200,OK,聚合报告 1-4,text,true,427.00,10,10,170.00,0,1464075532712
1464075532540.00,172.00,003-聚合报告-8050,200,OK,聚合报告 1-9,text,true,427.00,10,10,172.00,0,1464075532712
1464075532541.00,184.00,003-聚合报告-8050,200,OK,聚合报告 1-10,text,true,427.00,10,10,183.00,1,1464075532725
1464075532541.00,186.00,003-聚合报告-8050,200,OK,聚合报告 1-5,text,true,427.00,10,10,186.00,0,1464075532727
1464075532540.00,491.00,003-聚合报告-8050,200,OK,聚合报告 1-8,text,true,427.00,10,10,491.00,0,1464075533031
1464075532540.00,507.00,003-聚合报告-8050,200,OK,聚合报告 1-7,text,true,427.00,10,10,507.00,0,1464075533047
1464075532540.00,545.00,003-聚合报告-8050,200,OK,聚合报告 1-1,text,true,340.00,10,10,545.00,0,1464075533085
1464075532540.00,828.00,003-聚合报告-8050,200,OK,聚合报告 1-2,text,true,427.00,10,10,828.00,0,1464075533368
1464075533370.00,42.00,001-聚合报告-8040,200,OK,聚合报告 1-3,text,false,343.00,10,10,42.00,0,1464075533412
1464075533373.00,52.00,001-聚合报告-8040,200,OK,聚合报告 1-5,text,false,343.00,10,10,52.00,0,1464075533425
1464075533373.00,71.00,001-聚合报告-8040,200,OK,聚合报告 1-8,text,false,343.00,10,10,71.00,0,1464075533444
1464075533374.00,151.00,001-聚合报告-8040,200,OK,聚合报告 1-1,text,true,340.00,10,10,151.00,0,1464075533525
1464075533372.00,167.00,001-聚合报告-8040,200,OK,聚合报告 1-10,text,true,340.00,10,10,167.00,0,1464075533539
1464075533370.00,170.00,001-聚合报告-8040,200,OK,聚合报告 1-2,text,true,340.00,10,10,170.00,0,1464075533540
1464075533371.00,182.00,001-聚合报告-8040,200,OK,聚合报告 1-4,text,true,340.00,10,10,182.00,0,1464075533553
1464075533370.00,183.00,001-聚合报告-8040,200,OK,聚合报告 1-6,text,true,340.00,10,10,183.00,0,1464075533553
1464075533373.00,371.00,001-聚合报告-8040,200,OK,聚合报告 1-7,text,true,340.00,10,10,148.00,223,1464075533744
1464075533372.00,419.00,001-聚合报告-8040,200,OK,聚合报告 1-9,text,true,340.00,10,10,197.00,222,1464075533791
1464075533797.00,56.00,003-聚合报告-8050,200,OK,聚合报告 1-6,text,false,343.00,10,10,56.00,0,1464075533853
1464075533798.00,62.00,003-聚合报告-8050,200,OK,聚合报告 1-7,text,false,343.00,9,9,62.00,0,1464075533860
1464075533796.00,82.00,003-聚合报告-8050,200,OK,聚合报告 1-4,text,false,343.00,8,8,82.00,0,1464075533878
1464075533793.00,180.00,003-聚合报告-8050,200,OK,聚合报告 1-3,text,true,427.00,7,7,180.00,0,1464075533973
1464075533793.00,180.00,003-聚合报告-8050,200,OK,聚合报告 1-9,text,true,427.00,7,7,180.00,0,1464075533973
1464075533795.00,196.00,003-聚合报告-8050,200,OK,聚合报告 1-10,text,true,427.00,5,5,195.00,1,1464075533991
1464075533794.00,216.00,003-聚合报告-8050,200,OK,聚合报告 1-5,text,true,427.00,4,4,216.00,0,1464075534010
1464075533793.00,233.00,003-聚合报告-8050,200,OK,聚合报告 1-8,text,true,427.00,3,3,233.00,0,1464075534026
1464075533794.00,428.00,003-聚合报告-8050,200,OK,聚合报告 1-1,text,true,427.00,2,2,428.00,0,1464075534222
1464075533796.00,428.00,003-聚合报告-8050,200,OK,聚合报告 1-2,text,true,427.00,2,2,428.00,0,1464075534224
聚合报告结果数据

 

 

2、将聚合报告及其结果数据存放至 Excel 文件如下图所示:

  

PS:将结果数据存放到 Excel 时,我将 false 值替换为了 -1,方便后续数据处理。

 

3、基础数据计算步骤:

  3.1、响应延迟差值、结束时间:

    在 M16 单元格输入公式:=B16-L16

    在 N16 单元格输入公式:=A16+B16

  3.2、样本数量、样本数据量总和:

    在 B8 单元格输入公式:=COUNTIF(C16:C277,A8)

    在 F8 单元格输入公式:=SUMIF(C15:C214,A8,I15:I276)

  3.3、样本最小起始时间、样本最大终止时间、样本总耗时:

    在 C8 单元格输入公式:=MIN(IF(C16:C215=A8,A16:A215)),然后同时按住 ctrl + shift + enter 结束输入

    在 D8 单元格输入公式:=MAX(IF(C16:C215=A8,N16:N215)),然后同时按住 ctrl + shift + enter 结束输入

    在 E8 单元格输入公式:=D8-C8

  3.4、错误数:

    在 I8 单元格输入公式:=COUNTIFS(C16:C215,A8,H16:H215,-1)

  PS:其他相应的单元格填充公式即可。

 

4、计算 吞吐量、错误率、传输速率

  4.1、吞吐量:单位时间(1s)内处理的请求个数。计算公式为: 吞吐量 = 样本数 * 1000 / (样本结束时间 - 样本开始时间)

    在 G8 单元格输入公式: = B8 * 1000 / E8

  4.2、错误率:失败请求的占比。计算公式为: 错误数 * 100 / 样本数量

    在 I8 单元格输入公式: = I8 * 100 / B8

  4.3、传输速率:单位时间内传输的数据量,单位 KB/sec。计算公式为: 传输率 = (样本总数据量 / 1024) / (总耗时 / 1000)

    在 H8 单元格输入公式: =F8*1000/(1024*E8)

  PS:其他相应的单元格填充公式即可。

 

5、最终结算结果截图如下所示:

  

 

至此,此文顺利完结,希望此文能够给初学 JMeter 的您一份参考。若您发现此文有不足之处或错误,敬请留言告知,非常感谢!

最后,非常感谢亲的驻足,希望此文能对亲有所帮助。热烈欢迎亲一起探讨,共同进步。非常感谢! ^_^

 

 

推荐阅读