How to choose only null values in a dashboard filter

Follow

Omer

March 14, 2017 07:56

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:

1. Open the advanced filter:

1. Insert the following code:
   {
   "members": [
   null
   ]
   }

2. In order to exclude the null values, use this code:

        {
         "exclude": {
           "members": [
             null
           ]
        }
       }

2

• 

  Jane P March 14, 2017 13:34

  Thanks Omer. What does "explicit" and "multiselection" in your screenshot mean?

  You also don't use those values in the example code. Why?

  J

  0

  Comment actions Permalink
• 

  Omer March 15, 2017 11:01

  Hi Jane,

  "explicit" means that the filter will return only the values chosen, instead of excluding them.

  "multiselection" allows to choose multiple values.

  Both of these are not required because explicit is in default set to true and we choose only one value (null)

   

  Regards,

  Omer

  1

  Comment actions Permalink
• 

  Jane P March 28, 2017 15:47

  Thank you Omar

  0

  Comment actions Permalink
• 

  Yair Panet October 23, 2017 18:36

  Hi Omer,

  I really don't understand why it is not possible to filter null objects just like any other object. If I have a pie chart, and 33% of it is grouped into null, I should be able to drill into it just like any other group.

  I hope you guys can fix this.

  Thanks,

  Yair

  1

  Comment actions Permalink
• 

  Ronen Avidor November 21, 2017 23:28

  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

  1

  Comment actions Permalink
• 

  Carly Smallwood January 10, 2018 15:48

  Hi Omer,

  How can I change the code in step 1. to exclude rather than include null values? I added the line '"explicit":false, ' but this didn't change my resulting value.

  Thanks,

  Carly

  0

  Comment actions Permalink
• 

  Omer January 12, 2018 09:06

  Hi Carly,

  In order to extract values, this is how the filter should be written:

  {
  "exclude": {
    "members": [
      null
    ]
   }
  }

  If this is not working for you, please let us know.

   

  Regards,

  Omer

   

  1

  Comment actions Permalink
• 

  Shikha Garg April 09, 2018 22:18 (Edited April 09, 2018 22:21)

  Hi Omer, 

  When i use the above code to filter out the null values and then try to do some changes in my dashboard like adding more widget - my exclude filter gets changed to somethings else as attached.

  0

  Comment actions Permalink
• 

  Michal Saam August 19, 2019 14:18

  Hi! I'm trying to include "Null" options, as well as including cells that contain the string "founder". how can I do it? I tried merging this answer + the query I had and it didn't went well:

  {
  "explicit": true,
  "multiSelection":true,
  "members":
  ["contains": "FOUNDER"], [NULL]
  }

  0

  Comment actions Permalink

Please sign in to leave a comment.