Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
np,
Make a new formula text field called Issue Resolution Groups with the formula
IF(
[Issues resolution days] < =1, " 1"
[Issues resolution days] < =2, " 2"
[Issues resolution days] < =5, " 3-5"
[Issues resolution days] < =10, " 6-10"
[Issues resolution days] < =11, "11+")
Then base your chart in that field for the "series".
I have contrived the values with leading spaces to get them to sort properly.
Make a new formula text field called Issue Resolution Groups with the formula
IF(
[Issues resolution days] < =1, " 1"
[Issues resolution days] < =2, " 2"
[Issues resolution days] < =5, " 3-5"
[Issues resolution days] < =10, " 6-10"
[Issues resolution days] < =11, "11+")
Then base your chart in that field for the "series".
I have contrived the values with leading spaces to get them to sort properly.
- QuickBaseCoachD7 years agoQrew CaptainCorrection
IF(
[Issues resolution days] < =1, " 1"
[Issues resolution days] < =2, " 2"
[Issues resolution days] < =5, " 3-5"
[Issues resolution days] < =10, " 6-10", "11+") - LauraBeerman7 years agoQrew Trainee
Hi there - Trying it now. I see the different clusters are on separate lines. Does that mean each one is it's own formula? If not, how do I separate [Issues resolution days] < =1, " 1" from [Issues resolution days] < =2, " 2" for example--comma? Thanks!
- LauraBeerman7 years agoQrew Trainee
I'm pretty literal with the help at this stage in my QB - sorry, super green!
- QuickBaseCoachD7 years agoQrew CaptainSorry, I forgot the commas. It is all one formula.
IF(
[Issues resolution days] < =1, " 1",
[Issues resolution days] < =2, " 2",
[Issues resolution days] < =5, " 3-5",
[Issues resolution days] < =10, " 6-10", "11+") - LauraBeerman7 years agoQrew TraineeWorked like a charm! You are the bomb. Thanks so much for your help today.