Splunk Search

how to merge similar events of a table using javascript?

sajjanshetty15
Loves-to-Learn

hello all,
I am trying to merge the rows of table into one value as all of them are same, but i dont want to use dedup as there are other columns which are having different values.
i have tried using stats values() and list() but it is not giving the required output as i want to drill down from the result table to another table.
here is the example table..
Metrics Month Raw Sla SLA
Incidence performance P1 18-Apr 100 100
Incidence performance P1 18-May 100 100
Incidence performance P1 18-Jun 44.44 100
Incidence performance P1 18-Jul 100 100
Incidence performance P1 18-Aug 88.8 100
Incidence performance P1 18-Sep 90 100
Incidence performance P1 18-Oct 56 100
Incidence performance P1 18-Nov 89 100
Incidence performance P1 18-Jan 100 100
Incidence performance P1 18-Feb 100 100

required output
Metrics Month Raw Sla SLA
Incidence performance P1 18-Apr 100 100
18-May 100 100
18-Jun 44.44 100
18-Jul 100 100....so on
I want to achieve this using Javascript...is possible?if so please help...
Thanks and regards

Tags (1)
0 Karma
Get Updates on the Splunk Community!

Data Management Digest – December 2025

Welcome to the December edition of Data Management Digest! As we continue our journey of data innovation, the ...

Index This | What is broken 80% of the time by February?

December 2025 Edition   Hayyy Splunk Education Enthusiasts and the Eternally Curious!    We’re back with this ...

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...