cancel
Showing results for 
Search instead for 
Did you mean: 
Warehousing & Analytics
Engage in discussions on data warehousing, analytics, and BI solutions within the Databricks Community. Share insights, tips, and best practices for leveraging data for informed decision-making.
cancel
Showing results for 
Search instead for 
Did you mean: 

How can I tell my Dashboard visualizations aren't stale?

mark_ott
Databricks Employee
Databricks Employee

With AI/BI Dashboards, a best practice is for the creator/owner to 'Schedule' the Dashboard to rerun the underlying datasets when changes have occurred. This ensures the Visualizations are rendered with the freshest data.  But users still will question if the Charts are fresh.  

How about putting in a Visualization confirming the data is fresh?  I created a simple 'Counter' Visualization with the code seen in below screen shot.  This table sources from one of the Dashboard datasets most likely to be stale.  I then created a 'Conditional Style' and entered a simple equation to color code the date the Dashboard was last Refreshed. If the date displays 'Green', users know there is no stale Dashboard charts. If the date displays 'Red', the user simply clicks the 'Dashboard Refresh' button to re-render the Visualizations. 

Viola.  Problem solved. Users now definitively know they can trust the Charts.  Who knew?

mark_ott_1-1769107746865.png

 

 

 

 

0 REPLIES 0