hi,
i think you are looking for something like this
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.