https://community.splunk.com/t5/Splunk-Search/How-to-sum-the-count-of-three-users/m-p/328033#M165491 <P>Hi<BR /> Can you please accept this question to mark as close?</P> Fri, 27 Oct 2017 13:18:54 GMT kamlesh_vaghela 2017-10-27T13:18:54Z https://community.splunk.com/t5/Splunk-Search/How-to-sum-the-count-of-three-users/m-p/328030#M165488 <P>Hi,</P> <P>in my scenario i have a lot of users for example: user1, user2, user3... and i want to count their logins to a server and create a pie chart. I have the problem that there are some users which have the same name but a different notation for example user1, USER1 and USer1. How can i sum the counts of these 3, allocate it to user1 and create the pie chart?</P> <P>Thx for your help!</P> Fri, 27 Oct 2017 09:04:00 GMT https://community.splunk.com/t5/Splunk-Search/How-to-sum-the-count-of-three-users/m-p/328030#M165488 reschal 2017-10-27T09:04:00Z https://community.splunk.com/t5/Splunk-Search/How-to-sum-the-count-of-three-users/m-p/328031#M165489 <P>Hi reschal,</P> <P>you can lower the user names.</P> <P>Can you please try this?</P> <P>YOUR_SEARCH | eval user_field =lower(user_field) | stats count by user_field</P> <P>just add extra eval before stats command.</P> <P>thanks</P> Tue, 29 Sep 2020 16:30:18 GMT https://community.splunk.com/t5/Splunk-Search/How-to-sum-the-count-of-three-users/m-p/328031#M165489 kamlesh_vaghela 2020-09-29T16:30:18Z https://community.splunk.com/t5/Splunk-Search/How-to-sum-the-count-of-three-users/m-p/328032#M165490 <P>Thanks, it works <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> Fri, 27 Oct 2017 13:07:28 GMT https://community.splunk.com/t5/Splunk-Search/How-to-sum-the-count-of-three-users/m-p/328032#M165490 reschal 2017-10-27T13:07:28Z https://community.splunk.com/t5/Splunk-Search/How-to-sum-the-count-of-three-users/m-p/328033#M165491 <P>Hi<BR /> Can you please accept this question to mark as close?</P> Fri, 27 Oct 2017 13:18:54 GMT https://community.splunk.com/t5/Splunk-Search/How-to-sum-the-count-of-three-users/m-p/328033#M165491 kamlesh_vaghela 2017-10-27T13:18:54Z