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, 2019 in Tableau by Nithin
139 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, 2019 by Cherukuri
• 32,910 points

Related Questions In Tableau

0 votes
0 answers

Dynamically set the value of a filter based on a parameter selection in use to swap sheets

So I created a parameter to swap ...READ MORE

May 20, 2020 in Tableau by Patrick
• 120 points

edited May 20, 2020 by Gitika 504 views
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
6,246 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,820 points
109 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,550 points
4,197 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,820 points
2,442 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,820 points
287 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,550 points
200 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
3,223 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, 2019 in Tableau by Cherukuri
• 32,910 points
81 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, 2019 in Tableau by Cherukuri
• 32,910 points
77 views