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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 203 Visualize
- 255 Beast Mode
- 2.1K Charting
- 12 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 181 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive