Explore Cards

The Explore Cards allow visual discovery of data. Using Explore Cards you can detect patterns and outliers by visually navigating the data.

Explore Cards are created on a column.provide a summary about the distribution of values in the data. They are interactive and allow for filtering of data.

Adding Explore Cards

You can add Explore Cards using one of the following methods:

  1. Clicking on the icon on any of the column opens the corresponding Explore Card.
  2. Explore menu can be used to toggle one more Explore Cards.

If you want to add a custom Explore Card, use the Explore menu option.

Types of Cards

Explore Cards can be created on any of the columns. Depending on the column data type, the Explore Card differs in the representation of that column’s contents. Following three types of Explore Cards are available in Mammoth:

  1. Text Explore Cards: Listing of unique values for text columns.
  2. Range Explore Cards: Displays ranges of values present in the numeric and date columns
  3. Custom Explore Card: Allows for an arbitrary condition to be set on one or more columns.

Text Explore Card

The Text Explore Card displays a list of unique values present in the corresponding text column. By default, count for each of the values will appear in the list. One can click on any of the values and filter by the values.

Selecting values

The Text Explore Card is interactive. You can click on any of the values in the Card. Multiple values can be selected by using shift/ctrl/cmd keys. To undo the selection, click anywhere else.

Filtering data and other actions

A temporary menu appears to the left of the Explore Card contents when a value is selected. This menu has the following two buttons:

  1. Filter: Clicking on this allows for temporary filtering of data.
  2. Options: Clicking on this brings: up the following menu:
    • Replace all values like this: Allows for replacing of selected values. This brings up Group Replace task.
    • Remove all values like this: Allows for removal of selected values from the grid. This is a shortcut to the Apply Filter task.
    • keep only values like this: Allows for removal of all unselected values from the grid. This is a shortcut to the Apply Filter task.

Notes

  1. If there are blank values in the data, text Explore Card shows them at the top of the list.
  2. The list is limited to top 10,000 unique entries only. This is done to prevent overloading your browser. Note that if your data contains more than 10,000 unique values, searching on the Explore Card may not show the values you are looking for.

Range Explore Card

This Card will display a few ranges of values from a numeric or a date column. By default, the ranges are represented as a graph with each of these values. You can change that to see the Card as a list.

Range Explore Cards can be seen in the following two representations:

  1. Graph view: Displays a graph of the various ranges.
  2. List view: Displays a list of the various ranges. This view will look similar to a text Explore Card except that the values listed are ranges and not unique values from the data.

These two options can be toggled using the toggle button at the left-bottom of any range Explore Card.

In either of these representations, the Card will additionally display a set of summaries about the column. Look at the following table to see the list of summaries displayed in these Cards:

Table 1 Summaries in range Explore Cards
Summary Date Column Numeric Column
Sum of the column values ✔︎
Average of the column values ✔︎
Standard Deviation of the column values ✔︎
Minimum value in the column ✔︎ ✔︎
Maximum value in the column ✔︎ ✔︎

When the Card loads for the first time, Mammoth looks at the data and decides the best resolution to use for the data. You can override the resolution by using the Change Aggregation Menu.

Menus

Following menus are present on the Explore Card:

  1. Change Aggregation Menu: You can change this Card to view another aggregation or adjust the resolution of the ranges in the Card. This appears at the top right of the Explore Card. See Change Aggregation/Granularity Menu.
  2. Search: You can search for any of the unique values in the corresponding column by searching through this menu. This appears on the left bar of the Explore Card it is being viewed as a list.
  3. Sort Menu: You can change the order of items by choosing to sort by the value or the count. This menu appears below the Search when viewed as a list. See Sort Menu in Explore Card.
  4. Switch representation: Allows toggling between viewing as a list and viewing as a graph.

Selecting values in when seen as graph

The graph in the Explore Card is interactive. You can click on any of the bars to take action on data that belongs to that range. You can also select multiple ranges by clicking & dragging over multiple bars over such values. This does not work with shift/ctrl/cmd keys. Clicking anywhere else will undo the selection.

Filtering data and other actions

A temporary menu will appear to the left of the Explore Card contents when a value is selected. This menu has the following two buttons:

  1. Filter: Clicking on this will allow for temporary filtering of data.
  2. Additional Options: Clicking on this will bring up the following menu:
    • Replace all values like this: Allows for replacing of the selected values. This will bring up customValuesRule task.
    • Remove all values like this: Allows for removal of selected values from the grid. This is a shortcut to the Apply Filter task.
    • keep only values like this: Allows for removal of all unselected values from the grid. This is a shortcut to the Apply Filter task.

Custom Explore Card

The custom Explore Card is a way to apply filter using the filter module. The conditions work like they do in rest of the application. See Condition.

The conditions set with this Card are temporary in nature.

Change Aggregation/Granularity Menu

This menu allows supports the following options:

  1. Show values by: Allows for change of the aggregation the Card should display. By default, it is the number of rows in data against the unique value/range. It can be changed to aggregation of any number column. The list of supported functions are SUM, AVG, MIN, MAX, STDDEV. See Numeric functions.
  2. Granularity: Allows for the resolution of the range. For example, numeric columns can be seen as 10s, 100s, 1000s etc. Date columns can be seen as days, months, and years. There is a limit on how many bars can be plotted and if the number of bars exceeds that limit, the Card automatically switches to a higher resolution to make the plotting possible.

Sort Menu in Explore Card

The sort menu shows on the left of an Explore Card in the following situations.

  1. The Explore Card is a text Explore Card.
  2. The Explore Card is a range Explore Card showing a list value.

The Cards can be sorted in the following ways:

  1. By aggregation value. This option will appear as SUM, COUNT and so on.
  2. By the unique value/range.

You can also chose Ascending/Descending orders when sorting.