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, 2019 in Tableau by anonymous
870 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, 2019 by Cherukuri
• 33,030 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 17, 2018 in Tableau by ffdfd
• 5,550 points
567 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
15,240 views
0 votes
1 answer

Tableau Parameter with Multiple Measures

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

answered Mar 11, 2019 in Tableau by Cherukuri
• 33,030 points
7,654 views
0 votes
1 answer

create filter from multiple data sources

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

answered Mar 13, 2019 in Tableau by Cherukuri
• 33,030 points
669 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, 2019 in Tableau by Cherukuri
• 33,030 points
487 views
0 votes
1 answer

Highlight data with an filter/parameter

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

answered Apr 1, 2019 in Tableau by Cherukuri
• 33,030 points
658 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, 2019 in Tableau by Cherukuri
• 33,030 points
4,113 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, 2019 in Tableau by johnmario
• 160 points
7,661 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, 2019 in Tableau by Cherukuri
• 33,030 points
21,014 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, 2019 in Tableau by Cherukuri
• 33,030 points
2,019 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