grouped bar from extracted text
All,
I Have data in a column that looks like this:
California, Nevada
Nevada
New Mexico
Colorado, New Mexico, Nevada
New Mexico, Florida
etc.....
The column might have just one name or as many a 6 different state names separated by commas, not in any specific order.
I want to make a Grouped Bar card that will count the total for each state if it exists ANYWHERE in that string. (LIKE statement????)
Then display grouped bar with count for each state.
Help please...?
Tim
Comments
-
Hi @tstimple
There's two options you have. The first is to create 50 beast modes one for each state using a like statement which is not ideal and a nightmare to maintain.
The better option is to preprocess your data and split out so you have one record for each state. You can utilize a split column tile to split each state based on a specific delimiter and then utilize a pivot tile to translate the states to a single column.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 602 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 693 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 386 Distribute
- 111 Domo Everywhere
- 269 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 8 Domo University
- 30 Product Releases
- Community Forums
- 39 Getting Started
- 29 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive