Explore recipe: Creating a last refresh timestamp



image avatar

Rob Stack

Zendesk Documentation Team

Edited Mar 05, 2025


0

13

13 comments

Dave Symonds It just lets you know how out-of-date the dashboard is, if you have a plan where it updates once an hour, it's not on the hour, so it can be hard when looking at a Dashboard to tell when it last pulled in fresh data. 

0


Question:  Whats the value of the Last ticket updated Mins represent.  I thought it would change as time progressed as it calculates against now?

0


Why don't you just expose the value for use so it can be used so there is not need to write an convoluted process that actually returns an inaccurate value?

0


Hi Monica, the correct setting should be MIN. I've updated the screenshot so that it matches the instructions!

0


The article image has MED for the metric, but the instructions have you only allow MIN. Which is the correct setting?

0


Hi CJ Johnson, I've restored all the images in the article—sorry for the confusion!

0


All of the images were removed from this article, makes it rather tricky to tell what it is instructing.

0


Hey all,

I am having the same issues. This recipe isn't working for me and is showing a timestamp from 2019. I'd love some help or a resolution.

Thanks,

Sam

0


Hi all, I just wanted to post a quick note to clarify how this recipe works, in light of a few of the comments above:

  • The built-in dataset sync timestamp in the upper left of the query builder measures the last time Explore's behind-the-scenes process ran to update data, regardless of whether there was actually new data to be updated.
  • The timestamp created by this recipe, on the other hand, measures the last time a ticket was updated as long as the update happened before the last dataset sync. (Otherwise Explore wouldn't know about that ticket update because the sync hasn't run yet.)

So while this recipe isn't an exact replacement for the dataset sync timestamp, it's still a useful way for dashboard viewers to know approximately how current the info on a dashboard is. Hope that helps! 

0


Hi Brandon, 

Apologies for the delayed response. In order for us to properly investigate this, I've created a ticket on your behalf to look into this further. 

0


Sign in to leave a comment.