反馈已提交

网络繁忙

Time Interval

  • Last update:  2023-11-15
  • Overview

    Version

    FineBI VersionFunctional 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

    附件列表


    主题: Adding and Editing Data
    • Helpful
    • Not helpful
    • Only read

    feedback

    鼠标选中内容,快速反馈问题

    鼠标选中存在疑惑的内容,即可快速反馈问题,我们将会跟进处理。

    不再提示

    10s后关闭