Data Verification- FineBI Help Document

Last update：September 18, 2025

Overview

Version

FineBI Version	Functional Change
6.0	/
6.1.6	1. Allowed you to check empty fields during data verification. 2. Optimized data verification during the extraction process. The date displays the earliest and latest date values in the column. The value displays the maximum and minimum values of the current column. 3. Allowed you to view detailed data rows by clicking the statistical results of null count, earliest, latest, minimum, and maximum values. 4. Allowed you to view the field value of the data verification results by clicking the drop-down list.

FineBI Version

Functional Change

6.0

6.1.6

1. Allowed you to check empty fields during data verification.

2. Optimized data verification during the extraction process.

The date displays the earliest and latest date values in the column.
The value displays the maximum and minimum values of the current column.

3. Allowed you to view detailed data rows by clicking the statistical results of null count, earliest, latest, minimum, and maximum values.

4. Allowed you to view the field value of the data verification results by clicking the drop-down list.

Application Scenario

In editing data and performing calculations, you need to analyze and verify the data simultaneously. This helps you confirm the accuracy of the data, quickly identify issues, and adjust the calculation logic as needed.

Function Entry

You can click a column header to automatically display data verification results (e.g., null count, sum, average) for that field in the preview area below.

You can click the dropdown list to display count results for each distinct value, as shown in the following figure.

Function Description

Column Header Verification

1. Click a column header to display its data verification results in the preview area below, as shown in the following figure.

Different field types display different results.

Icon	Field Type	Data Verification Content
	Value Field	Null Count, Sum, Average, Min, and Max. Null Count: Number of null values. Max: Maximum value of the current column. (null values excluded, extracted only.) Min: Minimum value of the current column. (null values excluded, extracted only.)
	Text Field	Distinct Count and Null Count Null Count: Number of records with empty strings or null values in the current column.
	Date Field	Distinct Count, Null Count, Earliest and Latest. Null Count: Number of null values. Earliest: The earliest date value in the current column. (null values excluded, extracted only.) Latest: The latest date value in the current column. (null values excluded, extracted only.)

Icon

Field Type

Data Verification Content

Value Field

Null Count, Sum, Average, Min, and Max.

Null Count: Number of null values.
Max: Maximum value of the current column. (null values excluded, extracted only.)
Min: Minimum value of the current column. (null values excluded, extracted only.)

Text Field

Distinct Count and Null Count

Null Count: Number of records with empty strings or null values in the current column.

Date Field

Distinct Count, Null Count, Earliest and Latest.

Null Count: Number of null values.
Earliest: The earliest date value in the current column. (null values excluded, extracted only.)
Latest: The latest date value in the current column. (null values excluded, extracted only.)

You can click the statistical results of null count, earliest, latest, minimum, and maximum to view detailed data rows. You can click the drop-down list in the header of the detailed row to view the field value count, as shown in the following figure.

Field Drop-down Verification

Click the drop-down list to view the field value count, as shown in the following figure.

Note

The data volume used in verification calculations is limited by the table computation volume of the self-service dataset. For details, see Data Volume Description.

Previous：Data Editing Overview

Next：Data Editing Use Guide

Helpful
Not helpful
Only read

中文（简体）中文（繁體）日本語

English

Data Verification