Solved! Go to Solution.
Jasmine,
Understood, but if you are you using the BA Custom Data Setup wizard and if you have the Business Analyst Data loaded into your MXD then you will have access to whichever dataset you are licensed for and it would not matter if you created a BDS on our data or imported your own data. Either way you typically would be required to join your data to our geometries and as part of that process you would have access to our entire dataset in the variable select dialogue.
So the only way you wouldnt see the BA data is if you imported your data and you used your own geometries. Either way if you are not seeing the BA variables then I suggest you call in an incident to tech support and if they cannot assist you can tell them to get me involved and we can work through it on the phone.
I hope this helped. 🙂
Regards,
Jeff
OK, below is the calculation that is formatted to work in the Custom Data Setup Wizard you will need to calculate the Current Year Median Home Value. Just be sure you have all the underlying home value variables used in the calculation in your BDS or it wont work. I just manually built this calculation and I havent tested it so I would suggest if it works that you create a trade area and compare the online Median Home Value to this one to be sure I didnt make any mistakes. Keep in mind if you pulled the data from BAO the Median Home Value data will be 2012 vintage and not 2011.
As an aside if you update your maintenance for the 2012 data desktop release this variable will be included in that dataset.
Let me know if this works for you.
Regards,
Jeff Hincy
Dim values(10)
values(0) = Round(GetValue("VAL0_CY"))
values(1) = Round(GetValue("VAL50K_CY"))
values(2) = Round(GetValue("VAL100K_CY"))
values(3) = Round(GetValue("VAL150K_CY"))
values(4) = Round(GetValue("VAL200K_CY"))
values(5) = Round(GetValue("VAL250K_CY"))
values(6) = Round(GetValue("VAL300K_CY"))
values(7) = Round(GetValue("VAL400K_CY"))
values(8) = Round(GetValue("VAL500K_CY"))
values(9) = Round(GetValue("VAL750K_CY"))
values(10) = Round(GetValue("VAL1M_CY"))
Dim rangeValues(10,1)
rangeValues(0, 0) = 0
rangeValues(0, 1) = 50000
rangeValues(1, 0) = 50000
rangeValues(1, 1) = 100000
rangeValues(2, 0) = 100000
rangeValues(2, 1) = 150000
rangeValues(3, 0) = 150000
rangeValues(3, 1) = 200000
rangeValues(4, 0) = 200000
rangeValues(4, 1) = 250000
rangeValues(5, 0) = 250000
rangeValues(5, 1) = 300000
rangeValues(6, 0) = 300000
rangeValues(6, 1) = 400000
rangeValues(7, 0) = 400000
rangeValues(7, 1) = 500000
rangeValues(8, 0) = 500000
rangeValues(8, 1) = 750000
rangeValues(9, 0) = 750000
rangeValues(9, 1) = 1000000
rangeValues(10, 0) = 1000000
rangeValues(10, 1) = 1000002
Dim median
median = CalculateMedianLinear(values, rangeValues)
ReturnValue(median)