Filter via cell with multiple values

0 votes

Hi, I want to filter data from table that contains student marks details which has student name,id, subject code,marks. Students can select subjects from different courses, so a computer science student can take Electronics subject too. Student id(1AB13CS042) and subject (10CS62) code contains the department as "EC"/"CS"/"IT".  I want to filter students from department wise and subject code wise. can someone help me? 

Mar 4 in Tableau by anonymous
26 views

1 answer to this question.

0 votes

Hi, you can use string pattern matching or sub string method to form groups and apply filter on them. I used  "find function" to find the sub string to find the department and subject of student.

Below is a snap of calculative field to group students by Department.

Below is a snap of calculative field to group students by Subject codes.

Drag an drop both groups in the filter shelf to apply filters.

Sample visualization after applying filters. 

Hope this helps you.

answered Mar 4 by Cherukuri
• 31,840 points

Related Questions In Tableau

0 votes
0 answers

Creating a multiple charts with calculated field

Sample data: Table Name: A Mode Country Month Visitor ...READ MORE

Aug 16, 2018 in Tableau by Atul
• 5,530 points
53 views
0 votes
1 answer

How to get multiple Sets of Measure Names with different Filters on a single sheet in Tableau?

The easiest solution to your query is: 1) ...READ MORE

answered Aug 23, 2018 in Tableau by Naruto
• 710 points
1,921 views
0 votes
1 answer

Tableau Parameter with Multiple Measures

Hi sindhu,  Parameters can be created as below. 1. ...READ MORE

answered Mar 11 in Tableau by Cherukuri
• 31,840 points
98 views
0 votes
1 answer

create filter from multiple data sources

Hi Nithin, 1. You can perform full outer ...READ MORE

answered Mar 13 in Tableau by Cherukuri
• 31,840 points
27 views
0 votes
1 answer

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

Hi Nithin, 1. You can form group ...READ MORE

answered Mar 18 in Tableau by Cherukuri
• 31,840 points
20 views
0 votes
1 answer

Highlight data with an filter/parameter

Hi, Follow below steps: 1. When you add ...READ MORE

answered Apr 1 in Tableau by Cherukuri
• 31,840 points
28 views
0 votes
1 answer

SQL - update table with null values in row.

Hi Sindhu, Before loading the data and fields from ...READ MORE

answered Apr 2 in Tableau by Cherukuri
• 31,840 points
159 views
0 votes
2 answers

SQL - table with rows with no null values.

SELECT primary_author, published_date, title FROM ...READ MORE

answered Sep 4 in Tableau by johnmario
• 140 points
124 views
0 votes
1 answer

Tableau- Pie Chart with Multiple Measure Values

Hi Nithin, Pie chart is used to show ...READ MORE

answered Mar 11 in Tableau by Cherukuri
• 31,840 points
784 views
0 votes
1 answer

Create global filter from single/multiple data source to multiple data sources on dashboard.

Hi Sindhu, You can use filters from worksheets in ...READ MORE

answered Mar 11 in Tableau by Cherukuri
• 31,840 points
77 views