Filtering data from the archive / main collection - based on the date selected in date dropdown

Due to the document size and count, keeping only 60 days of data in our main collection, before 60 days of data has been moved to archive collection. Now the requirement is in the metabase dashboard if I select the date range within 60 days mean system should fetch the data from the main collection, if the selected date range is beyond 60 days mean system should fetch the data from the archive collection.

please help me with this ...

I think you’re using mongo, if so, build a view in the database

we were distributed the data due to the size, if i go with view i will face the same performance issue