Sorting results

Return to top
Have more questions? Submit a request

23 Comments

  • Ankit B

    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.

    3
  • Jacob J Christensen
    Community Moderator

    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.

    5
  • Kelly Johnson

    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.

     

     

     

    6
  • Beth Yoder

    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
    Community Moderator

    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.

    1
  • Jenni
    Zendesk team member

    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
    Community Moderator

    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.

    5
  • Ayal Kellman

    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

    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!

    -1
  • Andy Killingsworth

    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
  • EJ Gennrich

    I'm having the same issue as others. I have a table query with "Day of Month" as the Row Attribute. I accidentally clicked on the Header of a metric in the query editor. Now I'm unable to have the table list the days of the month in order. Do I really need to remake this query from scratch? 

    0
  • Brett Bowser
    Zendesk Community Team

    Hey EJ,

    I'm going to bring this into a ticket so our Customer Advocacy team can take a look at this report for you.

    I'd be surprised if you had to create the whole query from scratch just to resort.

    You'll receive an email shortly stating your ticket has been created.

    Cheers!

    0
  • Barber

    I hope someone can help me with the sorting of my bar graph.

    I have a query which shows the number of tickets regarding a specific department but I can't get the bars in the order I want. Does anyone know how I can sort the individual bars of my bar graph by (ticket count) from least tickets at the bottom of the bar to most tickets at the top of the bar?

    This is my query and the current settings:

     

    I hope someone can help me.

    Sander

     

    0
  • The Salvation Army

    Hillary Lathum did you figure this out I am needing the same thing. Sort on the fly by clicking on the row;

     

    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.

    1
  • Tina Yates

    Katina Durrent any response?  This is critical for me and I can't seem to find anything to help.

    0
  • The Salvation Army

    Not yet. I submitted a ticket. If I can any good info I will post it here :)

    0
  • Tina Yates

    Has anyone figured out how to remove the Sort once it has been applied? thank you.

    0
  • Ali Syed

    Ankit B Found a way. Add an unnecessary metric and then sort by that new metric. Save the query, go back and then remove the unnecessary metric. You've successfully dodged Explore :)

    2
  • Ali Syed

    I was also just (luckily) able to sort the results the way I did by just renaming the labels in my custom attribute. Before I did that, after sorting the chart by attribute, I had the 48+ appearing as the first column but in terms of the series (as you can see), that didn't fit the purse. So, I just prefixed it with an alphabetic value to make it "Above 48 hrs" and then sorted it in descending order. Bingo!

    Note that I had to increase the Truncation characters limit to expose the entire string :)

    0
  • Samantha Chen

    Hi,

    I'm trying to sort a table based first on Column C and then on Column B. How would I go about trying to do this? I'm only able to sort by one column at a time. 

    Thanks!

    0
  • Gab
    Zendesk Customer Advocate

    Hi Samantha,

    You'll be able to sort the values in the table based on metric results and then by a selected attribute via the Advanced sorting option. But, if you are trying to sort the results based on two different metric columns, then I'm afraid that is not possible. Sorry about this, Samantha. You may only be able to sort the values based on one metric at a time.

    Thanks!

    0
  • Martin Garcia

    I was wondering if there was any way to sort my results by Ticket ID or date created?
    Seems like the only sorting option I have is to sort the "COUNT(Tickets)" but never anything else.
    I am trying to order these by descending whether its the date they were created or the Ticket ID itself but nothing seems to work. Is there a work around for this? I can't really do anything from the "Sort" section since there really isn't much that this is counting.

    0
  • Martin Garcia

    Quick little update for everyone. I was able to work around the date issue with a metric that adds the days since the ticket was created.
    Then sorting that by "descending"
    Hope this helps someone!

    0

Please sign in to leave a comment.

Powered by Zendesk