Return rows with not null values in Tableau

Question

How to return rows with not null values from fields? My data source has offers for market on weekly basis, which contains order with different discounted products and quantity taken. i want to show orders with customer phone numbers.

Order id                  Phone
1                         

2                         xxxx-xxx-xxx

Answer 1

Hi Nithin,

You can add a calculated field to get the id whose value is not " " , then can form a group. Now show the orders for that product.

IF ISNULL([Phone No]) THEN "0"
ELSE [Order Id]
END

Now it might work.

Hope this helps you.

Ensure clarity in your Tableau visualizations by show '0' when data is absent. Learn how to represent missing data accurately and enhance the understanding of your insights. Start incorporating this simple yet effective technique into your Tableau dashboards now!