How to show 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.
While previewing the dashboard, it will be displayed in the Dashboard Viewer as shown in the following screenshot.
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)}}
While previewing the dashboard, the maximum date of the selected date column will be shown.
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.
While previewing the dashboard, the TimeSpan for the last updated time will be shown in the Dashboard Viewer as follows.
After one minute, TimeSpan value gets updated automatically.
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.
It’s dashboard preview in the Dashboard Viewer is obtained as follows.
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
Now, the preview of the dashboard is obtained as follows.
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
|
Notes
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, …
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.