How to hide target in Bullet Chart
I want to create a chart that displays the percentage of opportunities that have closed. I created a Beast Mode that displays a 1 if the Opp has closed and a 0 if it hasn't closed. I then threw it into a bullet chart, categorized by Lead Source. This is all well and good, but I don't want the target value to be visible (see below).
As you can see, the actual bar part of the chart is pretty small, and the target value is useless to me. Can I get rid of the target while maintaining the correct percentages? Do I need to use a different graph for this?
Best Answer
-
I've solved it, I simply needed to put the Lead Source on the y-axis with the Beast Mode Grant mentioned above on the x-axis. No series needed, and here's my output:
0
Answers
-
Have you tried using a beast mode to calculate your percentage instead of just if it's a 1 or 0?
SUM(CASE WHEN [logic for is closed] THEN 1 ELSE 0 END) / SUM(1)
Use that in a horizontal bar chart as the display text but the closed opportunity count as your x value. Make sure you use your Lead Source as the series.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
If my x-axis is the number of Closed Opps, what would my y-axis be? I made the Beast Mode but I'm not sure how it fits into my graph. I want something like this, where the blue portion is completely gone, leaving just the green bars with their respective percentages
0 -
I've solved it, I simply needed to put the Lead Source on the y-axis with the Beast Mode Grant mentioned above on the x-axis. No series needed, and here's my output:
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive