Dashboard refresh time | Community
Skip to main content

Dashboard refresh time

  • February 27, 2019
  • 4 replies
  • 0 views

Is there a way to show the time a dashboard/query last updated?  I know the data refreshes hourly but the management would like to see the exact time of the update. 

4 replies

  • February 27, 2019

I asked the same question in a comment in this article.  It is really needed to know how old the data is that we are looking at in a dashboard.

https://explore.zendesk.com/hc/en-us/articles/360002118227?page=1#comment_360001776068

 


ZZ55
  • February 28, 2019

Hillary

No guarantee on the best way to do this but here goes.

We can estimate the last sync time by looking at the timestamp of the last ticket updated. 

First, create a new metric to calculate how many minutes have passed today since a ticket was updated.

 

For ROWS, add

  • Ticket ID
  • Ticket Updated - Timestamp

Filter

  • Ticket Updated - Timestamp is TODAY

 

Result Manipulation

 

This should give you a report like this:

 

To just display the timestamp, go to Chart Configuration> Columns  and hide the ticket and last update columns.

 

You can then add the final report to your dashboards.


Chris21
  • March 4, 2019

I hope there are plans to make this a little less convoluted. I'd like to just be able to add an element (similar to to a text field) that just adds the latest timestamp for that dash.


Delores
  • March 6, 2019

Hi everyone!

While there isn't a way to add a widget directly to the dashboard that tells you the last data sync, you can find the time of the last data sync by looking at the Dataset page.