Forum Discussion

LauraBeerman's avatar
LauraBeerman
Qrew Trainee
7 years ago

Creating chart with aggregated data values

I'm creating a pie chart from a column where the number of days to resolve an issue could range from 1 to any number. In my chart, I'd like to aggregate the day values to: 1, 2, 3-5, 6-10 and More than 10. My number of days field property is numeric. I've tried creating a calculated column but am having trouble with the formula. I tried an "If" formula with a series but that didn't work. Any suggestions?
Ask about Quickbase functionality

7 Replies

Sort By
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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.
    • QuickBaseCoachD's avatar
      QuickBaseCoachD
      Qrew Captain
      7 years ago
      Correction
      IF(
      [Issues resolution days] < =1, "  1"
      [Issues resolution days] < =2, "  2"
      [Issues resolution days] < =5, " 3-5"
      [Issues resolution days] < =10, " 6-10", "11+")
    • LauraBeerman's avatar
      LauraBeerman
      Qrew Trainee
      7 years ago

      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!

    • LauraBeerman's avatar
      LauraBeerman
      Qrew Trainee
      7 years ago

      I'm pretty literal with the help at this stage in my QB - sorry, super green!