Bar Chart with pre-set category
Options
I have data in the following format:
Person | Starting Point | Current Point |
John | Unit 1 | Unit 4 |
Jane | Unit 2 | Unit 5 |
Joe | Unit 1 | Unit 3 |
Sue | Unit 4 | Unit 8 |
I would like to create a bar chart showing all the units (50 of them) with the number of people who started in each unit and how many are currently in each unit. There will be some units with no one in them, but they need to appear anyway. I've gone around and around on how to do this and am not getting anywhere.
0
Comments
-
restructure your data. such that your columns are
Activity Type, User, Unit, rowCount
Current, John, Unit 1 , 1
Start , Jonn , Unit 4, 1
Current, Jane, Unit 3, 1
Start, Jane , Unit 2, 1
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 666 Datasets
- 120 SQL DataFlows
- 2.3K Magic ETL
- 827 Beast Mode
- Visualize
- 2.6K Charting
- 90 App Studio
- 46 Variables
- Automate
- 198 Apps
- 489 APIs & Domo Developer
- 98 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 118 Domo Everywhere
- 284 Scheduled Reports
- 11 Software Integrations
- Manage
- 145 Governance & Security
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 117 Community Announcements
- 5K Archive