Creating a Activity Sorting System for Users

[Snow]

Hello,
I am creating a sorting system for my users that are using the website. So the Activity in the database I have it set up so it just logs the date every time they are get on the website. I want to set something up when I can filter through and set up where if they are on the website less than 7 days they are active and then 8-14 days will be semi active and so on. I just can’t figure out how to set it up.

Can someone help me. I will give as much information as possible.

[TipLister]

hi,
i think you are looking for something like this

How to determine when the user logged in the last time

hi levente, for instance you can go to your workflow tab and add a workflow. Do every 5 minutes, only when current user is logged in. and update their last login date, or even keep a list of login dates and count that for each user. Instead of doing this every 5 minutes, you could also add this action “make changes to current user” whenever a certain button is pressed on your site. [2019-10-28%2012_28_24-listitemnew%20_%20Bubble%20Editor] [2019-10-28%2012_27_56-listitemnew%20_%20Bubble%2…

so something that updates , like a date or list of date, when every user logs in.

then the dropdown shows your words active semiactive etc.
then you have a workflow: when an inputs value is changed (the dropdown)
if dropdown value is active= change repeating group to only search for users active in last 7 days.
if dropdown value is semiactive change repeating group to only search for users active in last 7-14 days.