Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I've been looking for weeks to figure out how to represent a customer's response time in a pie chart.
The first part of the pie chart should represent clients who responded between 0 and 10 business days. The second part between 10 and 20 business days, and then between 20 to 40/40-60/+60 business days .
Do you have any idea what function I should enter?
In my table, there are :
ID, sending date, 1st answer date.
Thank you very much!
Seems like just some nested if() statements but obviously it depends on how the data is structured...
if(Response Time < 10, '0-10 days',if(Response Time < 20, '11-20 days' etc.
Seems like just some nested if() statements but obviously it depends on how the data is structured...
if(Response Time < 10, '0-10 days',if(Response Time < 20, '11-20 days' etc.