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,596 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.
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,200 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
716 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,060 points
415 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,391 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,276 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
3,664 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,292 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