I was wondering if there is a way to permanently cache a dashboard when the date picked in the dashboard filter is not the current date. I know there might be a couple of ways in order to achieve this, for eg. by making two separate dashboard (one for live and one for static possibly).
The ultimate goal here is to optimize the dashboard processing requirements/speed. I was just wondering if this may be possible on a dashboard level rather than caching questions based on their run time which ends up becoming a universal parameter for all questions/dashboards.
Additionally if different dashboards have different requirements, can we not choose the dashboard as a whole to have its own parameter for caching rather than have it on a question level?
I know its a broad question and invites various different solutions. I’m just curious how more experienced Metabase users may have approached this problem.
Any input would be greatly appreciated.