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 in Tableau by Nithin
20 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 by Cherukuri
• 31,840 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
177 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 Atul
• 5,530 points
88 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 12, 2018 in Tableau by xyz
• 1,550 points
2,162 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
2,225 views
+1 vote
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
101 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 in Tableau by Cherukuri
• 31,840 points
203 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 in Tableau by Cherukuri
• 31,840 points
59 views