Splunk Search

Want to get the how many males and female for coverage_name

gajananh999
Contributor

Dear All,

I have some insurance data and i want to see for which coverage_name how many people male have came and how many people male have come

i have two fields

  1. coverage_name
  2. gender

i want it like

coverage_name male female
xyz 20 40

How can i achive this

Thanks and regards,

Gajanan Hiroji

Tags (2)
0 Karma
1 Solution

kristian_kolb
Ultra Champion

your search here | chart count over coverage_name by gender | ...

/K

View solution in original post

0 Karma

kristian_kolb
Ultra Champion

your search here | chart count over coverage_name by gender | ...

/K

0 Karma

gajananh999
Contributor

Thanks it works.....

0 Karma

gajananh999
Contributor

its normal txt file data with space separated

one event id here

Fisrt_Name=Rohn Last_Name=sinha DOB=1987/1/12 SSN=100002499 coverage_name=vision gender=Male broker=JADE no_of_lives=1

likewise there are 6 coverage_name so i want to find how many male and female for each coverage_name

0 Karma

kristian_kolb
Ultra Champion

What does your data look like (the actual events)?

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 ...