Hi guys,
How to get the update from dataset in text/label?
For example:
Last updated: 2024-06-10 11:50 (last updated from dataset)
Tks!!
Hi @July,
Are you looking to implement this timestamp on your dashboard? If so, please refer to this past topic discussion, where the steps on how to add are covered.
If this is what you are looking to accomplish, please mark as solution. If not, please provide some additional information on what you are looking to achieve.
Thank you!
1 Like
Hi @duncan
The past topic is so confused.
I did not get it.
I created a calculated field, but it is not show the hour as follow the spice update.
The calculated field show the actual date/hour, but I want to show the last update from spice
addDateTime(-3, ‘HH’, now())
Hey @July !
Got it, I misunderstood you at first!
Do you have SQL access to your datasource to run custom SQL? The easiest way that I have done this in the past is using the GETDATE function on my sql query.
This will return a timestamp of when the query was run, so it will be field showing the last refresh. You can add that field to a table on its own and style the table down to one cell.
Hello @duncan
No problem! 
My dataset is not a custom SQL, I’m afraid of creating a new dataset with the date field and losing all my calculated fields.
Is there a way to change the dataset to customize the SQL?
Thanks!
Hello @July,
Fair enough, I wouldn’t be too worried about disrupting your calculated fields using custom SQL. I would recommend creating a duplicate of your dataset and analysis and then creating the changes there for troubleshooting. That way you are not disrupting your current process.
Other than that, there is no way in console to get that timestamp into your analysis.
1 Like
I did it.
It worked
Thank you
1 Like