Reporting

Printing distinct Value of age

gajananh999
Contributor

Dear All,

Search=index="inforce_analytix"|eval Age=2013-Subscriber_Birth_Year |bin Age span=5 | eval Total Covered Amount=(coverage_Amount1+coverage_Amount1)| stats sum(Total Covered Amount),sum(NumberOfCoveredPersons),sum(Policy_Premium) by Age,Product_Name

result =

20-25 children plan 24 35 46

20-25 furure plan 23 34 34

20-25 retirement plan 45 45 76


26-30 children plan 24 35 46

25-30 furure plan 23 34 34

25-30 retirement plan 45 45 76

there age is repeating. I want to show age as one time only.for the first line only

Thanks
Gajanan Hiroji

Tags (1)
0 Karma

kristian_kolb
Ultra Champion

You can do it like so;

index="inforce_analytix" 
| eval Age=2013-Subscriber_Birth_Year 
| bin Age span=5 
| eval Total_Covered_Amount=(coverage_Amount1+coverage_Amount1)
| stats sum(Total_Covered_Amount) as CA ,sum(NumberOfCoveredPersons) as CP ,sum(Policy_Premium) as PP by Age,Product_Name 
| eval theStuff= Product_Name . " " . CA . " " . CP . " " . PP
| stats list(theStuff) by Age

From this point on, all but the Age is just a concatenated string, so further processing will be hard.

/k

Ayn
Legend

I don't know of a way to format the output like that, sorry.

0 Karma

gajananh999
Contributor

see my output should be like this

20-25 children plan 24 35 46
furure plan 23 34 34
retirement plan 45 45 76

26-30 children plan 24 35 46
furure plan 23 34 34
retirement plan 45 45 76

0 Karma

Ayn
Legend

Well you can't have it both ways - either you split by product_name and age, and that will, well, result in that you get stats split by product_name and age, or you split in some other way. I'm not sure what your desired output is.

0 Karma

gajananh999
Contributor

I want to split by product Name but i want to print that age only at once.

0 Karma

Ayn
Legend

...so you don't want to split it by Product_Name?

0 Karma
Get Updates on the Splunk Community!

Your Guide to SPL2 at .conf24!

So, you’re headed to .conf24? You’re in for a good time. Las Vegas weather is just *chef’s kiss* beautiful in ...

Get ready to show some Splunk Certification swagger at .conf24!

Dive into the deep end of data by earning a Splunk Certification at .conf24. We're enticing you again this ...

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Now On-Demand Join us to learn more about how you can leverage Service Level Objectives (SLOs) and the new ...