I need a function/correlationfactor of the three variables/dimension which show the change of the Median (price) while the three dimensions (pers_capacity, amount of bedrooms, amount of bathrooms) grow. e.g. Y(#pers_capacity,bedroom,bathroom) = ..
note:
- in the screenshot are not all the data available (just a part of it)
- median => price per night
e.g. For 7 persons, 3 bedrooms and 2 bathroom is the median price 249$ per night
Do you have some ideas how I can calculate the correlation/equation (f(..)=...) in order to get a reliable factor? How is it doable on tableau? => I have 3 x-variable (person_cap, bathroom, bedroom) and 1 y-variable (median price).
Kind regards
Hi Mia,
As per my understanding it is possible in Tableau through calculated fields. You just need to add the formula for calculating the median price.
Best
Shriram Saxena