Printing distinct Value of age

[gajananh999]

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

[kristian_kolb]

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]

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

[gajananh999]

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

[Ayn]

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.

[gajananh999]

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

[Ayn]

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