You may need to calculate the interval between two time fields, such as the interval between Contract Signing Time and Registration Time.
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
Create an analysis subject and upload the sample data.
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.
For the demonstration of this KPI card, see the second figure in section "Preview".
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.
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.
滑鼠選中內容,快速回饋問題
滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy