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]

Thanks @seinchyi ,This worked for me. I Appreciate your time in helping me out

Hi Mounika, I’ve also encountered this question and I’ve also successfully used the above recommendation, but it doesn’t cover all my use cases. For example, when your SPICE dataset refreshes it doesn’t mean your data is current. I found that one of my redshift tables had a 18 hour lag due to other…

In order to reference that field in your insight, did you need to add a Computation like ‘Maximum’ or something? I think that’s what I’ve had to do in the past. Add a metric and your ‘now’ field (which you added in data prep) to the insight, then add a Maximum computation, then you can insert the …

Hey @Gal - you add this calculated field in your data prep screen (when editing a dataset). The entire formula is just ‘now()’, and can name it something like ‘last refresh date’. [image]

Hi @Jesse I am trying this today Dec.05.2022 at 5:40 pm PST. But the preview shows Dec 6, 2022. Can you please help me with this. [image] Thanks!

Hi @Goitom_Mehari - Be aware that now() returns the timestamp in UTC. You may want to add a calculated field and use addDateTime() to adjust the number of hours to be in your local time zone, then use this field instead.

Thanks @Jesse ! And thanks @Goitom_Mehari for circling back to let us know this is solved! :tada:

Hi @Jesse , Once the calculated field for now() is created, how do we include it in a narrative to display it? Is a specific insight required to be selected? Thanks

Adding Last data refresh timestamp in the Dashboard

Q&A

Gal April 7, 2022, 10:30am 6

Hi,
could you explain to me where to add the now() calculated field in order to see when spice updates? i dont undertsand where to put it in the dataset or in the analysis

How to add data refresh timestamp to dashboards?

Incremental Dataset Refresh Time Add into the Analysis /Dashboard

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