ACE Analytics Selecting Data

The first thing you need to do is select the data that you'll be working with:

Select some data to work with, as shown above. The data source tables and views available to you have been determined by the application developer. If multiple datasets have been made available, you will have to select a data source, then tables or views.

The columns available for each table or view will appear in a tooltip to help you identify the one you want. Notice that we changed the title of this analysis.

When you select a data source table or view, the page will immediately change to include all of its columns in a ACE Analytics table. You can limit the columns to be included to just those you need by unchecking the (All) box and using their checkboxes, as shown above. Click Apply Column Selection to refresh the ACE Analytics table after you add or remove columns.

Your ACE Analytics application may have been configured so that you do not need to select columns. In that case, the checkboxes shown above for column selection will not be displayed and all columns will be available by default.

You can add more data, using a join, if desired. The joins available to you, like the tables, have been determined by the application developer. In the example above, a join has been selected and new columns have been added to the table. Note the blue and red color-coding at the top of the data selectors and the table columns, indicating where the columns came from.

What's a "join"? A join combines two sets of data to produce a single dataset. Different types of joins produce different results. One type simply combines all records and columns into one dataset. Other join types are selective: records and columns are combined only when a specific column value in both datasets match. For example, in the table above you can see that the "Order ID" column appears twice, once from each source dataset, and that the values in both columns match. Multiple joins can be used to combine multiple of datasets.

Once you've selected data, all of the other tabs at the top of the application become enabled. Click the Data tab to hide the data selection controls.