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, 2019 in Tableau by Sindhu
176 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, 2019 by Cherukuri
• 33,010 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 4, 2018 in Tableau by sdfg
• 5,550 points
2,814 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 30, 2019 in Tableau by anonymous
17,808 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 30, 2018 in Tableau by Atul
• 10,230 points
277 views
0 votes
0 answers

Set difference: find distinct members for two groups in Tableau Desktop

In Tableau Desktop, how do I accomplish ...READ MORE

Apr 13 in Tableau by Neha
• 8,560 points
35 views
0 votes
1 answer

Creating calculate fields for year difference

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

answered May 22, 2019 in Tableau by anonymous
• 33,010 points
252 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,230 points
8,049 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,230 points
816 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, 2019 in Tableau by Cherukuri
• 33,010 points
1,181 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, 2019 in Tableau by anonymous
• 33,010 points
796 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP