Hello Friends,
I have tried to show the last refreshed time of dataset in my dashboard and now I can able to see the date and time but after that my dataset was refreshed again, while the dashboard date and time was not updated as expected. I have created a calculated field in my dataset and used it in my analysis to show the date and time. Can anyone please help me on this issue?, thank you.
Try adding a now() calculated field at the dataset level (Edit Dataset). This timestamp will be updated every time the dataset is refreshed in SPICE. You can then use it in your dashboard to display the last SPICE refresh date.
Please refer the below community posts this might be helpful for you.
I presume you already have used now() in your dataset level to get the dataset refresh time. If your dataset has incremental refresh schedules then there may be many time stamps for the refresh time calculated field.
I use the following approach to address the same.
In the dataset create a Calculated Field as follows
In the Analysis we need to create two calculated fields
In the Insight Visual where we use the last_refreshed_time calculated field include a filter based on Max Refresh Time Flag as follows
Customize the Narrative to show the Maximum.timeValue.formattedValue
Additionally ensure that the Insight visual does not have any other filters from the dataset applied except the Max Refresh Time Flag.
Thank you for the solution. I can now see the last refreshed date, but the time is missing. Did I miss something?
You can change the aggregation of the field to Minute. Default is it aggregates to date. You need to do this in the field well
Now I can see the exact date as I expected, thank you so much for the clear instruction and prompt reply!
Can you mark this as a solution so in case someone runs into a similar issue they can use this post?
@Giridhar.Prabhu Also, I’m trying to add 10 hours to convert the time from UTC to AEST in an Insight visual. However, I get an error when using the addDateTime function directly inside the Insight narrative. Is it possible to add hours to a timestamp within an Insight visual?
yeah, got the expected time, thanks again!
