Expand | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|
Table of Contents | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
|
About the Field viewer
Clicking this option opens the Field viewer, which shows the list of fields and stat counts for data downloaded to the browser for the query period. The panel remains open and visible at all times until you choose to close it.
You can use the Field viewer for two different purposes: display statistics associated with all of the distinct values of the fields and manage those fields in the data search window.
Info |
---|
Available in Table and List views This is available in both table view and list view. Get more details on the different views here. |
What permissions do I need?
You don’t need a special permission to use it apart from the Finders permission required to run searches. However, you need the Stat count of searches permission to obtain the full stats and the Show/hide fields permission to edit the layout and save it for future searches.
Managing fields
The Field viewer provides means to interact with the fields inside a data table so you can adapt the table to your workflow and carry out different tasks conveniently and effortlessly.
Rw ui tabs macro | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
There are two ways you can order the fields in the panel. All changes made to the field order are reflected in the data table.
You can show or hide individual fields by clicking on its associated toggle. Alternatively, click on the toggle at the top of the list to show or hide all fields. Click on the downward arrow to display all fields, only active fields, or only inactive fields.
Any changes made to the order of the fields or their hide/show toggles that you want to keep must be made before leaving the panel. You can save the changes for the user or for the domain. You can also reset all changes either the user or the domain, or reset only the order of fields.
Easily drag and drop fields from the panel into widgets keys to create charts. Find out more about the different charts available in Devo here. |
Displaying stats
Rw ui textbox macro | ||
---|---|---|
| ||
Data downloaded to browser Devo does not download all data automatically to your browser to avoid memory overloading, so it’s important to consider the percentange of data already downloaded when analyzing stats. You can check it at the top-left corner of the search window (learn more about event loading preferences in this article). When you place the cursor on the downward arrow of a table field header in your search, you will see the top unique values and their percentages in relation to the total. However, the yellow warning indicates that these stats only consider the data that has been loaded into the browser so far. |
Load full period stats
If you want to work with more precise data and get the whole dataset from the server, you can click the Show full period stats/Get full stats button. The Stat count info lets you know about the amount of data currently downloaded from the server (click the help icon to know what each level means).
You can choose specific fields to download their data by using the Bulk option next to the search box. This option appears after showing full period stats and before getting full stats.
See distinct values
To know the stats of a field simply click on its name and a new panel opens. In this panel you can see the following information:
1 | Name, data type and number of unique values inside this field | |||
2 | Top values: select if you want to see Local, Estimated or Exact data (depending on the amount of data downloaded from the server, as explained above).
| |||
3 | Exclude null: activate this toggle to exclude null values for a more accurate analysis. | |||
4 | List of unique values in the selected field. Click a value to filter the data in your search and show only events with that value. | |||
5 | Use these icons to perform the following actions:
| |||
6 | Conditional formatting: Choose fields to add formatting to and add up to a maximum of five conditions that specify an operator and value, along with text and background color, to apply to the matching cells. The first formatting that matches will be the one applied. The existence of conditional formatting is marked with an icon with the number of applied conditions over it. Conditional formatting can be accessed three ways:
Each condition provides a preview along with tags that indicate the visual format and the value. Make sure to apply the changes before exiting and they are shown as follows:
|