Further explore data elements in graphs or charts with Kount Control’s Explore Mode. Explore Mode provides additional data filtering and sorting options that are not found in the standard view.
With Explore Mode, you can:
- Drill down into data
- Maximize charts
- Change visualizations of chart data
- Add or modify filters
- Add columns to tables
- Group columns in tables
- Add aggregations to tables
Enabling Explore Mode
- Log in to Kount Control.
- Turn on Explore Mode.
Note: If you have an element maximized when you turn on Explore Mode, the element resets and the default dashboard view displays (minimizing the element).
Maximizing Elements
Most Explore Mode features require maximizing the graph, chart, or other element. To expand the view for any chart or graph, hover over the element, and then click on the Maximize element icon.
Maximizing the chart shows a data report. Once in this view, you can:
- Add or modify filters based on any of the existing fields of the report
- View all of the columns within the report
- Modify the underlying tabular report (refer to the note below)
- Modify the chart type and attributes (refer to the note below)
Drilling into Chart Data
To get a more detailed view of the chart data, use the drill-down functionality on a data element. This allows you to group by a new data element.
Drill down
- To drill down, right-click on the data element, and then select Drill down.
- Select from the existing fields within the report to create a new group for a deeper drill-down level.
The result of the drill down is as follows:- Filtering on the element selected for the drill-down – in this example, the user chose to drill down on the BLOCK decisions so the resulting graph only includes a dataset where the decision equals Block.
- A grouping based on the drill-down field. In the example, hostingFacility (a t/f Boolean) was selected, so the results are broken into true and false.
- The resultant graph displays all the Block decisions broken into populations where the login was a hosting facility and where the login was not.
Drill up
After you have drilled into a report element, you can drill up to a higher level or to the original groupings and filters. This can be accomplished by right-clicking on one of the data elements in the report and selecting Drill Up.
Drill control
To move between several different filters on the data, create a Drill Control. Drill Control creates a clickable filter on the page that allows for quick movement between data.
Visualization Bar
The visualization bar shows the type of visualization and allows you to make the following changes:
- Type of visualization
- The aggregation fields and the type of aggregation
- The column and row values for the report
- The value to be used for color variance (what will be separated)
Example
The pie chart report groups data based on the Decision (accept, block, or challenge), and then counts the number of each Publish_TS (this is the timestamp of the event, but for this report the name was changed to Login Decisions).
Changing the visualization type
You can change how the data is displayed by changing the Visualization Type. Different visualizations have different data requirements, so it might not be possible to use some visualizations with some data elements, or it might require adding or removing data elements from a visualization.
Click the Visualization drop-down menu to find and select your visualization type.
Visualization elements
Y-Axis: The measurement unit from top to bottom.
X-Axis: The measurement unit from left to right.
Aggregation: The Aggregated Value can be attached to the X-Axis, the Y-Axis, or the Value depending on the chart type. The Aggregation Type can be changed by right-clicking on the value, and then choosing the Set Aggregate. The type of aggregation is dependent on the field type being aggregated (number, text, Boolean, etc.).
Aggregation types
Number
- Sum
- Avg
- Median
- Percentile
- Min
- Max
- First
- Last
- Count
- CountDistinct
Boolean
- Count
- CountIf
- CountDistinct
Text
- Count
- CountDistinct
Adding or Modifying Filters
Filters can be applied to any data field that exists in the report. The most common ways to apply a filter:
- Right-click on a data element, and then select include or exclude.
- Click the drop-down menu next to a field name (indicated by a small down arrow), and then select Add Filter.
Any filter that applies to an element is shown in the Maximize element view. You can toggle filters on/off or modify the lookup values for filters.
Filter types
You can change the type of filter by clicking on the options menu next to the on/off toggle for the filter. You can only use filters that are applicable data type as it is not possible to filter based on a mathematical function on a text field, nor can you use text filters (like contains) on a numeric field.
Example
UserID contains a numeric value, but the field is designated as text. In order to filter it based as a min value max value, you will need to transform the field to a number prior to filtering it as such:
- In the column header row, click the down arrow next to UserID.
- Click Transform to Number.
- In the column header row, click the down arrow next to the UserID.
- Click Filter.
- Select the numeric filter you want to add.
Tables
From the Maximize Element view, you can change how underlying data is presented by adding a new column, grouping columns together, or performing another similar action.
Adding a column
When you add a column to a table, it creates a formula based on existing data within the table. The formula can be conditional, text manipulation, mathematical, date manipulation, or aggregation functions (when the data has been grouped). These functions are very similar to popular spreadsheet programs.
When you type a function or formula into the fx bar, a help window opens to show the common usage for the function. The conditional value sets the data based on a condition being true or false for the row.
Text manipulation
Some commonly used text manipulation functions include:
- Left (get the left number of characters stipulated)
- Right (get the right number of characters stipulated)
- Mid (get the number of characters starting at)
- Len (length of a string)
Mathematical
Numbers can be used in equations or compared against one another using IF.
Date manipulation
There are a number of date manipulations that can be employed. Commonly used functions include:
- Dateadd (add or subtract time from a date field – subtract by using a negative number)
- DateTrunc (Truncate the date to a unit – e.g. day 2022-03-01 )
- DatePart (Pull out a specific part of the date – e.g. year 2022)
Aggregation
Aggregate functions work when one of the columns has been grouped (see below). Common aggregate functions include:
- Count (Counts the total number of non-null items for a column)
- CountDistinct (Counts the total number of distinct non-null items for a column)
- Countif (Counts an item in a column if the conditional is met)
- Avg (Average of all non-null items in the column)
- Sum (Sum of a column)
Grouping data
- To group a column, right-click on a column name, and then select Group Column. This creates a grouping for all data for that field.
Note: Multiple nested groups can be made, but nested groups can cause slow downs or timeouts. - To create an aggregate for the group, click the down arrow on the grouped column, and then select New Column. Within the new column, add an aggregate function. In the example below, count each time the TAGS field contains the word Velocity, then rename the column Velocity Tag Count.
Collapsing and expanding rows within a grouped report
- Select the +/- icon next to the column header to collapse or expand all groups. This is useful when the only data that is desired is the aggregation (it drastically reduces the amount to be exported if the report is to be saved as an Excel or CSV report).
- You can expand a grouped data element (and see all of the underlying data for it) by clicking + next to the data that you want to expand.
Frequently Asked Questions
Where can I find additional documentation about Explore Mode?
Refer to the Sigma Computing Help Center documentation page.
Where can I find more information about navigating the Kount Control Dashboard?
Comments
0 comments
Please sign in to leave a comment.