Time Interval- FineBI Document

Last update： 2023-11-15

Overview

Version

FineBI Version	Functional Change
6.0	/
6.0.2	Changed the time interval name and entry. Optimized the page.

Application Scenario

When you want to know the time interval between two time fields, you can use the Time Interval function to obtain a time interval column.

Function Description

Select the two required time fields, and set Unit to Year, Quarter, Month, Day, Hour, Minute, or Second, as shown in the following figure.

时间差图1.png

Example

Sample data: Contract Fact Table.xlsx.

The table has two fields: Registration Time and Contract Signing Time. How can you know the interval between the customer registration time and the contract signing time?

(1) Create an analysis subject and upload the sample data Contract Fact Table to enter the data editing page.

(2) Add Time Interval through either method, as shown in the following figure.

时间差图2.png

(3) Add a column named Time Interval to calculate the contract signing time minus the registration time (unit: day), as shown in the following figure.

时间差图3.png

(4) Click OK. Then you will get the time interval between the registration time and the signing time, as shown in the following figure.

时间差图4.png

Helpful
Not helpful
Only read

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

English

Time Interval

Overview

Version

Application Scenario

Function Description

Example

附件列表