AnsweredAssumed Answered

Data Structure for Value By Month

Question asked by FNCMapping on Jul 16, 2019

Looking for input on the best way to structure my data.  I manage 10's of 1,000's of assets.  Each asset has a net income by month.  So for example:

AssetJanFebMarchApril
1100200300400
2200300100500

 

If I wanted to display a chart, or do any type of query what is the best way to structure the data.  The example above has the columns as integers or doubles.  Another method could be below.

DateAssetIncome
01/01/20191100
01/01/20192200
02/01/20191200
02/01/20192300

This would allow date field searches and structure.  But would duplicate the fields.  I manage over 100,000 assets, so for one calendar year I would have a table with over a million records.  

 

Any ideas on the best way to structure my data.  Ultimately, I would like to create charts showing monthly income in a web app or through Ops Dashboard

Outcomes