You have already selected an OpenAPI Class and build any configuration string and the class and configuration string are valid. The Query Wizard - Select Column form lets you choose which Column will be included in your Query, and which which of those columns should be used for grouping the data and which of should be used to calculate summaries.

SELECTING COLUMNS

The screen displays a List of the columns that are 'Available' for selection, and a list of columns that you have already selected.  The columns that have been already selected are divided by into two lists. The Group by list and the Summarize list.

To select a Column to group by, first highlight it by Clicking on it in the Available list, and then click on the top '>>' button to move it over to the Group by list.

To select a Column to summarize by, first highlight it by Clicking on it in the Available list, and then click on the bottom '>>' button to move it over to the Summarize list.

You can select the type of summary to be used for the highlighted Summary Column by using the Summary Type drop down list.

Depending on the data type of the highlight Summary Column different items will be available in the Summary Type drop down. For example numeric columns will have Sum, Maximum, Minimum, Average, Count, Distinct Count, First and Last but non numeric columns will only have Count, Distinct Count, First and Last.

You can also use the box immediately above the list of Available Columns to enter part of the Column name that you are wanting to Add. As you type in this box you will notice that the list of Available Columns will be filtered based on the what you have typed. This is a useful way of searching for the column you want if there is a large number of Columns in the Subject you are using for this Query.

REMOVING COLUMNS

To remove a Group Column, first highlight it by Clicking on it in the Group by list, and then click on the top '<<' button.

To remove a Summary Column, first highlight it by Clicking on it in the Summarize list, and then click on the bottom '<<' button.

SUMMARY GROUP OPTIONS

You can set Summary Group Options for the highlighted column in the Group by list by clicking on the Group Options button. More details on Summary Group Options can be found in the Summary Group Options topic here.

Once you have finished making your selections click on the 'Next >' button to move on to the Query Wizard - Finished screen.