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!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...