Need help with a LOD expression pertaining to calculating growth
Bryan Mills Aug 3, 2016 10:29 AMI 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 0line 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