Hide Null Value in Filter But Keep in Calculation (Tableau)

 

Business Request:  Hide Null value in filter 'Downtime Type' but still keep it in calculation and show only 'Planned' and 'Unplanned'.  The reason is having Null value in the filter might be confusing for the users.

Solution:

    1)  Create a fake field to assign Null a different value that exists in the data set for field 'Downtime Type'.

        @Fake Field

        CASE [Downtime Type]

        When null then 'Planned'

        Else [Downtime Type]

        END

    2)  From this 'Fake Field', create a set 'Fake Field Set'

    3)  Create a 'Fake Field Set Filter' to be used as a filter

        @Fake Field Set Filter

        CASE [Downtime Type]

        When null then True

        Else [Downtime Type] in [Fake Field Set]

    4)  Drag @Fake Field Set Filter to filter shelf and select 'True'.  Use 'Fake Field Set' as a filter which should have only 2 values 'Planned' and 'Unplanned'.

Many thanks to Diego Martinez for help with the solution.

ServiceNow Sales and Order Management (Podcast)

   

ServiceNow Sales and Order Management (Podcast)

   

ServiceNow's Sales and Order Management (SOM) enables organizations to create one continuous value stream by managing the lead to renewal lifecycle on a single platform.  SOM helps teams to define new products, services, and catalog-driven fulfillment policies quickly, automates sales and order fulfillment processes, and empowers service staff to manage post-sale activities.  The results:  Organizations can bring offerings to market faster, accelerate and boost revenue, reduce costs, and improve customer experience.

Please visit ServiceNow, the AI platform for business transformation, to explore more about its portfolio of world-class products, now supercharged with AI agents.