Tableau Quick Filter- How do I make it display a description but filter on a key

0 votes
I'd want to provide the user a user-friendly description field, but have that pick convert into a performance filter on an indexed field.

Assume I have a Widget table with two fields and tens of millions of rows. WidgetKey is a number, and WidgetDescription is a string. I need to allow the user to choose from a list of WidgetDescriptions, however the SQL should filter on the WidgetKey value.

Is it possible to accomplish this using a Tableau fast filter?
Apr 8, 2022 in Tableau by Vaani
• 7,070 points
391 views

1 answer to this question.

0 votes

Simply create a new calculated field with the description as the value and use it as the filter.

Name: WidgetDescription

CASE WidgetKey
    WHEN 'SomeKey' THEN 'Some Description'
    WHEN etc..
END


Master data visualization with our Tableau Training and unlock powerful insights from your data.

answered Apr 21, 2022 by Neha
• 9,020 points

Related Questions In Tableau

0 votes
1 answer

How to hide measures on a Tableau filter?

Number of Records is just a predefined ...READ MORE

answered Jul 11, 2018 in Tableau by ffdfd
• 5,550 points
2,398 views
+1 vote
1 answer

How can I filter data on different sheets based on clicks on Tableau

Filter actions are an essential and fundamental ...READ MORE

answered Jul 20, 2018 in Tableau by ffdfd
• 5,550 points
10,865 views
0 votes
1 answer

How to make a filter depend on another filter?

Hi Sindhu, Follow the below steps: 1. Add the ...READ MORE

answered Apr 2, 2019 in Tableau by Cherukuri
• 33,030 points
818 views
0 votes
0 answers

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

Booking Size is a computed field with ...READ MORE

Mar 10, 2022 in Tableau by Neha
• 9,020 points
824 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, 2022 in Tableau by Vaani
• 7,070 points
512 views
0 votes
0 answers

Tableau Desktop Inside Tableau Server

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

Feb 28, 2022 in Tableau by Vaani
• 7,070 points
460 views
0 votes
0 answers

Tableau Map view Continent List

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

Feb 28, 2022 in Tableau by Vaani
• 7,070 points
578 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, 2022 in Tableau by Vaani
• 7,070 points
589 views
0 votes
1 answer

How do I add a custom login and logout page in my Tableau Server on-prem?

I don't believe it is "officially" possible ...READ MORE

answered Mar 4, 2022 in Tableau by Neha
• 9,020 points
742 views
0 votes
1 answer

How do I create a bubble chart that is aligned in Tableau?

Put your dimension in the column shelf Put ...READ MORE

answered Apr 18, 2022 in Tableau by Neha
• 9,020 points
1,151 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP