I am attempting to general a list of users who log...
# administration
t
I am attempting to general a list of users who log into NetSuite frequently (I'm calling it "Engaged" users). My attempt to create this list is to see who has logged in at least 10 times in the past 30 days, but I haven't figured out how to successfully filter out users who have logged in less than 10 times. They are still included in my list. Any ideas on what I am doing wrong? More details in the thread so I don't clog up the board -->
I've created a Login Audit Trail search, and my results are showing up accurately. I just want to narrow the results list to only include users who have logged in 10 times or more. My results column of of login Date that is summarized by Count is retrieving the correct count, but when I try and incorporate similar Summary criteria of Count of Date is greater than or equal to 10, I get an error. I'm assuming that this is because I am trying to summarize a date field with a Count summary, but I'm stuck on how to refine this list. It currently shows 158 users that have logged in at all in the past 30 days, but I'm only wanting to see the 64 users that have logged in 10 times or more. Any ideas? I'll put some screenshots over in the thread to give some more context.
message has been deleted
I figured out an alternative solution. Rather than using a Date field to do the summary, I did a Formula Numeric Sum on the Status being the word 'Success', and that was less picky.
r
thx for sharing