In operations dashboard, I have a field with number values some of which are null. I would like to view the info using the number selector, displayed as a slider, but none of the null values show up e.g. the slider shows results from 0 to 200,000. How do I add an option to select the null values?
Hi Luke Sussex,
Thanks for the question and details about your use case. Unfortunately, at this time there is not a way to include null values from a number selector (when applying a filter action to another element). This is a good enhancement idea, however. I will bring it to the team for consideration.
What's the status of this? I am finding that adding null string values to Category Selectors using the "+ Override" button is also not possible in Operations Dashboard.
I logged in to ask about this. I have null values in one field and I want the user to be able to select that, because it is meaningful.
I am going to recalculate "NULL" to "No Data" (text) and that should do it but the data is updated regularly, so I will have to recalculate whenever the data is updated. Also, I have large datasets and the calculation is taking a very long time.
Recalculating <Null> to 'No Data' sounds like a good work around, Randy. I will try that in the future.
After calculating your current data, I would change the field to not allow <Null> values and set a default value of 'No Data'. That way all new data that comes in will have this field populated and usable. Just remind your editors to update this field from 'No Data' to whatever is appropriate when needed.