Discussions

 View Only
  • 1.  Customize ""Group by"" options for bar charts

    Posted 06-15-2017 11:27
    For bar report charts I would like to customize the group by choices, if possible, since the offered choices (equal values, 0.001; 0.01; 0.1; 1; 10; 100)  do not give me the precise overview.
    Is it possible to create a "group by" selection, or customize it to have overview, in example, 0-30, 31-60, 60-90 etc?


  • 2.  RE: Customize ""Group by"" options for bar charts

    Posted 06-16-2017 03:15
    Best way to do this would be to create a formula text field and use that instead of the raw value in grouping for your chart:

    If( [YourRawFieldValue] >= 0 and [YourRawFieldValue] <= 30, "0-30",
        [YourRawFieldValue] > 30 and [YourRawFieldValue] <= 60, "31-60",
        [YourRawFieldValue] > 60 and [YourRawFieldValue] <= 90, "61-90",
        "91+"
    )

    Something like that.


  • 3.  RE: Customize ""Group by"" options for bar charts

    Posted 06-16-2017 07:19
    Works perfectly, thank you Michael.


  • 4.  RE: Customize ""Group by"" options for bar charts

    Posted 06-16-2017 15:33
    Excellent! In general, QB makes it fantastically easy to harness formula fields to do all sorts of things that on other platforms would be done differently (but harder). The trick is keeping track of all those formula fields and what they do and how they relate to each other. Computer Science ... sigh ....