×

Join the Conversation

Without signing in, you're just watching from the sidelines. Sign in or Register to connect, share, and be part of the Splunk Community.
Ask a Question
tarunsinghtoll
Engager
Member since: ‎08-02-2022
‎08-07-2022
Community Statistics
Posts 2
Solutions 1
Karma Given 0
Karma Received 0
Member Since ‎08-02-2022
Activity Feed
View All

Re: Get Sum total of two differnt rows set value

by in Reporting
‎08-03-2022 12:01 AM
‎08-03-2022 12:01 AM
I tried some solution as given below:   | eval type=if(in(recAccuracy, "PREMISE_POSSIBLE","STREET_POSSIBLE","LOCALITY_POSSIBLE"), "NonCleansed", "Cleansed") | stats sum(recAccuracyCount) as Fields by type ... View more

How to get sum total of two different rows set val...

by in Reporting
‎08-02-2022 11:02 PM
‎08-02-2022 11:02 PM
Hi Team, I have following data set of two fields recAccuracy and recAccuracyCount. I want to get the sum total of two rows sets as sum total of  "PREMISE_POSSIBLE","STREET_POSSIBLE" and ,"LOCALITY_POSSIBLE"  as cleansed  103343 and another data set as noncleansed for the rest of field values.   recAccuracy recAccuracyCount LOCALITY_POSSIBLE 64507 PREMISE_POSSIBLE 35493 STREET_DEFINITE 46134 PREMISE_PROBABLE 70789 PREMISE_DEFINITE 363709 LOCALITY_PROBABLE 10586 STREET_POSSIBLE 3343 STREET_PROBABLE 12928   Result : noncleansed  cleansed  103343    504146   I want to draw a pie chart of these two fields. Thanks. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎08-07-2022 08:07 PM