can you provide some sample data values ?
are you converting it to Months,days,hours and minutes eventually in the query?
if you are converting then do a
sort before conversion.
refer this documentation for sort command:
Let me know if this helps!
If you are displaying this data in a dashboard and want to display the duration field as you've currently formatted it but sort based on the numeric duration values, I would recommend an approach that uses
fieldformat to display the values while maintaining the actual values in numeric format. Here's a link to another answer that uses this approach to display data with one set of formatting while sorting based on another:
So the general approach will be to have a field called, say,
average_duration that contains a numeric value representing the total number of seconds in the duration. (Or, if your data is only granular to the minute, then the total number of minutes is also fine.) Separately, you'll have a field called
display_duration that will be formatted to match your desired display format. At the end of your search string, you'll add:
| sort - average_duration | fieldformat average_duration=display_duration
Or if you wanted to sort the values in an ascending order, that would be:
| sort average_duration | fieldformat average_duration=display_duration
And then in the XML formatting for the table you are displaying, you'll use the
<fields> tag to specifically indicate which fields you want to display. Presumably, this would be a list of all the fields you are currently displaying - and specifically, not the field
Here's some more info about
And here is some useful info about the spec of a simpleXML dashboard, specifically about the options you can put within a table: