
I have a chart that shows over 1000 data points within a decimal field with 4 decimals. I'm trying to group these values to get a count by whole number.
For example, I want the values: 1.204, 1.3156, 1.346, 1.174, grouped to show 4 records at 1 instead of 1 records at each value respectively.
*This post is locked for comments
I have the same question (0)One idea is to create a custom field and update it with a whole number when the value changes. Then use that number in your chart. You do not have to display the field on the form.
You can also export the chart xml, manually make the change you need in the xml and reimport it.