Sorting results by attribute in a table chart format
Posted Jul 29, 2019
From my comment in this article: https://support.zendesk.com/hc/en-us/articles/360022183794?page=1#comment_360002497954
I would like to sort on any table column by clicking on the header. I can do this for the metrics, but not for the row attributes when I have a table display output. Once I sort a metric, I'm stuck sorting by metric. I often write quick queries to answer questions, I don't need to build out a sort option in a report I'm going to keep running. I just want to sort on the fly - any column, attribute or metric.
Another comment in the above post suggested I set the sort order for the first attribute column in Result Manipulation > Sort. However, this only works as the default sort. Once I sort any metric column on the fly, my attribute sort is gone, can I cannot get it back unless I close my query and open it back up.
46
17 comments
Official
Eugene Orman
Thank you to Hillary Latham and everyone else for sharing your feedback here.
The ability to sort reports based on metrics makes total sense. We are currently working on the new version of the reporting experience. One of our goals is to simplify and speed up the report-building workflow. We will review this feature request and will see if sorting on metrics can be introduced with one of the upcoming releases.
I will provide an update once we will get close to working on the Sorting functionality.
0
Kristin Bouveng
I have struggled lots recently with trying to find ways to order columns, spending far too much time on trying to sort tables.
It's beyond me how Explore have so many advanced calculations and manipulations, but a simple column sorting is not possible!
6
Julien MARTELOZZO
+1.000.000
5
Trevor Kanaya
I can't express how much it boggles my mind that this basic feature of any reporting tool has failed to be added to Explore for so long. Explore has consistently been not only the poorest reporting tool, but far and away the poorest SAAS product I've ever used. Our company relies heavily on Zendesk data to make decisions both immediate and long term, and my team and I spend countless hours stuck on figuring out how to do things that should take seconds to set up in any passable software. Not to mention how often it seems that Explore is down altogether. They really should have had a lot more of this fleshed out before they forced us off of Insights, what was shipped wasn't even something I'd call an MVP, and here we are almost two years later with the same problems.
3
Louise Dissing
+1 Would be really useful!
3
Ayal Kellman
+1 for this as well
3
Reshma Patel
Agreed. Not sure why you are unable to sort on different columns, but this is must have functionality.
3
Henkka (Pepron)
This is a very important feature and used in Insights all the time.
Does this mean we're unable to for example add a Last Updated date and sort via that too?
3
bill cicchetti
Would love to see this added. Hard to explain to the users why something deemed as basic as this is not available.
2
Jake Warren
The fact that this isn't a feature today is extremely disappointing. Salesforce classic has this basic feature. It's the equivalent of adding data filter in excel. To allow for building a report in tabular format, but not being able to sort like this is maddening. This should be such an easy win for Zendesk to implement, but by the looks of it, is being ignored like most other basic misses in their functionality.
1
Joshua Bentley
Zsa Trias - unfortunately that doesn't solve the problem because I don't believe Vanessa is wanting to sort on any metric, but on an attribute. In my case, which I believe is similar, I just want to be able to sort a metric table by assignee in alphabetical order. If I set the sorting as that article suggestions, I still have to choose a metric to sort...which isn't what I want.
Having to export everything to Excel in order to manipulate the data like I want is getting tiresome.
1
Sign in to leave a comment.