Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have tried to move the below calculation being performed in a chart to the load statement of a script and not getting the results I want. What I am trying to do is to eliminate the top 95% and bottom 5% of my numbers to come up with a number. I am sure I need to break it up into a couple of load statements but it is not working. Any ideas will be helpful. Here is the calculation:
avg(Total <Industry>aggr(if(aggr(sum({<AssetName= {"MaintenanceDirect"}>}EF4Value__c),AcctNum)>=
fractile(Total <Industry>aggr(sum({<AssetName= {"MaintenanceDirect"}>}EF4Value__c),AcctNum),.05)
and
aggr(sum({<AssetName= {"MaintenanceDirect"}>}EF4Value__c),AcctNum)<=
fractile(total <Industry> aggr(sum({<AssetName= {"MaintenanceDirect"}>}EF4Value__c),AcctNum),.95),
aggr(sum({<AssetName= {"MaintenanceDirect"}>}EF4Value__c),AcctNum)),AcctNum, Industry))
David
I am asking about actual source data in the tables.
You can convert above calculations into script level by using GROUP BY clause and your selections may be limited in you perform the calculations in the script level.
Please post some sample data and desired out put so some one from community will help you.
A sample of the data load above would be:
EF4_Value
CommunityCollege 50%
HE 60%
Public-K12 70%
Charter 74%
Does this make sense?
I am asking about actual source data in the tables.