Sorting results

Return to top
Have more questions? Submit a request

13 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.

    2
  • Jacob J Christensen - Cloudhuset A/S
    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.

    3
  • 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.

     

     

     

    4
  • 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.

    0
  • Jenni

    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.

    1
  • 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!

    0
  • 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 - Community Manager
    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

Please sign in to leave a comment.

Powered by Zendesk