Bar Chart with pre-set category
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
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 303 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 104 SQL DataFlows
- 637 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 763 Beast Mode
- 65 App Studio
- 42 Variables
- 709 Automate
- 184 Apps
- 460 APIs & Domo Developer
- 54 Workflows
- 11 DomoAI
- 39 Predict
- 16 Jupyter Workspaces
- 23 R & Python Tiles
- 401 Distribute
- 116 Domo Everywhere
- 277 Scheduled Reports
- 8 Software Integrations
- 134 Manage
- 131 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 111 Community Announcements
- 4.8K Archive