Archive a chart

[Tyrone]

Is there any way to archive a chart in airtable?

I created some graphs using the airtable interfaces, the point is that one of these graphs represents how much I spent on each category in the current year until the current moment, so when the year turns, this graph is reset.

I would like to be able to archive it or "freeze" it within the airtable itself, so I would have a year-by-year history to analyze in which categories I spent the most in that particular year.

If it were possible, I would like an automation to copy this graph and archive this copy on December 31st, since on the first day the information will be reset.

 If this function doesn't exist yet, please think about implementing it, it would really be very useful.

[wcSingular]

I would try to create a filter for graph and showing only the information related with the year I want.

[Tyrone]

This doesn't work because this graph shows me the expenses I had in the current year until today, the field to which it is linked is constantly recalculating the values, and as I need the categories separated in this way, a filter doesn't work.

The issue is that, when the year turns, the field with the amounts spent by category will reset to zero and the count will start again, and then I won't have a history of previous years.

Thank you very much for the suggestion.

[TheTimeSavingCo]

I don't think so I'm afraid.  You're probably going to need to make changes to your data structure to handle displaying stuff historically