Is there a way to see when the dataset was last refreshed/updated inside of a dashboard? I was trying to get the current date, and compare it to the last date my date field has and set a flag to say “Updated” if ==, and “Not Updated” if current date is more recent than my field. I can’t find a way for this to work. Is there any other way to set a flag or just display last update of the dataset inside of a dashboard. This is so people who dont have permission to view the details on the dataset can have a way of seeing the last update via dashboard.
If you are referring to SPICE refresh time. may be you could see this old post which may suffice your need.
I personally would prefer to show last refresh time stamp on the dashboard rather then flagging saying ‘Updated’ or ‘Not Updated’ in the dashboard.
Nevertheless, let me know it helped.
I think i might have done it wrong. I just created a calculated field in my analyses, with now(). This returns the current date. Am i supposed to create the calculated field in the actual “edit” of a dataset
(Datasets > edit > add calculated field)?
I’m new to QuickSight so sorry if the questions seem extremely obvious to answer.
Additionally, is there a way to do it through the analyses area? Reasoning for this is because on some datasets, i don’t have permission to edit / view the back-end of it, only access through analyses. So creating this function for some datasets may not be possible until i have permissions to “edit”.
Thanks for any replies
Yes, you need to create the calculated field in the data set using now() and publish it to get the changes reflected in Dashboard going forward. If you create the same field in the analysis section you may get the system date time (local).
I am not aware if you could bring in the desired result in the analysis section yet.
hope this helps.