How to we make a filter from a calculated field a context filter in Tableau

0 votes
Booking Size is a computed field with the formula:

'Small' is defined as RANK PERCENTILE(SUM(BK Total)) >= 0 AND RANK PERCENTILE(SUM(BK Total)).5.

ELSEIF RANK PERCENTILE(SUM([BK Total]) >=.5 AND RANK PERCENTILE(SUM([BK Total]) >=.5 AND RANK PERCENTILE(SUM([BK Total]) >=.5 AND RANK PERCENTILE(SUM([BK Total]) >=.5 AND RANK PER THEN 'Medium Small' (.7)

ELSEIF RANK PERCENTILE(SUM([BK Total]) >=.7 AND RANK PERCENTILE(SUM([BK Total])) AND RANK PERCENTILE(SUM([BK Total])) AND RANK PERCENTILE(SUM([BK Total])) AND RANK PERCENTILE(SUM([BK To .9 AFTER THAT, 'Medium'

ELSEIF RANK PERCENTILE(SUM([BK Total]) >=.9 AND RANK PERCENTILE(SUM([BK Total)).95 THEN 'Medium Large' is selected.

END IF 'Large' ELSE

I'd want to make this a context filter since the RANK PERCENTILE function in the preceding filter (Booking Size filter) recomputes the already filtered table if I apply any other filter on top of it.
Mar 10 in Tableau by Neha
• 6,260 points
92 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Tableau

0 votes
1 answer

How to add parameter and calculated field filter in tableau?

Hi Sindhu,  You cannot add parameter as a ...READ MORE

answered Mar 8, 2019 in Tableau by Cherukuri
• 33,010 points
3,229 views
0 votes
1 answer

How to create a single calculated field from multiple column filtering?

Try with this calculated field: ( ...READ MORE

answered Jul 6, 2018 in Tableau by sdfg
• 5,550 points
400 views
0 votes
1 answer

How to perform a calculation using one variable with an aggregation in calculated field?

Hi, You can use the calculative field and ...READ MORE

answered May 20, 2019 in Tableau by anonymous
• 33,010 points
207 views
0 votes
1 answer

How to fix spelling error in a field or column value using Tableau?

You should be able to use a ...READ MORE

answered Mar 10 in Tableau by Neha
• 6,260 points
55 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
7,956 views
0 votes
0 answers

Using Python and Tableau in conjunction with one another

Is it possible to mix Python visualisations ...READ MORE

Feb 28 in Tableau by Vaani
• 5,040 points
48 views
0 votes
0 answers

Tableau Desktop Inside Tableau Server

Is there an executable for Tableau Desktop ...READ MORE

Feb 28 in Tableau by Vaani
• 5,040 points
67 views
0 votes
0 answers

Tableau Map view Continent List

I've been attempting to tidy up my ...READ MORE

Feb 28 in Tableau by Vaani
• 5,040 points
38 views
0 votes
0 answers

Downloading tableau workbook from tableau server with data

I'm brand new to tableau server. I ...READ MORE

Feb 28 in Tableau by Vaani
• 5,040 points
71 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