I am comparing the median list price to the median sale price of homes in a Chicago neighborhood over time. However, the data available from Redfin is incomplete; the original list price is unavailable for a minority of home sales.
How can I ask Tableau Public 7 to plot the median sale price of homes, but do so using only the sales for which the original list price is also known? Must I created a filtered data set manually in Excel?
The data can be excluded within Tableau. The best way to do this would probably be to place the values on the filter shelf and exclude Null values.
Hope this helps!