Data entity type collection aggregates

A place for Ventity software questions & answers
Post Reply
cobleg
Member
Posts: 21
Joined: Wed Oct 06, 2021 6:28 am
Vensim version: Ventity

Data entity type collection aggregates

Post by cobleg »

I have created a data entity type: Residential
It has the following defined variables: Load Area ID [attribute, key]; DateTime; Export [data variable]; Import [data variable]; NMI Count [data variable]
These are time series for the periods 15/June/2008 to 15/6/2019. Note this date format in Excel is dd/mmm/yyyy. I have entered the Run Control dates in this date format: mm/dd/yyyy.
The Excel data is organised in Tidy Format and the time series dates. Here are the first few rows:

LOAD_AREA_ID DateTime EXPORT IMPORT NMI_COUNT Export_Change Import_Change NMI_Change
BUNBURY 15/06/2008 90935501.1 28651.7 192974 0 0 0
BUNBURY 15/06/2009 94956248.9 96297.6 200340 4020747.8 67645.9 7366
BUNBURY 15/06/2010 96672869.9 488489.3 207439 1716621 392191.7 7099
BUNBURY 15/06/2011 95532684.8 2176948.9 214797 -1140185.1 1688459.6 7358
BUNBURY 15/06/2012 95763924.9 4175002.8 220316 231240.1 1998053.9 5519
BUNBURY 15/06/2013 96403281 4936661.2 225652 639356.1 761658.4 5336
BUNBURY 15/06/2014 95491404.2 6038932.6 231962 -911876.8 102271.4 6310
BUNBURY 15/06/2015 98558013.5 7469816.2 239065 3066609.3 1430883.6 7103


I have successfully imported these from an Excel workbook named Residential.xlsx and mapped them to the data entity variables.

I now want to create aggregates (e.g. sum, average) of these. However, the aggregates are reading zero for each time series variable.

Is it possible to create aggregates from data entity type variables? If yes, any idea what I am doing incorrectly?
tomfid
Administrator
Posts: 3806
Joined: Wed May 24, 2006 4:54 am

Re: Data entity type collection aggregates

Post by tomfid »

Unfortunately it's not yet possible. You can reference the data into a regular entity and aggregate it there.
cobleg
Member
Posts: 21
Joined: Wed Oct 06, 2021 6:28 am
Vensim version: Ventity

Re: Data entity type collection aggregates

Post by cobleg »

OK, thanks for the fast reply!
Post Reply