Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: How to Filter Out Null Values in a Chart

868 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Lizbeth_Pena_Fl
5 - Automation Enthusiast
5 - Automation Enthusiast

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? 

Lizbeth_Pena_Fl_0-1693935383016.png

 

2 Replies 2
John_Baronian
4 - Data Explorer
4 - Data Explorer

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....

 

Hey John, unfortunately I did not find a solution. I resigned myself to try to ignore the null group in the meantime.