Struggling to get the following functionality into a base and hoping you can help a novice here.
We are attempting to use Airtable to track & visualise AWS logs for interactions with our service.
I the graph above I have outlined a rough schematic on what we are aiming to achieve however we are running into issues with tracking on a daily basis.
I’m not sure how to structure our base so that we can gain the ability filter by day, see which products were trending, measure performance based on view count and feed that back to the client’s tag.
Ideally we want to enable our clients to change a date field and see the product list re-order as such, with views, revenue etc following.
We can populate the records via an API, we are just struggling with the base design.