9 Replies Latest reply on Apr 17, 2018 5:55 AM by sudheer.kumar.5

# Show a sum of values in a bar chart

Good morning, everybody.

I would like to show a sum of 3 percentage values in the end of the bars per each resource (please see picture below).

I'm struggling with a calculated field or with a formula within "Marks" box, but unsuccessfully.

Is there a way to perform that ?

Kind Regards

Michele Lo Giacco

• ###### 1. Re: Show a sum of values in a bar chart

Hello Michele,

Something like below?

Regards,

Sudheer

• ###### 2. Re: Show a sum of values in a bar chart

Hello, Sudheer.

Yes, exactly what you have in your Tableau report.

How could it be run ?

Kind Regards

Michele

• ###### 3. Re: Show a sum of values in a bar chart

Hello Michele,

Attaching the .twbx file. Please check.

Regards,

Sudheer

• ###### 4. Re: Show a sum of values in a bar chart

Hi, Sudheer.

Very kind of you.

I tried to figure out how you did it and replicate, but unsuccessfully.

Maybe it could be better, if I send you my report.

Problem is that, when I save it as .twbx, it remains protected by a SSO password.

Is there a way to get rid of it ?

Kind Regards

Michele

• ###### 5. Re: Show a sum of values in a bar chart

Hello Michele,

Not sure to what extent I can explain. But, let me try. Detailed steps are as follows:

1. Drag the AGG(Q1) to column shelf two times.

2. Right-click on the Second measure axis and select Dual Axis.

3. And again Right-click on the Second measure axis and select Syncronize Axis.

4. Select the All in marks shelf and change the Mark Type to Bar.

5. Select the second measure and then select the Mark Type to Gantt Bar.

6. Then click on the Show Mark Labels from the Tool Bar.

I am assuming that the values are already aggregated to %. If not, please select the Quick Table Calculation and select Percentage of Total.

Regards,

Sudheer

2 of 2 people found this helpful
• ###### 6. Re: Show a sum of values in a bar chart

Hi, Sudheer.

It works !

Thank you so much for your patience and clarity !

Have a nice day !

Kind Regards

Michele

• ###### 7. Re: Show a sum of values in a bar chart

Regards,

Sudheer

• ###### 8. Re: Show a sum of values in a bar chart

Hi, Sudheer.

I just did it.

Please check if I did it right.

It is the first time for me in this forum.

Thanks again.

Kind Regards

Michele

• ###### 9. Re: Show a sum of values in a bar chart

Hello Michele,

You did it correctly!

Happy Tableauing

Regards,

Sudheer