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. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Last updated time in Dashboard viewer

Platform: Dashboard Platform |
Control: Dashboard SDK |
Published Date: September 21, 2017 |
Last Revised Date: May 8, 2019

Last updated time in the Dashboard or Widget header in the Dashboard Viewer

To configure the last updated time in the Heading or Subheading and Description section of the widget, use the following syntax in the Label Parameter while composing the dashboard.

Syntax: {{:UpdatedTime}}

For example, the header text of the widget can be Top 5 manufacturers - Last updated on {{:UpdatedTime}}

The following image illustrates how to add the above syntax in the widget heading of the Dashboard Designer.

Last updated time syntax in widget header

While previewing the dashboard, it will be displayed in the Dashboard Viewer as shown in the following screenshot.

Designer preview

To show the last updated time based on the data column of database, which holds the information about last modified or updated database, use the following syntax.

Syntax: {{:max(UpdateDateTime_Column)}}

For example, Sale by country - {{:max(Date)}}

 A screenshot of a cell phone Description generated with very high confidenceWhile previewing the dashboard, the maximum date of the selected date column will be shown.

 

A close up of a map Description generated with high confidence

How to show TimeSpan for the Last Updated Time in Dashboard Viewer

TimeSpan returns the difference between the current time and the dashboard/widget updated time.

To configure the timespan parameter in the Heading, Subheading, and Description sections of the widget, refer to the following syntax.

Syntax: {{:TimeSpan(UpdatedTime)}}: It is used to show the last updated time as TimeSpan value from now.

For example, the Heading of the widget as Sales by country - Updated {{:TimeSpan(UpdatedTime)}} ago.

 

Last update time in sales by country in widget header

While previewing the dashboard, the TimeSpan for the last updated time will be shown in the Dashboard Viewer as follows.

Last updated time, Timespan displayed in Viewer.

 

After one minute, TimeSpan value gets updated automatically.

 

A close up of a map Description generated with high confidence

Or

Syntax: {{:TimeSpan(max(DatabaseUpdatedTimeColumn))}}: It is used to show the timespan value of database modified time from now.

For example, Sales by country – Updated {{:TimeSpan(max(Date))}} ago.

 

Last update time in sales by country in widget header

It’s dashboard preview in the Dashboard Viewer is obtained as follows.

 

A close up of a map Description generated with high confidence

To get the combination of Hours and Minutes based on TimeSpan value, refer to the given example.

Syntax: Sales by country - Last Updated on {{:TimeSpanHours(UpdatedTime)}} {{:TimeSpanMinutes(UpdatedTime)}} ago

Last update time in sales by country in widget header

 

Now, the preview of the dashboard is obtained as follows.

 

A close up of a map Description generated with high confidence

Functions supported in the TimeSpan parameter

The following table has the explanation for each syntax to configure the TimeSpan value based on last updated time.

Functions Name

Description

Example(s)

 

TimeSpan

This function returns the value as string. The value is the difference between UpdatedTime and current date.

Updated {{:TimeSpan(UpdatedTime)}} ago

 

TimeSpanMinutes

This function returns the value, which will be minute as string. The value is the difference between UpdatedTime and current date.

Updated {{:TimeSpanMinutes(UpdatedTime)}} ago

 

TimeSpanHours

This function returns the value, which will be an hour as string. The value is the difference between UpdatedTime and current date.

Updated {{:TimeSpanHours(UpdatedTime)}} ago

 

TimeSpanDays

This function returns the value, which will be day as string. The value is the difference between UpdatedTime and current date.

Updated {{:TimeSpanDays(UpdatedTime)}} ago

 

TimeSpanWeeks

This function returns the value, which will be week as string. The value is the difference between UpdatedTime and current date.

Updated {{:TimeSpanWeeks(UpdatedTime)}} ago

 

TimeSpanMonths

This function returns the value, which will be month as string. The value is the difference between UpdatedTime and current date.

Updated {{:TimeSpanMonths(UpdatedTime)}} ago

 

TimeSpanYears

This function returns the value, which will be year as string. The value is the difference between UpdatedTime and current date.

Updated {{:TimeSpanYears(UpdatedTime)}} ago

TimeSpanInMinutes

This function returns the value, which will be minute as string. The value is the difference between UpdatedTime and current date.

Updated

{{:TimeSpanInMinutes(UpdatedTime)}} ago

TimeSpanInHours

This function returns the value, which will be hours as string. The value is the difference between UpdatedTime and current date.

Updated

{{:TimeSpanInHours(UpdatedTime)}} ago

 

The following table has the explanation for each syntax to configure the TimeSpan value based on the database updated time stored as a data column.

Function Name

Description

Example(s)

 

TimeSpan

This function returns the value as string. The value is the difference between date time of date column and current date time.

Updated {{:TimeSpan(Date)}} ago

 

TimeSpanMinutes

This function returns the value, which will be minute as string. The value is the difference between date time of date column and current date time.

Updated {{:TimeSpanMinutes(Date)}} ago

 

TimeSpanHours

This function returns the value, which will be hour as string. The value is the difference between date time of date column and current date time.

Updated {{:TimeSpanHours(Date)}} ago

 

TimeSpanDays

This function returns the value, which will be day as string. The value is the difference between date time of date column and current date time.

Updated {{:TimeSpanDays(Date)}} ago

 

TimeSpanWeeks

This function returns the value, which will be week as string. The

value is the difference between date time of date column and current date time.

Updated {{:TimeSpanWeeks(Date)}} ago

 

TimeSpanMonths

This function returns the value, which will be month as string. The

value is the difference between date time of date column and current date time.

Updated {{:TimeSpanMonths(Date)}} ago

 

TimeSpanYears

This function returns the value, which will be year as string. The value is the difference between date time of date column and current date time.

Updated {{:TimeSpanYears(Date)}} ago

TimeSpan Maximum

This function returns the value as string. The value is the difference between maximum date of date column and current date time.

Updated {{:TimeSpan(max(Date))}} ago

 

TimeSpanMinutes Maximum

This function returns the value, which will be minute as string. The

value is the difference between maximum date of date column and current date time.

Updated {{:TimeSpanMinutes(max(Date))}} ago

 

 

TimeSpanHours Maximum

This function returns the value, which will be hour as string. The

value is the difference between maximum date of date column and current date time.

Updated {{:TimeSpanHours(max(Date))}} ago

 

TimeSpanDays Maximum

This function returns the value, which will be day as string. The

value is the difference between maximum date of date column and current date time.

Updated {{:TimeSpanDays(max(Date))}} ago

 

TimeSpanWeeks Maximum

This function returns the value, which will be week as string. The value is the difference between maximum date of date column and current date time.

Updated {{:TimeSpanWeeks(max(Date))}} ago

 

TimeSpanMonths Maximum

This function returns the value, which will be month as string. The value is the difference between maximum date of date column and current date time.

Updated {{:TimeSpanMonths(max(Date))}} ago

 

TimeSpanYears Maximum

This function returns the value, which will be year as string. The value is the difference between maximum date of date column and current date time.

Updated {{:TimeSpanYears(max(Date))}} ago

 

Note:

The value will be reset when auto or manual refresh of the dashboard, widget, and browser is performed.

TimeSpan value gets updated for each minute when there is no auto, manual, or browser refresh action.

TimeSpanMinutes: This parameter will be updated as 59 Minutes and again start with 0 Minute.

For example, 58 Minutes, 59 Minutes, 0 Minute, 1 Minute ….. 59 Minutes, 0 Minute, 1 Minute, …

TimeSpanHours: This parameter will be updated as 23 Hours and again start with 0 Hour.

For example, 22 Hours, 23 Hours, 0 Hour, 1 Hour ….. 23 Hours, 0 Hour, 1 Hour, …

TimeSpanDays: This parameter will be updated as 6 Days and again start with 0 Day.

For example, 5 Days, 6 Days, 0 Day, 1 Hour ….. 6 Days, 0 Day, 1 Day, …

TimeSpanWeeks: This parameter will be updated as 3 Weeks and again start with 0 Week.

For example, 3 Weeks, 0 Week, 1 Week, 2 weeks, 3 Weeks, 0 Week, 1 Week, ...

TimeSpanMonths: This parameter will be updated as 11 Months and again start with 0 Month.

For example, 11 Months, 0 Month, 1 Month, 2 Months …. 11 Months, 0 Month, 1 Month, …

TimeSpanYears: This parameter will be updated as 0 Year, 1 Year, 2 Years, 3 Years, …

TimeSpanInMinutes: This parameter will be updated as 60 Minutes after 59 Minutes.

For example, 58 Minutes, 59 Minutes, 60 Minutes, 61 Minutes, …

TimeSpanInHours: This parameter will be updated as 24 Hours after 23 Hours.

For example, 23 Hours, 24 Hours, 25 Hours, …

 

 
ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon 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.Close Icon