Guides
Shape Help Center

Control Metric Aggregation With Views

NinjaCat's Data Cloud connects you to and stores data directly from providers. This lets you select the reports and fields you want to get the results you need from your data. Views gives you another layer of control to get the right data driven result. Views lets you select the dimension you use to aggregate your data and filter out dimensions that break apart your metric results in ways you don't want. This article goes over the features of Views and some tips for use.

Suggest Edits

How to Access Views

1. After clicking on "Data Cloud" click on the "Datasets" subheading

2. Select the desired dataset from your list or follow the instructions in the article "How to Build a data Cloud Data Source" to create a new dataset from scratch

3. Click on the plus icon near the top right, or on "Create a view" near the center under "Views" on the dataset details page to create a new View


Views Features

📘

Views are created using a modified dataset explorer page. On the traditional dataset explorer page some of the features only work for viewing like the temporary filter feature. Other features like the data cleaning features edit and change the base dataset itself. In the modified dataset explorer page used by the Views feature, every feature works to create a new, reorganized, separate version of the original dataset.


  1. Name Field - Use this field to give your new view a name
  2. Columns - Click on "Columns" to add and remove columns from your view table (Adding and removing text columns/dimensions changes the aggregation or segmentation of your number columns/metric values)
  3. Add Filters - Filter categories of text columns and numeric results of umber columns
  4. Clear Filters - Click to clear all filters
  5. Edit Dataset - Click to transfer over to a traditional dataset explorer page to do data cleanup steps
  6. Save View - After making your selections and configuring your desired aggregation, click the "Save View" button
  7. Edit Column - The edit column allows you to edit the column header, view result analysis, and select an aggregation type based on the type of column and the desired metric roll up result
    • Text Column
      • MIN
      • MAX
      • COUNT_DISTINCT
      • GROUP_CONCAT
    • Number Column
      • SUM
      • MIN
      • MAX
      • AVERAGE

Selecting a View for Export

1. Access the Data Cloud Ship Page

2. Follow the instructions to create and then store credentials and create a new data export

3. When selecting the source for the data export, use the resulting "View" drop down menu after selecting the desired dataset

4. Complete the instructions to finish creating your data export

Updated about 1 month ago