| Suite | Professional, Enterprise, or Enterprise Plus |
| Support with | Explore Professional or Enterprise |
When you add data to your report, the results are displayed in the original order of the defining attribute. The order is usually alphabetical, by date, or the specified order of an ordered set (see Creating sets).
This article contains the following sections:
Sorting results using result manipulation
You can edit how your results are sorted in the Sort section of the result
manipulation menu (
). The following are the available sorting options:
- Alphabetical: A-Z or Z-A.
- Numeric: Value ascending (low to high) or Value descending (high to low).
- Advanced
The Advanced option enables you to set the following parameters:
- Sort on metric selects a specific metric to sort by.
- In the order selects whether the metric is ordered by ascending or descending results.
- On calculates the sorting on Rows, Columns, or a selected attribute.
- Aggregate values sorts based on the total of results, not the first result. This option is useful for metrics that are split out over time.
- Sort totals includes totals/subtotals in the sort.
Sorting results in tables
When you generate your report as a table (see Working with tables), you can sort your results by clicking the table header of any metric you added to the report. Clicking the table header of a metric sorts in the following order:
- On the first click, the column is sorted in ascending order for that metric.
- On the second click, the column is sorted in descending order for that metric.
- On the third click, the column returns to the original sort order.
28 comments
Iamberg Souza
Não é possível classificar atributos de coluna ao invés de métricas?
0
Salim Cheurfi
Je vais ouvrir un ticket pour vous afin que nous puissions voir ça ensemble et que je puisse analyser votre rapport.
Vous allez recevoir un email de la part du support Zendesk avec un numéro de ticket très prochainement.
Merci d'avance pour votre patience. Bonne journée
0
Bruno MOUTEL
Bonjour,
cela ne fonctionne pas quand il y a plusieurs colonnes malgré le fait de cocher valeurs agrégées.
Exemple en image :
pourriez-vous me dire si bug car l'option est bien active :
Bonne journée
0
Zsa Trias
Hello Colin,
Based on the behavior you mentioned, you must be clicking the name of an attribute in the header instead of a metric. As mentioned in this article:
You may want to look into the available sorting options from the result manipulation menu.
0
Colin Hutzan
I click to sort but all that happens is the column header editor comes up where I can change the name of the header. It doesn't sort. Help.
0
Hiedi Kysther
Hi Bobby Watton
One way of sorting your metrics is by using Result Path Calculations, for reference: Using result path calculations. For example:
Although I understand it can be a case-to-case basis depending on the report you are working on, so if you'd like it to be more precise, I suggest reaching out to one of the contact options here, Zendesk Customer Support. Our Explore experts will be more than happy to assist you!
I hope this helps!
0
Permanently deleted user
Cheeny Aban can you post a public reply to Jake's problem? I too have unsorted metrics columns but cannot find any way to induce Explore to sort by my date column.
0
Nicole Villeneuve
Is there a way to sort columns by reverse chronological order? I have a table with a column for each week, but want to display the most recent weeks first. I'm not seeing a readily-available way to do that.
See screenshot: I want to reverse the weeks so that most recent comes first.
0
Cheeny Aban
We have created a ticket for you and one of our members from Advocacy will reach out to you via email to further discuss your inquiry with regard to sorting results
0
Jake Warren
Hey Erin O'Callaghan,
You'd think that, but when I try to toggle through the different sorting of that column to make sure it's not sorting ascending/descending, I'm never able to get what I need (sorting by Ticket Created - Month). See below screenshots for descending, then ascending, followed by no sorting on that column at all (which shows the same sorting as ascending).
0
Sign in to leave a comment.