Insight "snapshots"

[pauldambra]

Is your feature request related to a problem?

When looking at an insight (on a dashboard) I can capture context with an annotation. But I might want to capture the state of the graph right now so I can see how it differs in future

Describe the solution you'd like

Save a "snapshot" of an insight or a dashboard so I can view it in future.

I'd be able to give it a name. And in future see the name and the date I created it.

I could view the snapshot series alongside the current series.

The state of the insight is JSON so we could store a new model in the DB with a foreign key to the Insight/Dashboard and the results of the insight at the point it was saved. We'd limit the number of snapshots allowed per insight/dashboard

Describe alternatives you've considered

Letting someone create a text card with an image export of an insight so it could be placed alongside the "live" insight

Additional context

Thank you for your feature request – we love each and every one!

[pauldambra]

Another use of this would be treating Dashboards like reports. "Here are the january numbers"

[mariusandra]

Basically caching into postgres? 🤔 🙈

[pauldambra]

Basically caching into postgres?

Yes...

But with the bonus that it doesn't need to be kept fresh like the fun cache!