Hi,
I am building a KPI dashboard app and I would like some advice on how to build it in the most efficient way calculation-wise and therefore how to build my database.
Most of the time will be calculation like Gross Profit or Gross Profit Margin and similar, users will add their data once a month and they will have the visuals *charts", pretty simple.
Currently, my DBs is structured in the below way, can you please direct me to any documentation/source that can help me with the building or can you let me know for example if you suggest doing the calculations using custom states or in any other way?
Thank you!