Do i need to build an app?

Not sure this post belongs here…
I have a board that collects manufacturing data
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

I haven’t worked with it much. But, you might want to checkout the new app view “Pivot Board”