Requirement: Make the Z-Score to outliers of average price by room type.
The solutions shows below:
After this , please remember to right click Z-Score from the card and edit the table calculation. Tick Borough and untick Room Type for both Window stdev and Window avg price from Nested Calculation. You will see the figure below:
Hopefully, this blog is useful:)