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

PJG · April 16

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 · April 16

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 · April 16

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 · April 16

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 · April 17

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 · April 18

Hi David, perfect, thank you!

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

Comments

Categories