'Tableau: I need to bin Airbnb hosts into bins by the number of listings they have
I have Airbnb listings data from Austin, TX. Each row includes host name, host ID#, unique listing ID, and a column for total host listings (I'm not sure I trust this, because it may include other listings outside of Austin).
I want to create a simple histogram that counts the number of hosts with x listings, with x being bins with sizes of 10. If I want to ignore the column for total host listings and focus on calculating the number of listings per host ID#, and then bin accordingly, I'm guessing I need a calculated field?
Data example:
| Host ID | Host Name | Listing ID | Total Host Listings |
|---|---|---|---|
| 666 | Sally | 7238 | 17 |
| 246 | Jim | 3497 | 2 |
This may be enough of an example to get the situation. I know in Python a simple groupby would accomplish most of what I need, but this project lives completely inside Tableau.
Thank you.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|