Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
lmabroukf
Contributor II
Contributor II

Pie chart - different slice size

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!

Labels (7)
1 Solution

Accepted Solutions
Or
MVP
MVP

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.

View solution in original post

1 Reply
Or
MVP
MVP

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.