Hi,
I have data from the customer service hotline. Some of the agents offered the customer upgrade product and were able to make a deal. I want to get the average time of the calls if they made the deal or not.
I have 2 tables: The first one - calls- shows the duration of the call.
The second one - shows if the customer was upgraded.
How do I get in 2 different cells the avg time of a call for customers who were upgraded and for customers who were not?
For the customers who were upgraded, the average duration call should be 506
For the customers who were not upgraded, the average duration call should be 900
Thank you!
I have data from the customer service hotline. Some of the agents offered the customer upgrade product and were able to make a deal. I want to get the average time of the calls if they made the deal or not.
I have 2 tables: The first one - calls- shows the duration of the call.
The second one - shows if the customer was upgraded.
How do I get in 2 different cells the avg time of a call for customers who were upgraded and for customers who were not?
For the customers who were upgraded, the average duration call should be 506
For the customers who were not upgraded, the average duration call should be 900
Thank you!