https://community.splunk.com/t5/Splunk-Search/max-successfull-VPN-users-per-day-by-monthly/m-p/505011#M141050 What do you mean by "by day by month"? Are you looking for 90 numbers for the days and 3 other numbers for the last 3 months?<BR />Can you share your current query? Thu, 18 Jun 2020 15:36:36 GMT richgalloway 2020-06-18T15:36:36Z https://community.splunk.com/t5/Splunk-Search/max-successfull-VPN-users-per-day-by-monthly/m-p/505005#M141047 <P>Initially I have query with successful VPN user logings.(usernames) Now I want to get the max(high) nubmber of users per day per month for 3 months.</P><P>so initially how to extract the date and month and then count the users by day by moth.</P> Thu, 18 Jun 2020 15:06:02 GMT https://community.splunk.com/t5/Splunk-Search/max-successfull-VPN-users-per-day-by-monthly/m-p/505005#M141047 riqbal47010 2020-06-18T15:06:02Z https://community.splunk.com/t5/Splunk-Search/max-successfull-VPN-users-per-day-by-monthly/m-p/505011#M141050 What do you mean by "by day by month"? Are you looking for 90 numbers for the days and 3 other numbers for the last 3 months?<BR />Can you share your current query? Thu, 18 Jun 2020 15:36:36 GMT https://community.splunk.com/t5/Splunk-Search/max-successfull-VPN-users-per-day-by-monthly/m-p/505011#M141050 richgalloway 2020-06-18T15:36:36Z