Annotation (Task 14): Hover over any neighbourhood circle to inspect Calculated Host Listings Count, LOD Price Difference, Total Revenue, and Occupancy Rate.
Annotation (Task 14): Click a bar or filter pill to trigger Task 15 Filter Action & Task 16 Highlight Action across all worksheets.
Annotation (Task 14): Tracks mean listing Price across Reviews Per Month frequency cohorts by Neighbourhood Group.
Formula: IF [Room Type] = "Entire home/apt" THEN "Entire Home/Apt" ELSEIF [Room Type] = "Private room" THEN "Private Room" ELSE "Shared Room" END
| Neighbourhood Group | Room Category (Hierarchy) | Listings | Avg Price | Avg Price / Night |
|---|