Explore Cards¶
Explore Cards can be used to detect patterns and outliers by visually navigating the data. An Explore Card can be created on a required column that is needed to be visually represented or discovered. The main features of Explore Cards are:
Provides a summary about the distribution of values in the data.
They are interactive and hence, you can add any available filters to the data.
Table of Contents
Adding Explore Cards¶
You can add Explore Cards using one of the following methods:
Clicking on the
□
icon on any of the column opens the corresponding Explore Card.Explore menu can be used to toggle one more Explore Cards.
Types of Cards¶
Explore Cards can be created on any of the columns. Depending on the column date type, the Explore Card differs in the representation of that column’s contents. Following three types of Explore Cards are available in Mammoth:
Text Explore Cards: Listing of unique values for text columns.
Range Explore Cards: Displays ranges of values present in the numeric and date 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:
Filter: Clicking on this allows for temporary filtering of data.
Options: Clicking on this brings: up the following menu:
Replace all values like this: Allows for replacing of selected values. This brings up Bulk 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¶
If there are blank values in the data, text Explore Card shows them at the top of the list.
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:
Graph view: Displays a graph of the various ranges.
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:
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:
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.
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.
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.
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.
Selecting Values when seen as List¶
This is similar to selecting values in Text Explore Cards.
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:
Filter: Clicking on this will allow for temporary filtering of data.
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.