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 p...
Forum Discussion
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.
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.
- Works perfectly, thank you Michael.
- 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 ....
