# Creating jmeter transaction comparison table using Runtime Fields

**URL:** <https://discuss.elastic.co/t/creating-jmeter-transaction-comparison-table-using-runtime-fields/370863>\
**Category:** Kibana\
**Tags:** painless, runtime\
**Created:** [November 20, 2024, 11:16pm UTC](https://discuss.elastic.co/t/creating-jmeter-transaction-comparison-table-using-runtime-fields/370863 "2024-11-20T23:16:43Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![2bitlong](https://avatars.discourse-cdn.com/v4/letter/2/ecd19e/32.png) [@2bitlong](https://discuss.elastic.co/u/2bitlong)\
**Post date:** [November 20, 2024, 11:16pm UTC](https://discuss.elastic.co/t/creating-jmeter-transaction-comparison-table-using-runtime-fields/370863/1 "2024-11-20T23:16:43Z")

</div>

I am trying to build a table in lens for the Jmeter test results.  
The table is supposed to have 4 columns:

1. SampleLabel
2. 90th Perc of ResponseTime for Test1
3. 90th Perc of ResponseTime for Test2
4. Difference of above 2 ResponseTime field aggregation

The table looks like this at the moment.

 ![image](https://us1.discourse-cdn.com/elastic/original/3X/6/a/6a1b4df1884b3c9de18ecb3ad0028b784cb1ff99.png)

Each test is uniquely identified by TestId field

I am trying to add the 4th column which shows difference of both aggregated ResponseTime columns but my Runtime Painless script is returning null

```auto
// Retrieve the dynamic 'TestId' values from Kibana control
def testId1 = params.testId1; // First TestId selected
def testId2 = params.testId2; // Second TestId selected

// Initialize variables to store ResponseTime for each TestId
def responseTimeTest1 = null;
def responseTimeTest2 = null;

// Check if 'TestId' matches testId1 or testId2 and capture the ResponseTime
if (doc['TestId.keyword'].size() > 0 && doc['SampleLabel.keyword'].size() > 0) {
    def sampleLabel = doc['SampleLabel.keyword'].value;
    def testId = doc['TestId.keyword'].value;
    def responseTime = doc['ResponseTime'].value;

    // Check if document belongs to TestId1
    if (testId == testId1) {
        responseTimeTest1 = responseTime; // Store ResponseTime for TestId1
    }
    // Check if document belongs to TestId2
    else if (testId == testId2) {
        responseTimeTest2 = responseTime; // Store ResponseTime for TestId2
    }
}

// Calculate the difference if both TestId ResponseTimes are captured
if (responseTimeTest1 != null && responseTimeTest2 != null) {
    emit(responseTimeTest2 - responseTimeTest1) // Return the difference
}

```

What am I missing in the script ? Is there a better way to achieve the difference column ?

A sample document has been provided below. All documents for all tests are sent to a single index : jmetertest in this case

```auto
{
  "AllThreads": [
    2
  ],
  "BodySize": [
    114
  ],
  "Build": [
    "2024Q3"
  ],
  "Build.keyword": [
    "2024Q3"
  ],
  "Bytes": [
    114
  ],
  "ConnectTime": [
    2
  ],
  "ContentType": [
    ""
  ],
  "ContentType.keyword": [
    ""
  ],
  "DataType": [
    "text"
  ],
  "DataType.keyword": [
    "text"
  ],
  "ElapsedTime": [
    1705775400000
  ],
  "ErrorCount": [
    0
  ],
  "FailureMessage": [
    ""
  ],
  "FailureMessage.keyword": [
    ""
  ],
  "GrpThreads": [
    2
  ],
  "IdleTime": [
    0
  ],
  "InjectorHostname": [
    "HM74C24-PC"
  ],
  "InjectorHostname.keyword": [
    "HM74C24-PC"
  ],
  "Latency": [
    21
  ],
  "ResponseCode": [
    "200"
  ],
  "ResponseCode.keyword": [
    "200"
  ],
  "ResponseTime": [
    337
  ],
  "SampleCount": [
    1
  ],
  "SampleEndTime": [
    "2024-11-20T22:26:01.996Z"
  ],
  "SampleLabel": [
    "Transaction_1"
  ],
  "SampleLabel.keyword": [
    "Transaction_1"
  ],
  "SampleStartTime": [
    "2024-11-20T22:26:01.659Z"
  ],
  "SentBytes": [
    0
  ],
  "Success": [
    true
  ],
  "TenantName": [
    "Sony"
  ],
  "TenantName.keyword": [
    "Sony"
  ],
  "TestElement.name": [
    "Thread-6"
  ],
  "TestElement.name.keyword": [
    "Thread-6"
  ],
  "TestId": [
    "2024Q3005"
  ],
  "TestId.keyword": [
    "2024Q3005"
  ],
  "TestStartTime": [
    1732141561567
  ],
  "ThreadName": [
    "Sales_Plan_Yearly 1-1"
  ],
  "ThreadName.keyword": [
    "Sales_Plan_Yearly 1-1"
  ],
  "Timestamp": [
    1732141561659
  ],
  "_id": "nzeuS5MBvp8rWDMIynZJ",
  "_index": "jmetertest",
  "_score": 0
}

```

|