Hi @User2024 ,
I don't know if I am understanding it correctly, but what you are describing might be best solved by creating another view. (Getting started with Airtable views).
The benefit of creating a view is that you are still looking at the same data, just in a different way. Thus, if you edit the data in any one view, you also edit it in all the other ones.
You can create a new view by clicking on the + sign on the left bottom of the table. Then you can Filter by date using the "Filter" button and then "Group" by product, to see where your customers went.
Let me know whether this solves your problem 🙂
Best,
Patrick @Monino Solutions @
Assuming a time period here is a month, quarter, etc, then you could try doing this with a formula field formatted to time period you want. You could then set that formula field to output as single select options and select the time periods from there:

Link to base
Not sure if I've correctly understood your problem though!
What if I want to do like, view data points from the last 3 months and also view data points from the last month?