Caching Dashboard for multiple values

[ylis]

Hi,

I have a dashboard with a filter name product with values [A, B, C].

I would like to create automatic refresh every 12 hours for each one of the values and save it in cache, so for any of the values, the results would be stored in cache, and users wouldn’t have to wait while the query is running in front of the DB.

So in the following scenario, a user named Mike:

1. Open the dashboard
2. Choose in product value A
3. Run the dashboard and has immediate results, without loading time.
4. Right after, he picks in product value C
5. Run the dashboard and he has immediate results, without loading time.
6. Right after, he picks in product value B
7. Run the dashboard and has immediate results, without loading time.

How can I create it? is it possible?

Thanks,

Yana