Navigate to the Mart.

Select Data to see a list of tables and select one to view the data.

!Image showing how to Navigate to the Data Page

Select a table to see the data.

Filtering and Statistics

In order to filter and view the statistics on a column, click on the heading. In this case, we are going to look at the region codes in REF_COUNTRY.

Image showing the a red box around the WHO Region column heading

This will bring up the Column Pop-up

Image showing the Data Column pop-up. In the top right are the column name and type underneath is the sorting which sort the values. In this case, the column is text so it offers the choice to sort in alphabetical or reverse alphabetical order. For numbers, the options are Large to Small or Small to Large. Underneath that is the filtering using text and to the right are the top 5 values with the number of records with those value. Underneath is the link to the "Analyze/Show more" button which brings up the "Full Column Statistics" pop-up

On the left is a box showing the top 5 values with the count of the records for each value. At the bottom is an Analyze/Show more button which brings up an Analysis for all of the records.

Image showing the Data Column Full Analysis pop-up. The position of the number of Rows and Distinct values is shown at the top right corner. The search panel is shown in the middle left. The sort is on the middle right and underneath, taking up half of the pop-up there is a panel which shows All of the values showing count and percentage of the records in the table which have the value. Values can be filtered by clicking on the checkbox on the right

By clicking next to one of the values, you can filter the data.

If a column has been filtered then the title colour changes to blue

Iamge showing the title colour of the filtered column has changed to blue

Removing a filter

There are several ways to remove a filter

The first is by using the funnel directly on the data page

Image showing the blue filter with a cross next to it on the Data View page

You can also do it from the column pop-up-box

Image showing the 2 eraser icons, the option to uncheck the filterand the option to erase the text in the text box

The Data Action Panel

On the Data View page, there is a Data Action Panel

Image showing the data view page for REF_COUNTRY and the location of the Edit Data Action Panel in the top right

Image showing a close up of the Data Action Panel. This has 6 buttons in a horizontal row with a small gap to a seventh. On the left is a key marked API with the label "OData Endpoint". Next to it is key with the image of a wall with the label "Model". After that there are two keys with arrows on them, a downward pointing arrow marked "Download" and an upward pointing arrow for "Upload". ON the right of those is a key with a triangle pointing right with a line on the right of it touching the top. The text for this key is "Run a Pipeline on this data". Finally, before the gap, there is a key with a pencil on it with the caption "Edit in UI". There is then a small gap to a key with a cross in it which has the caption "Close"

OData Endpoint

See Use the OData API

Model

See Edit Model via UI

Download

See Download data

Upload

See Upload data

Run a Pipeline on this data

See Process Data View Rows

Edit in UI

See Edit Data in UI

Close

Goes back to the main data page