Tymoteusz Grzybowski Posted February 6, 2019 Share Posted February 6, 2019 Hi, Data set contains calls per employee to clients from whole year. Columns from dataset: Employee Full name; Call date; Year; Month; CALL_ID; ACCT_CNTCT_ID How to modify this formula Count([CALL_ID]) OVER ([Employee Full name],[ACCT_CNTCT_ID]) to receive: - number of calls (CALL_ID) - from Employee (Employee Full name) - to client (ACCT_CNTCT_ID) - which were delivered from February Thanks for replies. Greetings, tymek Link to comment Share on other sites More sharing options...
Gaia Paolini Posted February 6, 2019 Share Posted February 6, 2019 Hi something like this: Max(Case when ([Month]>1) and ([Year]=Year(DateTimeNow())) then Count([CALL_ID]) OVER ([Employee Full Name],[ACCT_CNTCT_ID]) else 0 end) OVER ([Employee Full Name],[ACCT_CNTCT_ID]) where the Max() around the CASE is to avoid having rows with zeroes where the condition is not satisfied. I am assuming Month is an integer, if not you will have to turn it into one, and that you want current year only. Gaia Link to comment Share on other sites More sharing options...
Tymoteusz Grzybowski Posted February 6, 2019 Author Share Posted February 6, 2019 Thank you very much. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now