Topics: |
The Subject Completeness bar chart displays the percentage of Subject data completeness.
Total records, Populated records, Blank records, and Blank attributes tiles display the number of records corresponding to the name of the tile (Blank/Populated, and so on).
The Completeness by attribute bar chart displays the percentage of completeness per attribute. It shows you a visual representation of the subject you are working with and helps identify where the possible data problem might be.
The Attribute Overview table displays attribute data characteristics from different categories:
Populated, Blank, Distinct, Min, Max, Total W/N Patterns and Total L/D Patters.
The Add to Filter functionality allows you to add a filter tag from the bar chart, tile, or grid. The Add to Filter option is present in the Context menus which are available by right-clicking on most of the following components: tile, bar chart, and table cell. There is no context menu available for the Blank Attributes tile.
After selecting the Add to Filter option, a global filter will be added containing the appropriate criteria.
The following lists describes the specifics for adding a filter from the different context menus:
You can navigate to the Data table and see data according to the selected item in the on-screen filter or global filter data by selecting Show data from the context menu. The presence of an On-Screen filter and global filter on the Data table page depends on the selected bar chart on the Profile page.
You can right-click on any tile, table cell, or bar chart and select the Show Data option, as shown in the following image.
The following list shows how the Show Data option applies towards each different component.
The Add to Filter option can be selected in the Profile/Attribute page from the context menus by right-clicking the tile and bar chart components. After clicking Add to Filter, the filter tag will be added to the global filter, as shown in the following image.
The following list describes the results of adding filters from different context menus.
You can also open the context menu by right-clicking either the bars, name of the bars, or the value in the 20 most/least frequent values, 10 first/last values, 20 most/least frequent patterns, or tags.
There is a delimiter line between each of the five bar charts for each bar chart section.
Once a filter is added, the Attribute page will be filtered according to the filter criteria.
You can navigate to the Data table and see data according to the selected item in the filter or global filter data by selecting the Show Data from the context menu. The presence of a filter and global filter on the Data table page depends on the selected bar chart on the Profile page.
You can right-click on any tile, table cell, or bar chart and select Show Data, as shown in the following image.
The following list describes the different functionalities of Show Data for each of the various components.
You can right-click on the Attribute Completeness bar charts and select Show Data. The result will be the same for the Populated records tile.
If the value is NOT in the default Column Profile due to space reasons (for example, if you clicked on the 19th Most Frequent value while the Column Profile displayed only the 10 Most Frequent values), the value appears as a special value in the correct place separated by a visual separator.
If it does not appear, it is added as a new value at the end of the list separated by a visual separator.
When you right-click anywhere else in the Attributes Page, the Show Data option will not be present.