Sorting results

Have more questions? Submit a request

10 Comments

  • Ankit B
    Comment actions Permalink

    Is there a trick to reset the sort options? In the advanced option, I am unable to remove sort on metric from the sorting options.

    2
  • Jacob J Christensen
    Comment actions Permalink

    I wondered the same as Ankit ^

    Couldn't find any way to deselect the metric, had to construct the report from scratch to be able to sort on attribute instead of metric.

    I expected to then be able to sort my column chart by date attribute, but that doesn't seem to work (see below).

    What I really want to do is get a plain chronological sorting of columns by Day of Week (and abbreviate the name of the day), on my planet the week starts on Monday - if I could set that right somewhere it would probably save me a lot of grief.

    2
  • Kelly Johnson
    Comment actions Permalink

    I'm having the same issue as Jacob^

    I want to be able to sort my table by create date showing the most recent first.  The only thing I am able to sort on is the metric.

     

     

     

    2
  • Beth Yoder
    Comment actions Permalink

    I think you can sort, using the order by clause under sql options, but my sql skills are not strong enough to do it yet. I will update the post if I figure it out. 

    0
  • Chris Bulin
    Comment actions Permalink

    I'm also trying to do the same thing Jacob is. I want my team to be able to see how much they have improved by putting the most recent info at the top rather than having to scroll to get to the good stuff.

    0
  • Jenni K.
    Comment actions Permalink

    Hi Jacob and all! 

    So there is a way to sort some attributes by using the data structure, and creating an ordered set--for example, if you are using "Day of Week" as your column, you can use the Data Structure option to the right hand toolbar and select the Day of Week attribute you're sorting (Ticket Created - Day of Week) for instance, and then you can drag and drop those values to sort them as you see fit. I've included a screenshot below of that option.

    However, I admit that with the Date option it gets a bit trickier, since there would be so many values listed you couldn't do the data structure option listed above. With the Date attributes, you can have the most recent option appear by using the sort option and not selecting a metric, just simply changing the attribute in the sorting option to be "On Columns" and select the Date attribute there. 

    Jacob what you have in your screenshot should function as an option normally, so if you are still experiencing that issue with sorting with those settings please send us an email at support@zendesk.com and we can further investigate your query!

    0
  • Hillary Latham
    Comment actions Permalink

    Why can't I just 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, now I'm stuck sorting by metric.   I'm just writing 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.

    0
  • Ayal Kellman
    Comment actions Permalink

    I'm not sure if this is a sort related question or not...

    I have a line chart tracking the number of tickets by our "Feedback Type" week by week. My issue is that we have 17 options for "Feedback Type" and there is no easy way (that I could find) to identify which line is which. 

    The reason I'm asking here is because one way to achieve what I'm looking for -  I think -  is that the list of rows to the right be sorted by sum or count of tickets? 

    Is there a different way to better identify which line is which "Feedback Type"?

    Screenshot: 

    Thanks!

    0
  • Andy Killingsworth
    Comment actions Permalink

    Hi, Hillary!

    Thanks for following up with us and providing that use case. Unfortunately, we don't have sorting option that works on the fly at the moment. You could always build a query, list an attribute as the first column on a query and set a Sort that works for you:
    That being said, this does require some custom query work, as opposed to being readily available on the dashboard. I took a look through our Explore product feedback forum and haven't seen any suggestions matching yours, so I suggest adding a post there with your use case and any detailed examples you care to provide.

    Our team regularly reviews that forum and updates our development roadmap accordingly. 

    Thanks!

    0
  • Andy Killingsworth
    Comment actions Permalink

    Hey, Ayal!

    Thanks for bringing this issue with sorting/viewing your query to our attention. This sounds like it's a bit outside the scope of this thread, so I'm creating a ticket for us to continue this conversation. I'll reach out with more information shortly. 

    Thanks!

    1

Please sign in to leave a comment.

Powered by Zendesk