I am calculating a student's test score growth (identified by a dimension in the data called SSID) so I may evaluate a specific class (cohort) and how many students are reaching their growth targets each year. This is accomplished by evaluating a student's level in 2015 and then looking up a growth target (a lookup table that is joined in the datasource) and doing all the various calculations based off of that.
I've been struggling with this for a while and while I have my growth calculations working as intended at the student level, I cannot get them to aggregate properly at the school level. I admit that the way I've done this is probably not the most efficient and rather messy...but at least it works...mostly It's a somewhat complicated process to calculate growth that is dependent on the Student Level variable and I made due but finding similar examples out there has been super tough and so this is the best I could come up with by myself.
In the attached workbook, the Student List viz calculates as intended. The 0-line of the chart is in effect their growth target and how far to the left or right they fall indicates how far below or above their growth target a student was. Donald Duck Elementary for example has 96 rows (students), 11 of whom had a Growth Gap of < 0 (which indicates you did not hit your target) while 85 students had a Growth Gap of >= 0 so 88.5% of the students met their target. But, when you go to the School List viz it shows that there are 103 students at Donald Duck Elementary and just 57 had a Growth Gap of >=0 or 55% and both sheets are using the same set of filters. The measure I'm using is simply taking that Growth Gap calculation and fixing it at the SSID level which I assumed would aggregate the results by building but there's something I'm missing and I can't figure it out...
Can someone tell me where I may be going wrong here? And if anyone has any thoughts on a better / more efficient way of calculating growth based on a different target per student based on their Student Level in 2015, I'm all ears!
Thanks Tableau community!
Growth LOD Calc.twbx 595.0 KB