Recommendation for best way to create this visualization

Golfoholic
⚪️
I have 2 columns 'years old when moved in' and 'Length of stay in Days' What I am looking to do is create a card (histogram?) that will take the ages and put them in buckets then show an average length of stay in days for each of those buckets. I already used the histogram to show the distribution of ages as a count, and it went smooth. Now trying to add this second layer to it has left me scratching my head.
Tagged:
0
Comments
-
You can utilize a beast mode to defined the different buckets and then drop your length column into your chart and use the average aggregate on it.
CASE WHEN `Years old when moved in` >= 70 THEN '70+' WHEN `Years old when moved in` >= 70 THEN '60' WHEN `Years old when moved in` >= 70 THEN '50' WHEN `Years old when moved in` >= 70 THEN '40' ELSE '<30' END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 38 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 258 Domo Best Practices
- 11 Domo Certification
- 464 Domo Developer
- 50 Domo Everywhere
- 104 Apps
- 714 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 26 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 653 ひらめき共有