Can the Bar Total Label be the Total % of the bar instead of the integer?

PJG

Example, I have this chart below, and when I turn on Data Label Settings > Show Total Label, there does not seem to be any options; it just defaults to showing the total of the raw numbers. However, I want to show the total % of each bar at the top, i.e. I want the blue Build bar to total 69.4% and the yellow Run bar 30.61%. Is there a way to show those two numbers above the bars instead of what we see below?

Thanks!

DavidChurchman

You need to write a BeastMode for your Y-axis to format it all as percentages. It will probably be something like:

sum(Aloc..)/Sum(SUM(Aloc..) FIXED())

DavidChurchman

I think instead of bringing in the total and selecting the 'percent_of_total' label, you'd need to calculate the percent of total first, and use that as the value. Then your totals would appear correctly.

Data_Devon

Hi PJG,

Do you need the series data included? Does "Build" need to include 'Enhancements' and 'Projects'? Does "Run" need to include 'Support', 'Business Partnering', and 'Internal IT Time'?

If not, then you can just use a Data Label Text of Percent of total like so:

PJG

Hi Devon, yes, I do need the series included, and I added some Beast Mode to specifically show that. For the X Axis, I use this code:

case 

  when `PPM Number_p` LIKE '%PPM%' then 'Build'

  when `PPM Number_p` LIKE '%SCPX%' then 'Build'

  when `PPM Number_p` LIKE '%INFRA%' then 'Build'

  when `PPM Number_p` = 'IT00001' then 'Build'

  else 'Run' 

end

For the series, I use this code:

case

    when `PPM Number_p` <> 'IT00022' then 

        case

            when `PPM Number_p` LIKE '%PPM%' then 'Projects'

            when `PPM Number_p` LIKE '%SCPX%' then 'Enhancements'

            when `PPM Number_p` LIKE '%INFRA%' then 'Enhancements'

            when `PPM Number_p` = 'IT00001' then 'Enhancements'

            when `PPM Number_p` = 'IT00011' then 'Business Partnering'

            when `PPM Number_p` = 'IT00006' then 'Support'

            else 'Internal IT Time'

        end

    else 'Absence'

end

Then I filter out Absence.

Hi David, where do I do that? I have this option, but it's not letting me point to any specific value; it's just checked or unchecked.

DavidChurchman

You need to write a BeastMode for your Y-axis to format it all as percentages. It will probably be something like:

sum(Aloc..)/Sum(SUM(Aloc..) FIXED())

PJG

Hi David, perfect, thank you!