In Sisense, null values are automatically translated to "N/A" in the front-end, so when "N/A" is chosen in the UI, 0 results are received. In this post, I'm going to show how can we choose/exclude all null values when required.
In order to choose only null values, follow the steps below:
- Open the advanced filter:
Insert the following code:
- In order to exclude the null values, use this code:
Please sign in to leave a comment.