Return rows with not null values in Tableau

0 votes
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
Apr 10, 2019 in Tableau by Nithin
5,860 views

1 answer to this question.

0 votes

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!

answered Apr 10, 2019 by Cherukuri
• 33,030 points

Related Questions In Tableau

0 votes
1 answer

How to combine rows with same information in Tableau

@Ghost, Tableau has a function RANK_UNIQUE which you ...READ MORE

answered May 25, 2018 in Tableau by Atul
• 10,240 points
7,620 views
0 votes
1 answer

Using Regex in Tableau, but only getting Null values.

Tableau regex engine is ICU, and there ...READ MORE

answered Aug 17, 2018 in Tableau by AwesomeSauce
• 860 points
898 views
0 votes
1 answer
0 votes
1 answer

How to share a workbook with client in Tableau who do not have Tableau account or tableau reader

It's possible that there isn't a way ...READ MORE

answered Apr 5, 2022 in Tableau by Neha
• 9,020 points
637 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
9,840 views
+2 votes
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
1,563 views
+2 votes
1 answer
0 votes
1 answer

SQL - update table with null values in row.

Hi Sindhu, Before loading the data and fields from ...READ MORE

answered Apr 2, 2019 in Tableau by Cherukuri
• 33,030 points
4,186 views
0 votes
2 answers

SQL - table with rows with no null values.

SELECT primary_author, published_date, title FROM ...READ MORE

answered Sep 4, 2019 in Tableau by johnmario
• 160 points
7,683 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP