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