Skip to main content
Question

Customize ""Group by"" options for bar charts

  • June 15, 2017
  • 0 replies
  • 138 views
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?
      This topic has been closed for replies.

      • MichaelBarrow
      • Quickbase Alumni
      • June 16, 2017
      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.
      Terms & ConditionsAccessibility statement