If your dashboard contains a filter for subdivision, you may notice that not all the subdivision names are included. This usually stems from the fact that there can be THOUSANDS of subdivision names in the MLS. Often times, the field that captures the subdivision is a free text field rather than a picklist. This means that one person can enter 'Rolling Meadows' and another person can enter 'Rolling Medows', and the system has no way of knowing that one of them is misspelled. Or maybe someone enters it without a space between the words. You can see where this is going. Basically, the variability of the data in that field makes it not a great source of data. But we have to use it.
In addition to not wanting to force users to dig through and select multiple different versions of the same name to get relevant statistics, there is another consideration. To quote Top Gun, we have a need, a need for speed. Imagine you're trying to run stats for an area, and the chart takes 15 or 20 seconds to load. You'd probably stop using the dashboard right then and there. The negative impact to the user experience isn't worth exposing a massive list of somewhat messy data so that every single subdivision can be represented. So we limit the number of values in the list to increase the overall speed. Generally speaking, we look across the entire data set and count how many listings are in each unique subdivision. Then we'll pick a cutoff point where we group all the smaller subdivisions into something creative like "Other Subdivision." This is recalculated nightly, so as more listings are added, subdivisions on the cusp will make their way into the enumerated list.
Obviously one downside to this is that new subdivisions will take a while to make their way into the stats. In some cases, the MLS will request that certain subdivisions are added even though they don't reach the required number of listings. Yes, we can do that. So if you have special needs, contact your MLS and make your case. If they agree with you, they'll send us the request for implementation.
Related Articles
Default values on Pricing Insights
Recently, someone asked how the default values on Pricing Insights were determined. They were referring to these boxes at the top of the dashboard. When the dashboard first loads, a median sold price is calculated based on the selected filter ...
The hierarchy of geography filters
When you think about market stats, geography is one of the first things that comes to mind. Depending on the dashboard you're using, you may have one or more geography filters. If there is more than one, then those filters work slightly different ...
The difference between Median Price and Average Price
Median Price and Average Price are commonly reported metrics in the real estate market, but they are very different. Let’s step back to college statistics class to revisit them both, and learn why Median is preferred for housing prices. Average: the ...
Dollars per acre for Land property types
If your dashboards contain Land as a property type, then there will be metrics called "Sold Price per Acre" ( or $/Acre). To view this metric, you must choose Land, and only Land, from the Property filter. On the Infographic and Market Review ...
Is it a Buyer's or a Seller's market?
This is a common question, and one that can definitely be answered with statistics. To quickly get to an answer, we recommend using the Market Review dashboard, because it gives you a single page view of several metrics at once, with a short history ...