Display time in dynamic

Users sometimes need to show "how long is the current time before a certain target time" or "current time".

1.1 Expected effect

Example 1.

The dashboard shows how many days remain until the current time of 2021-12-31, as shown in the following figure.

Example 2.

The dashboard displays the current time as shown in the following figure.

1.2 Implementation idea

Example 1: Use TODATE function to specify a countdown deadline, calculate the time difference between the deadline and the current time by adding a new column time difference, and convert the result to text type, and use the indicator card in the dashboard.

Example 2: Use the NOW function to get the current time and use the indicator card in the dashboard.

2. Example 1

2.1 Create a Self-Service dataset

Randomly select a data table in FineBI and randomly select the fields as shown below.

2.2 Specify the cut-off time for the countdown

Add a new "New column" step, name it "cut-off time", enter the formula: TODATE("2021-12-31"), and click "OK", as shown in the following figure.

2.3 Calculate count-down days

Add a new "New column" step, select "time difference", name it "count down days", time difference="count down days-current time" and in days, click "OK", as shown in the figure below.

2.4 Modify the day value field to text type

Since the count down days returned in 2.3 is of numeric type, subsequent use of the indicator card in the dashboard will result in an accumulation of count down days for all data rows, resulting in an error in the results, so it needs to be changed to a text type field, as shown below.

Rename and save the Self-Service dataset.

2.5 Create kpi indicator card

Create a dashboard and select the Self-Service dataset created above, select the "kpi indicator card" and drag the "count-down days_text field" field into the "Table Properties>text" column, as shown in the following figure.

Just modify the content of the text field.

2.6 Effect view

2.6.1 PC side

See Section 1.1 of this document for details.

2.6.2 Mobile side

3. Example 2

3.1 Calculate current time

Select a random data set to create a dashboard, enter the component editing interface, create a calculated field, change the name to "Current Time", enter the formulaNOW(), and click "OK", as shown in the following figure.

3.2 Create kpi indicator card

Select the "kpi indicator card" and drag the "Current Time" field into the "Table Properties>text" column, as shown in the following figure.

Set the calculated field display type to "Year, Month, Day, Hour, Minute, and Second", as shown below.

3.3 Effect view

3.3.1 PC side

See Section 1.1 of this document for details.

3.3.2 Mobile side