topic Re: select rows having similar values in table in Dashboards & Visualizations

select rows having similar values in table

vikas_baranwal — Mon, 18 Mar 2019 05:11:29 GMT

Hello Splunkers,

I need your help to create SPL for below where I am facing issue.

In table, any status is having more than than one entry with different timings before moving to another status. It is not with every Status. I want to collect record for only one row for any Status (with min Updated column value).

e.g. status "Ready For Dev" is moved to "In Dev" then "In QA" then "In Dev" then "In QA' then again "Ready For Dev" Status and finally "In Dev" status. In this I want to collect for all the movements.

Thanks for your help in advance!

Re: select rows having similar values in table

deepashri_123 — Mon, 18 Mar 2019 05:36:47 GMT

Hey@vikas_baranwal,

Are you trying to have each status once instead of repeating multiple times?
Can you try using dedup Status?

Let me know if this helps!!

Re: select rows having similar values in table

HiroshiSatoh — Mon, 18 Mar 2019 06:18:53 GMT

Try this!

(your search)
|dedup key,Status consecutive=true

Re: select rows having similar values in table

vikas_baranwal — Tue, 19 Mar 2019 04:31:09 GMT

Hi @HiroshiSatoh ,

I am thankful to you as you helped me a lot by providing me exact solution. I feel honored that I am part of such a great a community with high level of knowledge people and all helping hands here.

Thanks once again!

Re: select rows having similar values in table

vikas_baranwal — Tue, 19 Mar 2019 04:33:29 GMT

Hi @deepashri ,

Thanks for your reply and help. I was using dedup already but I was missing a command which was advised by @HiroshiSatoh and that worked really well.

Thanks once again!