Sort table rows by metric while preserving row hierarchy



  • RJ Hines

    Good morning Owen,

    Unfortunately, I'm fairly certain (after trying for a long time myself) that Explore only allows for a single 'sort' option at a time on any given query.

    I re-created your example above using some data of my own. Sorting by value gives the highest total for the metric and 2nd attribute, but breaks up the 1st attribute:

    However, sorting Z-A just reverses the order of the attribute, regardless of the value. The Custom Sort options only offer options between these two, nothing more refined on either end.

    I'm fairly certain you may have already tried it, but I was able to create a similar result close to what you are looking for by making the 2nd attribute a Column instead of a Row and using Sort - Value Descending:

    Its not as clean as the visual you demonstrated above, but with Zendesk's current limitations it may be the closest you can get. If you have too many variables in the 2nd attribute, you could potentially consider making a new Group from the 2nd attribute and narrowing it down to having 1-2 overall variables.

  • Owen Greenberg

    Thanks RJ. I came to the same conclusion on my side, but wanted to be sure before I submitted a feedback post. Unfortunately, in this case, my Attribute 2 values are different depending on what Attribute 1 is because it's a dropdown hierarchy, so putting it in columns like that wouldn't help me. It's definitely a good idea, though.

    I'm going to leave this open for a while in case anyone else has any input before I put in the feedback post, just in case there's any official response or other ideas.

  • Matt
    Zendesk Customer Care

    Hi Owen! Unfortunately, you are correct in that you cannot sort with a hierarchy dependent filter of two attributes. You are welcome to submit that for product feedback for others to vote on and be considered.



Please sign in to leave a comment.

Powered by Zendesk