We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Show the last updated time in dashboard or widget based on the database column

How to show Timespan for last update time using single/multiple data source in Dashboard Viewer?

The label parameter has function named asTimeSpan which returns the time difference between the current time and the dashboard/widget last updated time in the Dashboard Viewer. Refer the article, to know more about TimeSpan usage in the Dashboard Viewer. Also, the label parameter has the functions called as MAX and MIN which gives the maximum and minimum value for the selected database column respectively.

To configure the timespan parameter in the Heading, Subheading, and Description section of the widget, refer the below syntax by using single or multiple data source(s) with combination of TimeSpan and Max functions support.

Using single data source,

Syntax: {{:TimeSpan(max(Database_DateColumnName))}} where no need to define the data source name along with column name (of type Date-Time)

For example, heading of the Sales-Map widget can be,

Sales by country - Updated on {{:TimeSpan(max(InvoiceDate))}} ago

The maximum date of selected date column will be shown, while previewing the dashboard.

Using multiple data source(s),

Syntax:

 {{:TimeSpan(max(DataSourceName.DateColumnName))}} - when it is used to more than one data source and same date column

or

{{:TimeSpan(max(DateColumnName))}} – when it is used to more than one data source and different date column

For example, heading of the widget:

Country vs Orders - Updated on {{:TimeSpan(max(OrdersDS.OrderDate))}} ago

Heading of the widget as Sales by country – Updated on {{:TimeSpan(max(WorldCarSalesDS.OrderDate))}} ago

and it will show in the Dashboard Viewer like below:

 

Notes:

Data source name is not required to mention in timespan parameters, when using single data source or more than one data source with unique date column name(s) in each data source.

Must have mentioned the data source name in timespan parameters, when using more than one data source with same date column names.

 

 

Article ID: Published Date: Last Revised Date: Platform: Control:
8173 11/24/2017 11/24/2017 Dashboard Platform Dashboard Viewer
Did you find this information helpful?
Add Comment
You must log in to leave a comment

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.