Question

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

  • 14 November 2021
  • 0 replies
  • 16 views

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 replies

Be the first to reply!

Reply