Time Interval Calculation

Preview

You may need to calculate the interval between two time fields, such as the interval between Contract Signing Time and Registration Time.

Implementation Method

The time interval can be calculated through the DATESUBDATE function or the Time Interval button on the data editing page.

Sample data: Contract Facts Table.xlsx

Creating an Analysis Subject

Create an analysis subject and upload the sample data.

Calculating Time Interval

Choose More > Time Interval.

Name the added column as Time Interval (Day). Set the Time Interval to Contract Signing Time - Registration Time, Unit to Day(s), and click OK.

Click Save All and Update.

Demonstration

For the demonstration of this KPI card, see the second figure in section "Preview".

Method 1: Data Editing

Adding Data

Choose > Local Excel > Upload Data on the data editing page to upload the sample data.

Adding a Formula Column

Click Formula Column and name the added column as Time Interval (Day). Enter the formula DATESUBDATE(Contract Signing Time,Registration Time,"d") and click OK.

Note:

Fields in the formula need to be selected from the left area and cannot be entered manually.

Click Save All and Update.

Method 2: Component Editing

Adding a Component

Click the Component tab in the bottom left corner to enter the component editing page.

Adding a Calculation Indicator

Choose  > Add Calculation Indicator. Name the added column as Time Interval (Day), enter the formula DATESUBDATE(Contract Signing Time,Registration Time,"d") and click OK.

Demonstration

Drag the Time Interval (Day) field into the analysis area and the demonstration is shown in the following figure.