Hello, I want to add the latest Dataset Refresh by considering the maximum of a date column in my dataset. I tried achieving this via an Insight but I am getting a wrong date value for the same. I even created a calculated field that gives me the max(date column) but do not know how to use it. Can …

Hi Tanisha, Have you ever tried calculated field for this? I could do that via these steps: Creating a calculated field as below: Last Updated = max(date column) add a table to the sheet and add “Last Updated” field to value Change the format and and change the format and column name as required …

Hello, Also sharing error message I receive upon trying to rank the dates. attaching screenshot below: [image] . Below is a screenshot showing exactly what my narrative says: [image]

Hi Farid! This works perfectly! :slight_smile: Thanks… Regards Tanisha

Dataset Refresh Time

Q&A

Tanisha_Shetty June 13, 2022, 6:16pm 3

Update: I have accomplished this with the help of SQL. I’m looking to do this purely visually

Last Updated time of dataset not working

Topic		Replies	Views
Adding refresh date time stamp in custom narrative Q&A quick-sight , calculations	5	1371	March 27, 2023
Get the latest value based on the latest date Q&A quick-sight , calculations	12	2848	April 11, 2024
Max(date) not working Q&A date , quick-sight	12	765	June 5, 2023
Getting the latest value on a date Q&A quick-sight , calculations , Business-Intelligence-Engineer	4	81	March 28, 2025
To show the latest data availbel date Q&A quick-sight	5	351	September 26, 2025

Dataset Refresh Time

Related topics