Hi, we have requirement to add the last data refresh timestamp in the dashboard. I am wondering if there is any way to have this as part of dashboard. Thanks, Mounika.

I’m assuming you are referring to SPICE refresh time? Try adding a now() calculated field at the edit data step and this timestamp will be refreshed everytime SPICE refreshes. You can then use this to display in your dashboard as SPICE last refresh date. [image]

Hello @saras - Can you please try to use Maximum as the calculation and use that Refresh Time field to create the narrative. I would show up something like below. Hope this helps! [image]

Another option to get dashboard refresh datetime: Using a lambda function API (using lists-data-sets) to query timestamp for dataset refresh and display it in custom visual of Quick Sight. This lambda function is triggered on event of dashboard load via API gateway. You may pass dataset names used…

Another direct method is built-in last refreshed time for underlying datasets from dashboard. Dashboard shows last refresh time for all underlying datasets. Dashboard users can see it by clicking on datasource icon from right top of dashboard as shown in figure below. [image]

Hi @sagmukhe , it worked, I do get the correct date. I get the day but not the time though, is there a way to add the time as well? [image] In case other needs this: I also had to add the calculated field with now() to the time field of the Insight.

@saras As long as you use the .formattedValue variable in your Insight, then when you set the format of that field either in the Field Well or from the field list itself, the format should be reflected.

Do yuo mean add a second calculated field? now() returned UTC time. but addDateTime() alone gives me an error

Hi @kawind - you can do it all in one calculated field. In your dataset you would add a field like: addDateTime(X, ‘HH’, now()) Where X is the hour adjustment from UTC.

@ Jesse, In my dataset I have last updated week which is in integer, I am trying to populate “data available till : XX week”. I couldn’t able to do this, can you suggest me the way forward

[image] @Jesse , my dataset don’t have date field, with out date field i couldn’t able to get the last updated week

Adding Last data refresh timestamp in the Dashboard

Q&A

Jesse May 23, 2023, 7:57pm 21

Hi @sbaskax if the week is an integer field, create an Insight and use the Maximum computation, then insert the formattedValue variable into your narrative (with whatever other text you want).

How to add data refresh timestamp to dashboards?

Topic		Replies	Views
Last data refresh complete timestamp Q&A formatting , date , quick-sight , Business-Intelligence-Engineer	6	307	December 10, 2024
Last Updated time of dataset not working Q&A developer , quick-sight , qls-community	12	135	December 19, 2025
Last update Q&A formatting , quick-sight	7	633	March 17, 2023
Incremental Dataset Refresh Time Add into the Analysis /Dashboard Q&A data-source , analysis , quick-sight , calculations , Business-Intelligence-Engineer	5	115	October 24, 2024
Checking to see if dataset is update on dashboard view Q&A date , quick-sight , Business-Intelligence-Engineer	6	670	April 9, 2025

Adding Last data refresh timestamp in the Dashboard

Related topics