Quick Base Discussions

Expand all | Collapse all

Creating chart with aggregated data values

  • 1.  Creating chart with aggregated data values

    Posted 12-29-2017 17:25
    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?


  • 2.  RE: Creating chart with aggregated data values

    Posted 12-29-2017 17:33
    did you try a case statement?


  • 3.  RE: Creating chart with aggregated data values

    Posted 12-29-2017 17:37
    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.


  • 4.  RE: Creating chart with aggregated data values

    Posted 12-29-2017 17:56
    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+")


  • 5.  RE: Creating chart with aggregated data values

    Posted 12-29-2017 18:49

    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!



  • 6.  RE: Creating chart with aggregated data values

    Posted 12-29-2017 18:50

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



  • 7.  RE: Creating chart with aggregated data values

    Posted 12-29-2017 18:51
    Sorry, 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+")


  • 8.  RE: Creating chart with aggregated data values

    Posted 12-29-2017 19:15
    Worked like a charm! You are the bomb. Thanks so much for your help today.