CODEWITHSUNDEEP
visualizationdata-visualizationtableau-api
Pragyan Bezbaruah
Pragyan Bezbaruah

Reputation: 183

Tableau Calculated Field Filtering

I am struggling with Custom Filter using Calculated Field. Below is the screenshot of the same visualized chart.

Screenshot

What I am struggling is to create a filter where I can give a scale of Correlation, example - I want to show all the age groups and Ethnicity where the Correlation value is between 0.6 and 0.9

I am able to bring in one Measure Value and as you can see, the filter slider is there. But I need that filter to work on all the fields and not just one value. Like a Universal Slider for all the values.

Please help.

Upvotes: 0

Views: 1212

Answers (1)

Alexander
Alexander

Reputation: 1967

You cannot set one filter to be used on several measures. However what you can do is create two parameters and use them to filter each measure in relation.

  1. create 2 parameters minCorrelation and maxCorrelation with values between 0 and 1 and stepsize of 0.1 (or whatever granularity you need)
  2. open one of your filters and go to formula, use a custom formula like [0-17] > [minCorrelation] AND [0-17] < [maxCorrelation]
  3. repeat that for every measure and the filter will adjust when you change the values for your parameters.

Upvotes: 0

Related Questions