Grouping by substring selected in a beastmode
Hello,
I'm looking to group by the left two (or more, depending on where I'll end up going) characters of a column. I made a calculated field of left(`from`,2) that gives me the first 2 characters, but I can't group by this value. I have a LOT of possibilities in the from field, so I can't create the hundreds and hundreds of specific cases. I'd like to do this at the card level rather than ETL, but I would just have done a group by `from` statement in SQL to get the expected result.
Here's an image of my table to give you an idea:
Thanks!
Comments
-
Can anyone help with this request?
0 -
It would be nice to group by in beastmode to get this functionality. I wonder if there is a workaround...
0 -
You're in the table card, so the way you effectively GROUP BY is by selecting your aggregation level on the measure column. Every other dimension column is assumed to be part of the GROUP BY clause and your measure will be summed, counted, maxed, or whatever.
You'll just have to take out of the visualization any column you don't want to group by in the aggregation.
If that suggestion isn't on target, maybe mock up an example of what you're hoping to get, and post that up here.
Aaron
MajorDomo @ Merit Medical
**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
Categories
- All Categories
- 1.2K Product Ideas
- 1.2K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 527 Datasets
- 2.1K Magic ETL
- 3K Visualize
- 2.2K Charting
- 443 Beast Mode
- 23 Variables
- 514 Automate
- 115 Apps
- 391 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 67 Manage
- 67 Governance & Security
- 1 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive