You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register

    • Filtering NULL values in a dashboard prompt

    edited Apr 29, 2025 7:07PM in Reporting & Analytics for Sales 2 comments

    Summary:

    Hi,

    I need to be able to filter for NULL values in a dashboard. Specifically, I have a filter on Gender, which can be NULL or Male/Female, for example.

    If I use a filter on the Gender column in the dashboard prompt, it doesn't work for NULL values.

    In document Doc ID 2879317.1, I read:
    "If you are using this in a prompt, instead of column prompt, a variable prompt should be created to populate a presentation variable with the value that a user has selected/entered. Then this presentation variable should be used in a filter in the analysis and the filter should also include 'Query Type' is NULL condition."

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!