How to choose only null values in a dashboard filter

Comments

9 comments

  • Avatar
    Jane P

    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
  • Avatar
    Omer

    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
  • Avatar
    Jane P

    Thank you Omar

    0
    Comment actions Permalink
  • Avatar
    Yair Panet

    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
  • Avatar
    Ronen Avidor

    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
  • Avatar
    Carly Smallwood

    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
  • Avatar
    Omer

    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
  • Avatar
    Shikha Garg (Edited )

    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
  • Avatar
    Michal Saam

    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.