Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Archive a chart

Topic Labels: Automations Base design Data
458 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Tyrone
4 - Data Explorer
4 - Data Explorer

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.

Captura de tela 2024-08-06 144812.jpg

 

3 Replies 3
wcSingular
4 - Data Explorer
4 - Data Explorer

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

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.

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