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 in Tableau by Nithin
808 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 by Cherukuri
• 31,840 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 24, 2018 in Tableau by Atul
• 10,240 points
1,372 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
57 views
0 votes
1 answer

Issues with the Range value in Tableau

One of the best solution is to ...READ MORE

answered May 8, 2018 in Tableau by Atul
• 5,530 points
80 views
0 votes
1 answer

Error: Comaparing date value with YEAR in Tableau

You have to ensure that the comparisons ...READ MORE

answered Jul 11, 2018 in Tableau by Atul
• 5,530 points
48 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
2,252 views
+1 vote
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
103 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 in Tableau by Cherukuri
• 31,840 points
163 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 in Tableau by johnmario
• 140 points
125 views