how to apply filters based on a list - user in (select distinct user from t)

hey

i’m presenting a dashboard based on users action - i.e. calls to costumer case (CC)

Imagine that i want to show the users that had above 10 calls to CC + present their number if calls

If I’ll use the simple logic of - where calls to CC > 10 , than my counter will miss the 1st 10 calls.

Therefore - i’m looking for a way to do something like this

select

user,

num_calls_to_cc

from t

where user in (select distinct user from t where num_calls_to_cc >= 10)

thanks

0 0 47
0 REPLIES 0
Top Labels in this Space
Top Solution Authors