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
653 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
• 33,030 points

Related Questions In Tableau

0 votes
1 answer

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

Here's a simplified example of the calculated ...READ MORE

answered Apr 29 in Tableau by anonymous
• 1,380 points
2,059 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
9,780 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 12, 2018 in Tableau by QueenBee
• 1,820 points
989 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 20, 2018 in Tableau by ffdfd
• 5,550 points
10,804 views
0 votes
1 answer

Reset filters in Tableau

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

answered Mar 30, 2018 in Tableau by QueenBee
• 1,820 points
3,952 views
0 votes
1 answer

How to create a global filter

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

answered Apr 13, 2018 in Tableau by QueenBee
• 1,820 points
1,431 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 ffdfd
• 5,550 points
840 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 21, 2018 in Tableau by Atul
• 10,240 points
5,012 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
• 33,030 points
768 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
• 33,030 points
1,699 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