Difference between corresponding fields in Tableau

Question

Hi i want to show data if difference between 2 fields for every product is greater than a constant. How to do this?

Answer 1

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.