Adding Order Bys

If you are defining a data fetcher query in the Query Builder, you have the option of adding ordering.

About this task

You can order your results by a metric or numerical field.

Clicking Next from the Add Group Bys pane takes you to the Add Order Bys window where the two fields that were selected from the tables display as the column names.

To add ordering to the query results, complete the following steps:

Procedure

  1. Change the order by selecting asc or desc in the Direction drop-down list.
  2. Now scroll down to the Available Fields table.
  3. Select the field you want to order by.
  4. Click the Add button.
  5. Click Apply to see updated query results.
  6. When you have the query the way you want it, click Next to preview the query, or click the Back button to return to previous windows to modify the query.

    When you click Finish on the Preview Query pane, the Query Builder closes and you return to the original editor (Data Fetcher or ESDA rule). You can see the query you created in the SQL Query text box.