array_sort_desc
This page explains how to use the array_sort_desc function in APL.
Use the
Run in Playground
Output
array_sort_desc function in APL to sort the elements of an array in descending order. This function is especially useful when working with numerical data or categorical data where you want to prioritize higher values first—such as showing the longest durations, highest response times, or most severe error codes at the top of an array.
You can use array_sort_desc in scenarios where ordering matters within grouped aggregations, such as collecting response times per user or span durations per trace, and then sorting them to identify the highest or most impactful values.
For users of other query languages
If you come from other query languages, this section explains how to adjust your existing queries to achieve the same results in APL.Splunk SPL users
Splunk SPL users
Splunk doesn’t have a direct equivalent to
array_sort_desc, but similar outcomes can be achieved using mvsort with a custom sort order (and sometimes reverse). In APL, array_sort_desc explicitly performs a descending sort on array elements, making it more straightforward.ANSI SQL users
ANSI SQL users
ANSI SQL does not support arrays or array functions natively. You typically use window functions or subqueries to order values. In APL, you can work with arrays directly and apply
array_sort_desc to sort them.Usage
Syntax
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| array | array | ✔️ | The input array whose elements are sorted descending. |
Returns
If the input is a valid array, the function returns a new array with its elements sorted in descending order. If the array is empty or contains incompatible types, it returns an empty array.Example
QueryList of related functions
- array_index_of: Returns the index of a value in an array. Useful after sorting to locate specific elements.
- array_length: Returns the number of elements in an array. Useful for measuring the size of arrays before or after sorting.
- array_slice: Extracts a range of elements from an array. Use it after sorting to get the top N or bottom N values.
- array_sort_asc: Sorts an array in ascending order. Use this when you want to prioritize smaller values first.