Dashboards & Visualizations

How to add empty row after each unique value in a field?

dzyfer
Path Finder

My data currently looks like this:

DateName
2022-11-01ABC
2022-11-01DEF
2022-11-01GHI
2022-11-02JKL
2022-11-02MNO
2022-11-03PQR
2022-11-03STU
2022-11-03VWX
2022-11-03YZ1

 

I would like it to look like this:

DateName
2022-11-01ABC
2022-11-01DEF
2022-11-01GHI
  
2022-11-02JKL
2022-11-02MNO
  
2022-11-03PQR
2022-11-03STU
2022-11-03VWX
2022-11-03YZ1

 

I need an empty row to be inserted whenever the Date differs from the value before it.

Labels (2)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
| appendpipe 
    [| stats count by Date]
| fillnull value=0 count
| sort 0 Date count
| eval Date=if(count>0,null(),Date)
| fields - count

View solution in original post

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| appendpipe 
    [| stats count by Date]
| fillnull value=0 count
| sort 0 Date count
| eval Date=if(count>0,null(),Date)
| fields - count
0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @dzyfer,

could you share your search?

by default isn't possible, but it's possible to find a workaround.

Ciao.

Giuseppe

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...