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
12 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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
• 12,420 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,470 points
31 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
554 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
• 12,420 points
11 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
• 12,420 points
10 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
• 12,420 points
5 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
• 12,420 points
13 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
• 12,420 points
14 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
• 12,420 points
12 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
• 12,420 points
93 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
• 12,420 points
37 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.