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
13 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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
• 13,940 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,470 points
105 views
+1 vote
1 answer

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

Calculated fields are not written back to ...READ MORE

answered Aug 23, 2018 in Tableau by Naruto
• 710 points
503 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,200 points
35 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
291 views
0 votes
1 answer

Creating calculate fields for year difference

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

answered 5 days ago in Tableau by anonymous
• 13,940 points
10 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,200 points
946 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,200 points
36 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
• 13,940 points
30 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
• 13,940 points
5 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.