Sorry i forget to write very important things I have many events with the same key for example: 10/4/23 1:23:03.000 PM {"key":"27.09.2023","value_sum":35476232.82,"value_cnt":2338} Show...
See more...
Sorry i forget to write very important things I have many events with the same key for example: 10/4/23 1:23:03.000 PM {"key":"27.09.2023","value_sum":35476232.82,"value_cnt":2338} Show syntax highlighted host = app-damu.hcb.kz source = /opt/splunkforwarder/etc/apps/XXX/pays_7d.sh sourcetype = damu_pays_7d 10/4/23 1:24:03.000 PM {"key":"27.09.2023","value_sum":35476232.82,"value_cnt":2338} Show syntax highlighted host = app-damu.hcb.kz source = /opt/splunkforwarder/etc/apps/XXX/pays_7d.sh sourcetype = damu_pays_7d 10/4/23 1:25:03.000 PM {"key":"27.09.2023","value_sum":35476232.82,"value_cnt":2338} Show syntax highlighted host = app-damu.hcb.kz source = /opt/splunkforwarder/etc/apps/XXX/pays_7d.sh sourcetype = damu_pays_7d ... and for other KEY for example key":"29.09.2023" many events in the result i want to see only one unique row for KEY I try to search index=hcg_app_damu_prod sourcetype="damu_pays_7d" | spath input=json | table _time, key ,value_sum, value_cnt | stats latest(key), latest(value_sum) ,latest(value_cnt) but it give me just only one row.