Hi Crystal

you can use an LOD of determine the to determine the averages involved something like   {include [school name] :average(Reprimand Rate)} and

{include [school name] :average(Praise Rate)}   and place them in place of the fixed values in your formula above

note if you plan to change other dimensions you can include those in the lod statements also

Jim

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.

this is why we want to see your twbx workbook when you post a question

all that message means is that something in you formula is aggregated and other things are not

wrap all of the [rep rate} and the [Praise rate]  in Min()

Jim

Hi Crystal,

I think you want to use a FIXED formula without aggregating at the level of School. If I specify School in the LOD, then it doesn't seem to come out correctly when all schools are selected, because when all schools are selected we don't want an average at each school level, we want the average of all the detail regardless of school.

If you use FIXED, you can make the school be taken into account by adding the School Filter to Context as shown in the screenshot below. Also, I think you want the Rep Rate in the second clause to be "<=" rather than "<".

I have also created the Fixed Avg Praise and Rep rates as their own calculations, and added them to the Level of Detail in the view so that we can use them for the reference lines.

When in the view, change them to "Attribute".

Now use these calculations as your reference lines:

Workbook is attached. It seems to be working correctly .

Best,

Jennifer