
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 05, 2023 10:41 AM
Hi,
I am creating a chart that shows Purchase Orders grouped by status, but I am getting a group for "null." The status field is a drop-down single select with the 3 options below. I've confirmed that the status of all records is not empty. I have also tried manually adding a filter to filter out records where the status is empty, but I still get the "null" group.
How can I get rid of the "null" grouping in the chart?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 25, 2023 12:10 PM - edited ‎Oct 25, 2023 12:38 PM
Hi were you able to resolve this. We have a similar issue with no null fields in our y axis value.
If we change the field type to a number the null goes away but so do the color choices based on the type of select (single/multi). I have a feeling that the "Add Option" select field is the Null that shows up....

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 26, 2023 10:44 AM
Hey John, unfortunately I did not find a solution. I resigned myself to try to ignore the null group in the meantime.
