Difference between corresponding fields in Tableau

0 votes
Hi i want to show data if difference between 2 fields for every product is greater than a constant. How to do this?
Apr 24 in Tableau by Sindhu
24 views

1 answer to this question.

0 votes

HI Sindhu,

Follow below steps:

1. Create a calculated field as below.

    IF [COL_FIELD1] - [COL_Field] < 10 THEN [row-field]
    ELSE "OTHERS"
    END

   

2. Now drop the created field in the filter and unselect "Others" to show the rows that have greater than a constant value.

Use ABS() if you want the difference to be compared with constant.

Hope it helps you.

answered Apr 24 by Cherukuri
• 25,660 points

Related Questions In Tableau

+1 vote
1 answer

How to perform top N fields with nested sort in tableau

You can use the following steps: Sort 'State' ...READ MORE

answered Aug 3, 2018 in Tableau by Atul
• 5,530 points
341 views
+1 vote
2 answers

How to join tables based on “Calculated Fields” in Tableau?

You absolutely can join to a calculated ...READ MORE

answered May 29 in Tableau by anonymous
1,215 views
0 votes
1 answer

Filtering in Tableau by combining multiple fields

Try This Create 3 parameter Start Date End Date City Now Create a ...READ MORE

answered Aug 29, 2018 in Tableau by Atul
• 10,240 points
49 views
0 votes
1 answer

Reset filters in Tableau

I understood your question (I hope so!). ...READ MORE

answered Mar 29, 2018 in Tableau by QueenBee
• 1,810 points
580 views
0 votes
1 answer

Creating calculate fields for year difference

Hey cherry, Drop Date field and dimension and ...READ MORE

answered May 22 in Tableau by anonymous
• 25,660 points
22 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
1,786 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
76 views
0 votes
1 answer

Show the fields/dimensions in filter used in sheet name in Tableau

Hi Anitha, Follow below steps: 1. Create required visual/chart. 2. ...READ MORE

answered Apr 22 in Tableau by Cherukuri
• 25,660 points
49 views
0 votes
1 answer

How to form user made hierarchies in tableau to drill up/down fields?

Hi Prakash, It's easy to make hierarchies to ...READ MORE

answered May 9 in Tableau by anonymous
• 25,660 points
17 views