How to choose only null values in a dashboard filter
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.
Step-by-step guide
In order to choose only null values, follow the steps below:
- Open the advanced filter:
-
Insert the following code:
{
"members": [
null
]
} - In order to exclude the null values, use this code:
{
"exclude": {
"members": [
null
]
}
}
-
Hi Yair,
Null values have certain restrictions. However, what you can do is in the Elasticube change all NULL value to a text value such as "{null}". In your example, any items with "{null}" value will be grouped together and you will be able to drill into just like any other group.
I hope this helps.
Ronen
Please sign in to leave a comment.
Comments
9 comments