1 of 1 people found this helpful
I would suggest separating the values of the field out to make a more normalized data structure. I'm kind of guessing on your data, but maybe make a new table with a field such as "Grade" with the possible values of K 2 3...etc., using something like a GradeID to designate each entry.
Then make a relationship to School, example school 1 has K-2 grades.
If you want you don't have to make separate tables, you can put all the data in one large table. This link: http://kb.tableausoftware.com/articles/knowledgebase/preparing-excel-files-analysis will help with what I'm trying to explain. The problem is having multiple values within a string, by separating those values you can now have a dimension the includes the unique Grades you want to filter by.
That makes sense. I am using external data and was trying to avoid manipulating the file too much, but it is probably unavoidable. Thanks!
I think you'll find that cleaning the data and creating a better structure will make things easier than trying to find workarounds for bad data.
Since distinct number of grades is limited, you can search for each grade in both the grades string list and the parameter string list and thus confirm if any grade exists in both strings. See more in attached workbook.
Ps. We are more likely to attract helpers when we provide a packaged workbook with anonymized sample data.
This is explained in So Your Question Didn't Get Answered...