1 Reply Latest reply on Apr 22, 2018 2:02 PM by Shinichiro Murakami

# LOD for Like Schools

Hello All,

I am basically looking for a way to find a count of schools that are out performing any school based on two fields.

Year
ContentTest level
School NameFRM %Pass %
2016-17EnglishAllSchool A90%40%
2016-17EnglishAllSchool B90%50%
2016-17EnglishAllSchool C80%60%
2016-17MathAllSchool A90%55%
2016-17MathAllSchool B90%30%
2016-17MathAllSchool C80%60%

So for School A in English, I would need an equation that tells me there is 1 school with the same FRM% that has a higher Pass %. So for School A in Math, there are 0 schools with the same FRM% that has a higher Pass %.

I can write an LOD that gives me the number of schools with the same FRM% as whatever school ( {fixed [School Year],[Content Area],[Test Level],[Frm %]:SUM([Number of Records])} ), but I just cant figure out how to search that subset of schools by score to determine which of the schools have a better pass rate. Who has the same FRM % as me, but has a better Pass%.

Bonus points if you know how to make the "Same FRM% as me" into "my FRM % plus or minus a few points".

Any help is appreciated.

Thank you,

Shawn

• ###### 1. Re: LOD for Like Schools

HI Shawn,

I don't know how many record do you have, and if it's huge this approach does not work.

But if it's reasonably small, this one is one of the easiest.

Self join data source as below.

Thanks,

Shin