Check out these caching examples if you need a better understanding of how dashboard cache duration and refresh rate work in Chartio.
Create a pacing dashboard
Pacing dashboards have charts on them to track hypothetical values that are team goals. The pacer data point is defined by you and your team.
Filter charts with custom Dropdowns
Add custom data which isn't located in your database to your charts and variables to further customize your dashboards.
Leverage pre-built dashboards
To take advantage of another user's dashboard you can utilize filters and variables to understand and filter the data.
Prime cache with Snapshots
Use Snapshots to schedule queries to run right after your ETL process has completed to prime your cache, reducing demand on your database during peak hours