Hey Abbas.
What you might try is to restructure how you’re storing your data:
- Right now you’ve got 1 record per KPI
Maybe instead switch your thinking to having each record represent a DATE.
- This is a common strategy employed by app builders
- It allows you to “roll up” the data from a date into a record
- You can then do that over time, and see how numbers have changed easily
How?
- Restructure your table so that you’ve got a column for each KPI you want to store; also include anything else important, like the date, maybe a list of IDs or a count of something… anything you might need for long-term analysis later
- Create an automation that runs on a schedule, that creates a record in the Daily_KPI table