Interesting problem - Full disclosure - I am not statistically savvy - that said I think you can get the complement byt using the approach outlined below
since the Fixed formula sets up all the permutations of those dimensions that preceed the colon (:) by using <> against the actual dimension and the parameter I think it will work
It yielded the text table shown below
I did not carry it through to the other calcualtions but you get the idea
I do have a question - I looked at your data and saw 2-3 duplicates for each student ID - is that something you did just because the data is confidential or is it the result of some data collection process
In any event it doesn't make business sense -
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
example_problem2_v3.twbx 96.7 KB
Thanks for the reply! I'm not entirely sure this is working as expected... I've never encountered the "<>" operator before, what does this do exactly?
I tried this out in my actual dataset, and I'm not seeing any change...
Maybe I wasn't clear in what we're looking to accomplish. With the parameters selected the way they are (in the workbook I uploaded), I want the black dot to represent females, and the white dot males. But if the Gender parameter is set back to "All Genders", the black dot should represent both genders.
It gets more complicated when we add in the rest of the parameters, but I think starting with the simplest case would be best.
Let me know if this needs more clarification! It's definitely a tricky problem.
p.s. There are duplicate student IDs since the original data is collected on a yearly basis, so a student might be surveyed twice. Thanks for bringing that up, though!
thanks for the replay - the <> is Not Equal or in this case "does not include" - I am not a statistician so I can comment on the impact in the data other than to not that it was filtering out the total count when comparing the "Original" and revised version.
As to the duplicat IDs my question would be what is unique in your data set that you are using to to aggregate your data around? I'm seewing cases in yor data wwhere the same student ID refers alternately to male and female gender.
I figured the <> was Not Equal, thanks for clearing that up!
The duplicate ID issue is not relevant in this problem. If you'd like, you can delete them in the original data. They were there for previous tests and I never deleted them.