Solved! Go to Solution.
Jasmine,
Thats a pretty advanced question let me check see if I can get someone on the data/dev team to take a look at this.
Regards,
Jason R.
<Summarization name="MEDVAL_CY" FieldName="MEDVAL_CY" dataset="2012/2017 Demographics (Esri)" aliasname="2012 Median Home Value" basetype="" SummaryType="CALC" WeightField="" category="2012 Home Value (Esri)" previewvalue="283479" longdescription="2012 Median Home Value (Esri)" usedfields="VAL0_CY,VAL50K_CY,VAL100K_CY,VAL150K_CY,VAL200K_CY,VAL250K_CY,VAL300K_CY,VAL400K_CY,VAL500K_CY,VAL750K_CY,VAL1M_CY" indexbase="167749">Dim values(10)%nl% values(0) = GetValue("VAL0_CY")%nl% values(1) = GetValue("VAL50K_CY")%nl% values(2) = GetValue("VAL100K_CY")%nl% values(3) = GetValue("VAL150K_CY")%nl% values(4) = GetValue("VAL200K_CY")%nl% values(5) = GetValue("VAL250K_CY")%nl% values(6) = GetValue("VAL300K_CY")%nl% values(7) = GetValue("VAL400K_CY")%nl% values(8) = GetValue("VAL500K_CY")%nl% values(9) = GetValue("VAL750K_CY")%nl% values(10) = GetValue("VAL1M_CY")%nl% %nl% Dim rangeValues(10,1)%nl% rangeValues(0, 0) = 0%nl% rangeValues(0, 1) = 50000%nl% rangeValues(1, 0) = 50000%nl% rangeValues(1, 1) = 100000%nl% rangeValues(2, 0) = 100000%nl% rangeValues(2, 1) = 150000%nl% rangeValues(3, 0) = 150000%nl% rangeValues(3, 1) = 200000%nl% rangeValues(4, 0) = 200000%nl% rangeValues(4, 1) = 250000%nl% rangeValues(5, 0) = 250000%nl% rangeValues(5, 1) = 300000%nl% rangeValues(6, 0) = 300000%nl% rangeValues(6, 1) = 400000%nl% rangeValues(7, 0) = 400000%nl% rangeValues(7, 1) = 500000%nl% rangeValues(8, 0) = 500000%nl% rangeValues(8, 1) = 750000%nl% rangeValues(9, 0) = 750000%nl% rangeValues(9, 1) = 1000000%nl% rangeValues(10, 0) = 1000000%nl% rangeValues(10, 1) = 1000002%nl% %nl% Dim median%nl% median = CalculateMedianLinear(values, rangeValues)%nl% %nl% ReturnValue(median)<Defaults decimals="0" percentage="" valueType="CURRENCY" indexable="TRUE" /></Summarization>
Jasmine,
Are you looking to create your own Median Home Value calculation, customize our calculation, or use our calculation unmodified? In our dataset we use 2012 Median Value of Owner Occupied Housing Units(MEDVAL_CY) and its a standard variable in our base dataset.
Here is the calculation directly from our 2012 dataset. The stub names in the calculation are the same as the 2011 dataset.<Summarization name="MEDVAL_CY" FieldName="MEDVAL_CY" dataset="2012/2017 Demographics (Esri)" aliasname="2012 Median Home Value" basetype="" SummaryType="CALC" WeightField="" category="2012 Home Value (Esri)" previewvalue="283479" longdescription="2012 Median Home Value (Esri)" usedfields="VAL0_CY,VAL50K_CY,VAL100K_CY,VAL150K_CY,VAL200K_CY,VAL250K_CY,VAL300K_CY,VAL400K_CY,VAL500K_CY,VAL750K_CY,VAL1M_CY" indexbase="167749">Dim values(10)%nl% values(0) = GetValue("VAL0_CY")%nl% values(1) = GetValue("VAL50K_CY")%nl% values(2) = GetValue("VAL100K_CY")%nl% values(3) = GetValue("VAL150K_CY")%nl% values(4) = GetValue("VAL200K_CY")%nl% values(5) = GetValue("VAL250K_CY")%nl% values(6) = GetValue("VAL300K_CY")%nl% values(7) = GetValue("VAL400K_CY")%nl% values(8) = GetValue("VAL500K_CY")%nl% values(9) = GetValue("VAL750K_CY")%nl% values(10) = GetValue("VAL1M_CY")%nl% %nl% Dim rangeValues(10,1)%nl% rangeValues(0, 0) = 0%nl% rangeValues(0, 1) = 50000%nl% rangeValues(1, 0) = 50000%nl% rangeValues(1, 1) = 100000%nl% rangeValues(2, 0) = 100000%nl% rangeValues(2, 1) = 150000%nl% rangeValues(3, 0) = 150000%nl% rangeValues(3, 1) = 200000%nl% rangeValues(4, 0) = 200000%nl% rangeValues(4, 1) = 250000%nl% rangeValues(5, 0) = 250000%nl% rangeValues(5, 1) = 300000%nl% rangeValues(6, 0) = 300000%nl% rangeValues(6, 1) = 400000%nl% rangeValues(7, 0) = 400000%nl% rangeValues(7, 1) = 500000%nl% rangeValues(8, 0) = 500000%nl% rangeValues(8, 1) = 750000%nl% rangeValues(9, 0) = 750000%nl% rangeValues(9, 1) = 1000000%nl% rangeValues(10, 0) = 1000000%nl% rangeValues(10, 1) = 1000002%nl% %nl% Dim median%nl% median = CalculateMedianLinear(values, rangeValues)%nl% %nl% ReturnValue(median)<Defaults decimals="0" percentage="" valueType="CURRENCY" indexable="TRUE" /></Summarization>
Regards,
Jeff Hincy