How to have some values in filter to be static and some to be dynamic

0 votes
Hi, i want to differ my filter elements into mandatory and optional data. I want data to be selected from optional by user and mandatory to be hidden. so user cannot uncheck them. how to do this?
Mar 18, 2019 in Tableau by Nithin
378 views

1 answer to this question.

0 votes
Hi Nithin,

1. You can form group of those you require  to be mandatory and the vice versa using calculated field.

2. Now add the values that you require using any aggregation or a check operation and form groups.

3. Now add the group that you want optional in filter and place the field in row/ column shelf.

Hope this helps you.
answered Mar 18, 2019 by Cherukuri
• 33,030 points

Related Questions In Tableau

0 votes
1 answer

how to get the count of non zero values in a row

In first part you should solve the ...READ MORE

answered Apr 4, 2018 in Tableau by Atul
• 10,240 points
2,833 views
0 votes
1 answer

How to calculate profit when cost and revenue are in same column?

You can create the following calculated fields: Profit: SUM(IIF([account_category] ...READ MORE

answered Apr 10, 2018 in Tableau by ffdfd
• 5,550 points
901 views
0 votes
1 answer

How to dynamically determine and categorize duplicate value in Tableau?

Apparently you define a duplicate records as ...READ MORE

answered Apr 13, 2018 in Tableau by xyz
• 1,560 points
6,835 views
0 votes
1 answer
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,240 points
9,391 views
+2 votes
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,240 points
1,277 views
+2 votes
1 answer
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,030 points
4,669 views
0 votes
1 answer

How to automatically redirect and open a URL action in dashboard?

Hi, You can use url to provide search ...READ MORE

answered Mar 12, 2019 in Tableau by Cherukuri
• 33,030 points
1,491 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