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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 657 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive