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!

Charting

Charting

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

Welcome!

Comments

Welcome!

Welcome!

Quick Links

Categories