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!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...