Adding current date and time

[Former Member]

In Xcelsius Dashboards is there a way to have the current time and date displayed? Currently I have it mapped to =NOW() in imported spreadsheet but it becomes static after the dashboard is open. All other data is updating as per the Refresh Every setting in the Data Manager

[Former Member · Accepted solution]

Hi Graeme,

Yes, you can have a dashboard show the current time.

You'll need a Label component and 2 History Components.

In cell A1 type this formula:

=IF(B1>0,NOW(),NOW())

In cell B2 type 0, and in cell B3 type 1

Set the Label component to Link to cell A1, and format it to display the time.

Set History Component 1 to Data = B2, Data Destination = B1, On Interval duration = 1 second

Set History Component 2 to Data = B3, Data Destination = B1, On Interval duration = 0.5 second

Preview the dashboard.

(Tested in Dashboards 4.1 SP6)

[former_member94732]

Hello Graeme,

The NOW() function does work and shows the correct DateTime when refreshing dashboard. It might not work properly within Excel, but does it show the static date/time when refreshing dashboard as well?

Thanks

Raman