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?

Tagged:

Best Answer

  • user030230
    user030230 ⚪️
    Accepted 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:


Answers

  • GrantSmith
    GrantSmith Indiana 🔴
    edited April 1

    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.

  • 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