Thanks for your reply. Can I make it dynamic? Can I group it based on the filters in the first two sheets instead of manually creating a group?
Hello! Curious if there's data where the student ID exists in more than one category that we can use. Or do you want to allow the end user to be able to choose the subjects to combine via parameters? Thanks!
Hello! Students are unique in each subject. The user should be allowed to select the subjects he/she wants to combine.
In terms of dynamic, you need to determine what the name should be or which subjects need to be combined, so what's the logic behind?
The first sheet filters for the first subject, and the second sheet filters for the other subject. I would like to combine both in the next sheet.
I hope this makes sense
I'd like to tackle on your question in a consulting way.
In the sample data, subject old and subject new are the same, which is difficult to create a clear sample workbook.
Thus, a create another set of sample data, which is closer to the real scenario.
In this data set, "Language" is omitted to make the explanation simple.
Table 1, Subject Master
If "Subject_previous" is vacant, "Change Date" is the subject setup date.
Subject_current Subject_previous Change Date subject_1 2017-01-01 subject_3 subject_2 2018-01-01 subject_3 2018-01-01 subject_5 subject_4 2018-03-01
Table 2, Student Facts
"Date" is the subject submit date for the student.
"Subject" is the original subject when the student submitted, which might have changed afterwards.
StudentID Subject Date Total Marks 1 subject_1 2017-12-01 58 2 subject_2 2017-12-01 48 3 subject_4 2018-02-01 86 4 subject_5 2018-04-01 87 5 subject_5 2018-04-01 26 6 subject_1 2018-03-01 82 7 subject_3 2018-04-01 32 8 subject_1 2018-02-01 61 9 subject_2 2017-11-01 28 10 subject_1 2018-02-01 88 11 subject_3 2018-03-01 29 12 subject_5 2018-04-01 65 13 subject_3 2018-02-01 88 14 subject_1 2018-02-01 88 15 subject_1 2018-02-01 84 16 subject_4 2018-02-01 95 17 subject_1 2018-02-01 37 18 subject_1 2018-02-01 85 19 subject_2 2017-11-01 40 20 subject_1 2018-02-01 94
From - To View
Here is the final view.
I attached the sample workbook for your reference.
The points are,
Since there are several fields related with subjects, it might be confusing.
Please let me know if you have question about the workbook.
Subjects.twbx 93.0 KB
Let me know if this makes sense. I have only one field for subject now. In the first sheet, I have a filter for History, the second sheet has a filter for Science. I want a third sheet which uses the filter results from Sheet 1 and Sheet 2 and combines these results. The subject name can be either of them or we can remove the filed itself. But the results should be a combined result of the first two sheets. I have attached the wb for your reference.
Sample_Tableau.twbx 18.0 KB
I think the solution above from Zhouyi Zhang can do this.
But if you only want one "filter" for each sheet and view these all one one page you can use parameters like so:
From1 uses [Subject] = [PA_Subject1] and
From2 uses [Subject] = [PA_Subject2]
To, of course, uses [Subject] = [PA_Subject1] OR [Subject] = [PA_Subject2]
Assuming you only want them to be able to select 2 Courses, I made a combined "Subjects" field:
WINDOW_MIN(MIN([Subject])) + " / " + WINDOW_MAX(MAX([Subject]))
This allows you to display the subjects selected in the same sheet. I don't think you can use a filter on each sheet and pass them both to a final sheet while keeping the filter from the other. Parameter may be best way to go. Hope this helps!