How to hide target in Bullet Chart

user030230 · 2021-04-01T16:09:47+00:00

There was an error rendering this rich post.

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?

Find more posts tagged with

Charting

Accepted answers

user030230

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:

All comments

GrantSmith

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.

user030230

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

user030230

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: