DataSet Views

Intro

Views Explorer is a business-friendly data exploration tool designed to make it easy to explore, wrangle, and combine your data in an easy to understand spreadsheet interface. This simple, yet powerful, DataSet Views experience allows you to perform data cleansing operations such as filtering, grouping, aggregating, and even combining data through a simple visual interface. Anyone with an Admin user or a Custom Role that has either the "Edit DataSet" or "Manage DataSet" grants enabled can use DataSet Views. For more information on Custom Roles see Managing Custom Roles.

Video - DataSet Views Explorer

How to find Views Explorer

To get started, choose the Open With dropdown and select Views Explorer. This will take you to a new window where you will be able to explore your data.

How to explore data using Views Explorer

Views Explorer has many ways to manipulate and cleanse data, they are:

• Remove Columns
• Add Columns
• Rename Columns
• Move Columns
• Add Calculated Column
• Perform Joins
• Perform Unions
• Filter Data
• Group Data
• Sort Data
• Limit Data
• Undo/Revert Changes
• Save the DataSet View

Remove Columns

Removing columns is a common step in cleansing data, and Views Explorer makes it easy to remove columns from your DataSet. Columns can be removed by selecting the triple dot menu on each column and selecting Delete. To remove multiple columns, you can also choose the Select All option from the columns on the left and the delete icon.

Add Columns

In certain situations, it makes sense to add a duplicate of a column to your DataSet. To add columns to the DataSet, choose the Add Column button at the bottom of the columns on the left.

Rename Columns

Rename a column by selecting the triple dot menu on a column and choosing Rename. This can also be done in by using the columns on the left.

Move Columns

Reordering columns can be done in two places. To move a column select the Move option in the triple dot menu and selecting one of the four options: Left, Right, First, or Last. You may also drag and reorder columns by using the columns on the left.

Add Calculated Column

To add a new calculated column choose the plus sign and select Add Calculated Column.

When you have finished writing the calculation, select Save and Close. This will automatically add the new calculated column to your DataSet in Views Explorer. For the new calculated column to save to your DataSet, you will need to save your DataSet as a new DataSet View.

Perform Joins

To join DataSets using Views Explorer, toggle to the DataSet side of the schema rail. From there, select the Add Join button.

Next, select a DataSet to join and choose the Join Keys from each DataSet. Once you have selected the keys, choose the Join Type you would like to use (we support Left, Right, and Inner Joins.) You will then have to select the columns you would like to include in your DataSet.

From the Select Columns modal choose which columns you would like to include in your DataSet and select Save. The columns you selected will now appear in your DataSet.

Perform Unions

To union DataSets using Views Explorer, toggle to the DataSet side of the schema rail. From there, select the Add Union button.

Next, select the DataSet(s) to union and select Save. The data from the selected DataSets will now appear in your DataSet.

Filter Data

Column filtering can be done with the columns on the left, using the Filter button at the top of Views Explorer, by choosing the triple dot menu on each column and selecting Filter, or by selecting Filter on each column.

Group Data

Grouping data helps you to see only columns you are interested in and aggregations to summarize the data from the categories you have selected. To Group data, start by selecting the Group button.

In the Group By modal, drag columns you are interested in into the Categories section.

In the Group By modal, drag columns you are interested in aggregating into the Aggregations section.

When you are finished, simply select the Finish button.

Sort Data

Sorting data allows you to sort your data alphabetically, by date, Low to High, or High to Low. To sort data, choose the Sort button at the top or select the triple dot menu on each column.

Limit Data

Limit means the DataSet will only return the number of rows you have chosen, sorted by the sorting rules you select. To limit the number of rows in your data, choose Limit and add the number of rows you would like to include in your DataSet.

Undo/Revert Changes

Sometimes you want to undo your last step or just start over. Use the undo and revert buttons to go back a few steps, or start over at the beginning of your data exploration.

Save the DataSet View

When you have finished your exploration, you may want to save it as a new DataSet View. To save your Views exploration as a new DataSet View choose the Save As Button. Choose a new name for your View and then Select Save.

Your DataSet View will appear in Domo as a new DataSet that can be shared with others in Domo. PDP policies from the parent DataSet will still apply and the DataSet View will update when the parent DataSet updates.

FAQ's

How do DataSet Views treat NULL values?

Null values are not considered to be equal or not equal to any other value. This means that comparing a column with a null value to another column using either = or != (<>) will always return false for that row.

Can I use a View inside of a MySQL DataFlow?

No, at this time Views are not supported inside of MySQL DataFlows.