This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Running User logins, I summarized count by user and by month, and with the count of log that populates, I would like to like within each month my user at scenario where log sum by user by month > 4 then count 1, else 0. and > 14 etc.....
If I am understanding what you are trying to achieve correctly, I think you should be able to insert a filter tool with the condition:
[SUM_logins] > 4
Then insert another Summarize tool grouping on Month and Count Distinct User ID. This should give you the number of users who logged in more than 4 times in the given month. Attached is an example with starting where I assume you left off.
So with filters in my flow, it does not workit filters off results while I am trying to "mark" 1 or 0 rather based on criteria- I would need to add two new fields one for > 4 logs by user and by month, one for > 14, but I would like those as fields distinct from intial count- by user by month
per below I group by most fields in my initial pull so I do not loose any in output, and I have a count on login- When I use Group by on one file, can I assume that is a SUM? (u mention sum)
So if User 1 had 15 log in December, login count chose 15, > 4 and > 14 field I need to show "1". If Jan they have 5 logs, then > 4 as "1" and > 14 as
I hope I am making sense, really struggling to find the tool to do this.