Count amount of dates in a row

I have two fields in a table, ‘DateOfStay’ and ‘Market’. ‘Market’ is representative of an airport and its nearby hotels. I’m trying to calculate how many individuals are staying at a market on a specific day (DateOfStay). Any insight on how I can approach/achieve this?
E.x. On 2022-03-01, 3 people were staying at a hotel near DTW
Data:
DateOfStay Market
2022-03-01 DTW
2022-03-01 DTW
2022-03-01 DEN
2022-03-01 LAX
2022-03-01 DTW
2022-03-01 SLC
2022-03-01 SLC
2022-03-01 LAX
2022-03-02 DTW
2022-03-02 DTW
Thank you!
Comments
-
It depends how you want to display the data, but at a basic level if you used a table card, drag in date of stay and market, then drag in market again and change the aggregation type to count. This would show you how many people stayed at each market on each day.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.2 -
Hi @DataLawton -
@MarkSnodgrass is spot on. It really depends on what chart type you are using. If you need more help, please let us know what chart you want to display the info in and we may be able to provide some detailed screenshots.
1
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 666 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 873 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 145 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive