Do i need to build an app?

Hi,
Not sure this post belongs here…
I have a board that collects manufacturing data
https://view.monday.com/206785215-09de7b40656ee79c5947f16457a580cb
I would like to create a dashboard that automatically shows:
Total Meters and total KG for - yesterday, last week, last month
This cannot be done using dashboards, as dashboard don’t support automatically filtering the data (by day, week month) or showing data from “yesterday”
so, my question is, how can i create a custom automation that creates such a a dashboard? thanks