Can we add timestamps in quicksight reports to show when the dataset was last refreshed

[Ganga]

1. can we add timestamps in quicksight reports to show when the dataset was last refreshed? I am using Amazon Aurora as database and dataset is spice and have a scheduled refresh for dataset whenever the views refresh.
   Also I tried using now() and its returning the current date time . Not the dataset refresh date .
2. Also is there any possibility to add another metric called report generated on?

[Nico]

Hi @Ganga

Adding Last data refresh timestamp in the Dashboard

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]

There is a similar question in the community, and the solution suggested is to create a calculated field in the dataset using now(). This will be persisted during the SPICE refresh, resulting in a field that stores the date of the last refresh.

Regarding your second question, when should the date be updated? Should it be updated manually, or would you like it to reflect the current date automatically? If you want the date to show the current date, you can add a calculated field using now() in the analysis. This way, the field will be dynamically updated every time the report is opened.

Best regards,
Nico

If this helped you, please mark my answer as solution. That helps the community to find solutions faster.