Creating a New Data Table

You can create a new data table on the Data tab.

To create a new Data Table:

1. On the Data Tab, click the Create New Table button.
2. On the new table screen, you can choose your options on the left.
   For more information, see Selecting Data for the Data Table.
3. Click Update to generate the data table. 
4. View the results.

At the top of the data table's sidebar, the Standard Filters tab contains all of the menus for selecting data.

The standard filter options include:

1. Model: You can select from contextualized data models. Each implementation with Sight Machine has models configured specifically for that manufacturing process. The most common include: Cycles, Downtime, Parts, and OEE.
2. Assets: You can select specific machines, sorting by machine type or location. On the Cycles, Downtimes, and Defects models, you can only select machines of the same type. On the OEE model, you can select machines across different types.
   NOTE: When the Parts/Lots model is selected, the Asset selector is replaced by a Part Type/Lot Type selector.
3. Date Range: You can click the date range selector, and then select the range that you want to inspect. A relative date range will be selected by default. You can change this to a historical date range by unchecking the box marked Relative Date.
4. Data Fields: You can select any number of parameters to display.

Selecting Data for the Data Table

The Custom Filters tab on the sidebar allows you to filter the results.

To filter data table results:

1. Click the Custom Filters tab.
2. Click Add Filter, and then select a data field.
3. For categorical fields, you can select a value or set of values (and toggle between equal to and not equal to). For continuous fields, you can apply one or more numeric conditions (e.g., range, greater than, etc.). Make your selection, and then click Apply.
   
4. Click Update to update the table.

Saving a Data Table

After you create the new data table and make any adjustments to the filter, you can save it for future use as well as mark it as a favorite, label it, share it, download it, etc.

To save a data table:

1. At the top of the data table window, type a name for the table.
2. Click the Save button. If you make additional changes, be sure to click Save again when you are finished.
   
3. After you save the data table, the toolbar options at the top of the page change. You can do the following:
   • Change the sharing permissions of the data table to Private or Public.
   • Permanently delete the data table.
   • Mark the data table as a Favorite. It then appears as a Favorite on the Data tab.
   • Manage the labels for the data table.
   • Share a link to the table using email.
   • Download the data table results as a CSV file. s

Downloading a Data Table

You can export the data in a Data Table into a ‘.csv’ file for offline analysis, using the Download Data icon on the far right.

To export a Data Table:

1. Click on the Download Data icon.

2. You will see a “Preparing Download” icon that lets you know the data is being exported.  Once the download is completed, you will find a link to the downloaded ‘.csv’ file.

3. For large data sets, you could also click on the email icon to receive an email with a link to the downloaded file, instead of waiting for the download to complete.

NOTE: Please note that null values in the data are represented as blank cells in the ‘.csv’ file.

Data Model Support

You can download Data Tables for all data models, including Raw Data, Cycles, Parts, Downtimes, and Lines models.