Skip to main content
waffle.svg
Domo Knowledge Base

DataSet Views (Beta)

Version 3

 

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.

Getting this feature

If you are interested in joining the Beta for this feature, please contact your Customer Success Manager (CSM).

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.


Picture1.png

How to explore data using Views Explorer

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

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.


Copy Picture3.png        Picture2.png

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.

Picture4.png

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.

Picture5.png

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.

Picture7.png    Picture6.png

Add Calculated Column

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

Picture8.png    Picture9.png

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.

Picture10.png

Perform Joins

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

Picture11.png

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.

Picture12.png

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.

Picture13.png

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.

Picture15.png    Picture14.png

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.

Picture16.png

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

Picture17.png

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

Picture18.png

When you are finished, simply select the Finish button.

Picture19.png

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.

Picture20.png    Picture21.png

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.

Picture22.png    Picture23.png

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.

Picture24.png

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.

Picture25.png    Picture26.png

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.