Forum Discussion

NenadIlic's avatar
NenadIlic
Qrew Assistant Captain
8 years ago

Customize ""Group by"" options for bar charts

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?
  • MichaelBarrow's avatar
    MichaelBarrow
    Qrew Cadet
    8 years ago
    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.
    • NenadIlic's avatar
      NenadIlic
      Qrew Assistant Captain
      8 years ago
      Works perfectly, thank you Michael.
    • MichaelBarrow's avatar
      MichaelBarrow
      Qrew Cadet
      8 years ago
      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 ....