Reverse chronological results with group by queries with hour granularity

I will appreciate any help with the following question on using group by queries.

I want to use the group by query to group results with specific dimensions with an hour granularity and get the results back in reverse chronological order (latest first) sorted by the __time dimension. I haven’t been able to find a way to do this. The results come back in chronological order.

As a side note the “all” granularity does support reverse chronological order. But I couldn’t get this to work for the “hour” granularity.

Here is my query with hour granularity.

{

“queryType”: “groupBy”,

“dataSource”: “test_v1”,

“granularity”: “hour”,

“dimensions”: [

{

  "type": "extraction",

  "dimension": "__time",

  "outputName": "timestamp",

  "extractionFn" : {

    "type" : "timeFormat",

    "format" : "yyyy-MM-dd'T'HH':00:00Z",

    "timeZone" : "Etc/UTC",

    "locale" : "en"

  }

},

"key"

],

“limitSpec”: {

"type": "default",

"limit": 200,

"columns": [

  {

    "dimension": "timestamp",

    "direction": "descending"

  },

  {

    "dimension": "key",

    "direction": "descending"

  }

]

},

“filter”: {

"type": "and",

"fields": [

  { "type": "selector", "dimension": "name", "value": "name-test1" }

]

},

“intervals”: [ “2018-08-22T00:00:00.000Z/2018-08-28T00:00:00.000Z” ]

}

thanks,

rahul