Show Table Totals at the Bottom of Columns

Answered

17 Comments

  • Chris Bulin
    Community Moderator

    Mine shows up at the bottom, but I have noticed that the way they phrase their sums and the way I think about them is different. If I want to sum a column, they consider that a sum of the rows in that column. So for example in the table below, the sum was on the row rather than the column and it showed at the bottom.

    0
  • Gentry Geissler
    Zendesk team member

    Thanks for the question, Graeme. In that menu for Result Manipulation > Totals, look at the bottom for Inverse totals position. This will make the sums switch from top to bottom.

     

    0
  • Graeme Carmichael
    Community Moderator

    Gentry

    Yes I have been flipping that little check box but it does nothing for me.

     

    Counts appear at the bottom but do not move when he inverse is changed.

    Chris- yes the terminology caught me as well.

    0
  • Gentry Geissler
    Zendesk team member

    Graeme,

    You have a manual sort on the Tickets column, and this will over-ride the total settings. Click the column header again until the triangle goes away and that should fix it.

    0
  • Graeme Carmichael
    Community Moderator

    Gentry

    That is very well spotted. Thank you, that has resolved it,

    However, from a design view, that makes no sense whatsoever. The sort option should not apply to the total. It should only apply to the rows. The total position should be only determined by the result manipulation. 

    0
  • Graeme Carmichael
    Community Moderator

    Gentry

    So I am going to call that a bug. 

    It is only by chance that a column sorted by value would have the the total exactly at the top or bottom. For example, if there were negative and positive values, the sum could appear in the middle.

    Similarly, if you use another aggregation, such as average, you may see this:

     

    In the above example, the average appears in the middle of the report. This is not very useful.

    Can you confirm that this is a known issue?

     

    0
  • Travis Rider
    Zendesk team member

    Hey Graeme,

    Thanks for the detailed replication steps and screenshot! I'll get this into a ticket so we can investigate further.

    0
  • fellownarrator

    Has this been addressed?  When I have an average configured, it shows up in the middle of the tables.  Please advise..

    0
  • Nicole S.
    Zendesk Community Team

    Hey fellownarrator - 

    I've reached out to Travis; he's going to see if he can dig up the ticket he had going with Graeme and let us know what's up. It might take us a few hours, but we'll get back to you. 

    0
  • Graeme Carmichael
    Community Moderator

    From my ticket, it was because I had applied a sort order to the table.

    If you look closely, you will see a sort applied with the little arrow on the column header. This sorts the entire column including the total row- which I thought a little odd. The result is the total row appears in the middle if you have averages or a mix of positive an negative numbers.

    I would expect these total or aggregate rows to stay at the top or the bottom and not be moved by a sort. But apparently that was not the case.

    Hope that helps.

    0
  • fellownarrator

    So what is the solution (how do you move the total to the bottom)?  Is this a bug basically or is there a fix?

    1
  • Nicole S.
    Zendesk Community Team

    After reviewing the ticket and talking with Graeme, it's basically just how these tables work. I'm raising it with the product team, as I agree that expected behavior should be a bit different from what it currently is.

    1
  • John Hall

    +1 Sum, Average, etc. should not be included when sorting on a column.

     

    1
  • Mihaela Dragota

    Hey. The table total sorting is not available anymore? Has anything happened to it?

    Thanks

    1
  • Mark Powell

    Yes, it looks like the "Inverse totals population" setting is not available any more?

    1
  • Mateusz S

    Can someone confirm if "Inverse totals population" option was moved somewhere or revoked?

    0
  • Sabra Funderburg
    Zendesk Customer Advocate

    Hey Mihaela Dragota, Mark Powell and Mateusz S! The "Inverse totals position" option has been removed. If this feature is something of use to you and want to see brought back, I would recommend creating a feature request post on our community. If you create a post, feel free to mention it here as well for others to find!

    0

Please sign in to leave a comment.

Powered by Zendesk