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
29 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
• 31,840 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
550 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,690 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
61 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
856 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
• 31,840 points
29 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,259 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
104 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
• 31,840 points
72 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
• 31,840 points
26 views