How to hide target in Bullet Chart

user030230
user030230
in Connectors

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).

Capture.JPG

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
    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:

    Capture.JPG


Answers

  • GrantSmith
    GrantSmith Coach
    edited April 2021

    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!**
  • user030230
    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

    Capture.JPG


Categories