Totals on top of a stacked cartesian?

Krisztina Zappert
Krisztina Zappert Active Partner
Second Anniversary 25 Likes 25 Up Votes 10 Comments
edited March 2023 in Platform

Hi,

Our customer would like to see the totals on top of the bars of their cartesian charts. How can I show this for them?

Thank you,
Krisztina

image.png

Accepted Answer

  • Thomas Kreis
    Thomas Kreis Employee
    Fourth Anniversary 25 Up Votes Level 100: Foundations of Building in Board Level 200: Building A Planning Solution in Board
    edited April 2023 Answer ✓

    Hi Krisztina,

    from what I've understood is, that you just want the Total Value on Top of a Chart stacked by its Series.

    So here is a possibly simple solution:

    You just put the TOTAL Series to invisible, activate the labels and it looks like this. The invisible stacked Total is invisible on top but still the marker shows the Total Value:

    image.png

    image.png

    Another Idea is, to put the invisible TOTAL Series on the Second Axis, hide the second axis and you have the total Value next to the stacked bar:

    image.png

    Hope this helps

    Best regards

    Thomas

Answers

  • Willians Santana
    Willians Santana Employee
    Second Anniversary 5 Answers 10 Comments Level 100: Foundations of Building in Board

    Hi, @Krisztina Zappert,

    How are you doing? I hope you are having a great day!

    Could this option help in this process?

    Set the chart combination mode to "Cluster" within the "SERIES" section of the chart properties.

    image.png

    Please, let me know about the results.

    I am all ears for you.

  • Krisztina Zappert
    Krisztina Zappert Active Partner
    Second Anniversary 25 Likes 25 Up Votes 10 Comments

    Hi,

    Thank you for the recommendation!

    Unfortunately, the clients would like to have the stacked combination mode. Furthermore, the cluster mode doesn't really show the totals on top, either.

    image.png

    The values I am censoring in this chart are the same values I was censoring in the previous screenshot, which are the individual values for the items. The totals for each section in the X axis is missing from this view, as well.

    It is possible to add "Row totals" and then one more bar appears, but reading this chart is not as intuitive as just having the total on top would be. It also reduces the sizes of the bars for the infividual sections.

    image.png

    Our customer is hoping to have a stacked chart, and the total displayed in the chart. Is this currently possible?

  • Valentina Sarti
    Valentina Sarti Employee
    Fourth Anniversary Level 100: Foundations of Building in Board Level 200: Building A Planning Solution in Board 5 Likes
    edited April 2023

    Hi Krisztina Zappert,

    have you tried with the Series Type "Bar" and the Combine mode "Stack"?

    I don't know which is the configuration of the layout you're showing us, but in the following case, for example, the cube is detailed by Planning Unit and the labels are showing the values by planning units and in yellow you can see the Total:

    image.png

    If you have not a situation where the Detail by is applicable, you can think to add an algorithm that is summing up the previous cubes and showing the Total (in green):

    image.png

    Hope it is useful for you.

    Valentina

  • Krisztina Zappert
    Krisztina Zappert Active Partner
    Second Anniversary 25 Likes 25 Up Votes 10 Comments

    Hi,

    I believe Thomas's idea with the invisible totals does exactly what we want it to do!

    image.png

    Thank you kindly for all the prompt and detailed help! I have learned a lot today!

  • Holly Rieke
    Holly Rieke Employee
    100 Comments 100 Likes Second Anniversary New Community Member
    admin

    @Krisztina Zappert If you'd like, you can indicate the 'best answer' to your question by selecting 'Yes' under the response to the question 'Did this answer the question?' This helps others identify the best answer as well!

Categories