Filter Measure Based on Different Variables of the Same Dimension

0 votes
Hi, i want to filter students using USN to classify students into departments and sections from a student database. Can someone help me how to classify and filter students using above?

Roll numbers are in the format 1[a-z][a-z][17/18][cs/is/ec/tc][0-180].
Mar 11 in Tableau by Nithin
28 views

1 answer to this question.

0 votes

Hi Nithin, I used calculated fields. You can use regular expressions to do the same too

1. Create a calculative field to classify students from different departments.

2. Create another calculative field to classify students into sections.

3. The groups are as follow.

4. Now add both the fields into filter shelf to perform filters.

Hope this helps you.

answered Mar 11 by Cherukuri
• 25,900 points

Related Questions In Tableau

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
1,815 views
0 votes
1 answer

Divide count of Table 1 by count of Table 2 on the same time interval

Use a custom SQL to create a ...READ MORE

answered Apr 11, 2018 in Tableau by QueenBee
• 1,810 points
24 views
+1 vote
1 answer

How can I filter data on different sheets based on clicks on Tableau

Filter actions are an essential and fundamental ...READ MORE

answered Jul 19, 2018 in Tableau by Atul
• 5,530 points
177 views
+1 vote
1 answer

How to add filter on different sheets based on clicks?

Go to Actions… (if you're on a dashboard, you ...READ MORE

answered Aug 1, 2018 in Tableau by Atul
• 10,240 points
49 views
0 votes
1 answer

Reset filters in Tableau

I understood your question (I hope so!). ...READ MORE

answered Mar 29, 2018 in Tableau by QueenBee
• 1,810 points
589 views
0 votes
1 answer

How to create a global filter

Assuming you have created a dashboard already, ...READ MORE

answered Apr 12, 2018 in Tableau by QueenBee
• 1,810 points
49 views
0 votes
1 answer

How can I create a second sheet which is filtered to 8 days ago,

Following are the steps you can follow: Create ...READ MORE

answered Jul 11, 2018 in Tableau by Atul
• 5,530 points
38 views
0 votes
1 answer

How to filter/parameter for different date ranges

Steps: Create a parameter control that the users ...READ MORE

answered Jun 20, 2018 in Tableau by Atul
• 10,240 points
712 views
0 votes
1 answer

How to show a chart with only a part of the dimension/measure value.

Hi Nithin, Follow below steps: 1. Create a calculative ...READ MORE

answered Apr 2 in Tableau by Cherukuri
• 25,900 points
22 views
0 votes
1 answer

Creating two different aggregations/calculation on same measure

Hi Sindhu, Any measure in Tableau can be ...READ MORE

answered Apr 10 in Tableau by Cherukuri
• 25,900 points
16 views