I have a column in db status.
For the filter in the visualization, if any of the data open or closed not available ,I have to display as it is null without making any change in script.Because filter will show only open or closed.
Is it possible?
You can't select null values in a visualization.
Best is to replace them in the script with a known value.
Changes in the front-end are usually slow.
It is best practice to join your tables in the script, so that you can identify where the nulls are...
This is not equal to saying not available !
Try as follow:
and then try the expressions.
This is a real use case of "Status not available"
Yes I know;
but to check this, u have to do as I told u;
if there is no status in ur db it translates to this :
not to :