Customize "Group by" options for bar charts

  • 1
  • 2
  • Question
  • Updated 1 year ago
  • Answered
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?
Photo of Nenad Ilic

Nenad Ilic

  • 734 Points 500 badge 2x thumb

Posted 1 year ago

  • 1
  • 2
Photo of Michael Barrow

Michael Barrow

  • 2,206 Points 2k badge 2x thumb
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.
Photo of Nenad Ilic

Nenad Ilic

  • 734 Points 500 badge 2x thumb
Works perfectly, thank you Michael.
Photo of Michael Barrow

Michael Barrow

  • 2,206 Points 2k badge 2x thumb
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 ....