Org Hierarchy and Sunburst Chart Limitations
I'm working on a Sunburst Chart to show organizational hierarchy. I'm running into some issues where I've got 3 levels to my hierarchy and I'm only able show 1 of these without the visual disappearing. I've attached the sample data I'm working with and here is the setup on the card:
Is this chart just not capable of handling null values or blank fields? If so, what are my options?
Would also love to know if anyone has any other suggestions on how to present org hierarchies with drill down capabilities.
Best Answer
-
The card wouldn't work with no value shown on that level of the sunburst. Logically there needs to be something there if there is an additional level. So for CEO you could have a repeated value of CEO, or N/A which makes sense because Level 2 doesn't apply to the CEO. It's just a limitation of the chart type. You could create a hierachy using some other tool and then add it to domo as a DDX brick.
If I solved your problem, please select "yes" above
0
Answers
-
It can't handle nulls. For your next level just create a beastmode:
IFNULL(`Level2`,'N/A')If I solved your problem, please select "yes" above
0 -
Right but then I have a value of N/A on my chart that I can't get rid of without filtering out those rows.
0 -
The card wouldn't work with no value shown on that level of the sunburst. Logically there needs to be something there if there is an additional level. So for CEO you could have a repeated value of CEO, or N/A which makes sense because Level 2 doesn't apply to the CEO. It's just a limitation of the chart type. You could create a hierachy using some other tool and then add it to domo as a DDX brick.
If I solved your problem, please select "yes" above
0
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
- 691 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
- 112 Manage
- 109 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