5.8. Browsing the data table

Log into the platform and open a workflow that has data in the table. Click in the Table link at the top of the screen to see the stored data:

../../_images/tutorial_initial_table.png

The buttons at the top of the page offer the following functions:

Row
A form to introduce a new row in the table with one field per column.
Column
Add a new column to the table. The pull-down menu also allows to add a column with values calculated with a formula and using the existing values, or a column with random values (See Adding a column for a detailed explanation).
Manage table data
Menu to upload/merge data to the table (see Data for a detailed explanation), execute a plugin, or delete the data in the table.
Views
A view is a screen showing a subset of rows and/or columns in the table. Clicking in the Views link will take you to another screen to manage these views. The pull down menu offers links to access the subset of the table defined by the available views.
Dashboard
The dashboard shows a statistical summary for the columns shown in the table. This number may be too high, so you should consider using Table Views to reduce the amount of information shown in the dashboard.
CSV Download
This functionality downloads the data in the table as a CSV file. Combine this functionality with the Table Views to handle large tables.

5.8.1. Table Views

For tables with a large number of columns and/or rows OnTask allows you to define a view of the table that shows only a subset of it. To create a view click first in the Views button at the top of the table page and then the Add View in the next page. Insert a name, description and select some of the columns as shown in the following figure.

../../_images/tutorial_table_view_create.png

You can also define views to show only a subset of rows. The subset is selected using a row filter stating the conditions that must be satisfied by a row to be included in the view. These conditions are stated in terms of the column values.

Save the view and then click in the View button. The appropriate table subset is shown. The buttons at the top of the page allow you to edit the view (change the rows and columns selected), or select another available view.

../../_images/tutorial_table_view.png

5.8.2. Column and Row Statistics

If you click in one of the Statistics icons in the left-most column of a row OnTask shows a page with statistical representation of the population values for the columns and a mark denoting where is the value of the selected row.

../../_images/tutorial_row_statistics.png