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
16 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
• 17,630 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
35 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
939 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
• 17,630 points
25 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
• 17,630 points
11 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
• 17,630 points
9 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
• 17,630 points
17 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
• 17,630 points
28 views
0 votes
1 answer

SQL - table with rows with no null values.

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

answered Apr 2 in Tableau by Cherukuri
• 17,630 points
20 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
• 17,630 points
279 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
• 17,630 points
45 views