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.