count states in rows
Have a series of rows of orders for different states ex.
order state
1 CA
2 CO
3 CA
4 MT
i.e. the count for CA would be 2 and CO, and MT would be one, assuming would need to do sometime of grouping? But how do I display the count total on the card?
thanks
Comments
-
You may have already found the answer, but it sounds like you need to update the [Group By] action so that in step 1, you ONLY select the state field. The aggregation could COUNT any of the other fields that is never blank. The result will only have one row per state, the state name and count of rows.
Then you can [Join Data] matching on the state name to get the count back into the granular data... if you want that.
There are ways to get this at the card level too so you are not stuck with the count from the dataflow. It is a good rule of thumb to do aggregations as late in the process as possible:
> Data System > Data Import to Domo > Data Flow > Card Calculations
If you do this COUNT in the card it will adjust and recalculate based on user interactions, filters, etc... By doing it in the dataflow you are stuck with the result the dataflow calculates.
**Say "Thanks" by clicking the "heart" in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"0 -
believe we got this fixed...thanks
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 623 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 60 App Studio
- 41 Variables
- 690 Automate
- 177 Apps
- 455 APIs & Domo Developer
- 48 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 397 Distribute
- 114 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 127 Manage
- 124 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive