Display simulated together with empirical values in a chart

A place for Ventity software questions & answers
Post Reply
moudi
Senior Member
Posts: 69
Joined: Thu Nov 18, 2010 9:18 am
Vensim version: DSS

Display simulated together with empirical values in a chart

Post by moudi »

Hi

I would like to display simulated values together with empirical values in the same chart. How does this work? I assume that I have to specify time series data, but I do not succeed in using this table. To test it, I have constructed a simple test model (see attachment). Data are in the file "Cohort.xls" (in the Data folder). Thanks and best regards.
Test Data.zip
(14.68 KiB) Downloaded 363 times
tomfid
Administrator
Posts: 3804
Joined: Wed May 24, 2006 4:54 am

Re: Display simulated together with empirical values in a chart

Post by tomfid »

It should work, if you drag from the model variable and the data to connect them to the chart.

I'll modify your sample for an example.
tomfid
Administrator
Posts: 3804
Joined: Wed May 24, 2006 4:54 am

Re: Display simulated together with empirical values in a chart

Post by tomfid »

Here's an example.
Test Data (2).zip
(157.25 KiB) Downloaded 439 times
tomfid
Administrator
Posts: 3804
Joined: Wed May 24, 2006 4:54 am

Re: Display simulated together with empirical values in a chart

Post by tomfid »

You need 3 parts:

1. The data has to be formatted with a key attribute(s) and DateTime column:
data_format.png
data_format.png (20.02 KiB) Viewed 9262 times
2. Then you can generate a mapping, first detecting the types, then generating a data entity:
mapping.png
mapping.png (41.13 KiB) Viewed 9262 times
3. That gets you a data entitytype:
data_entity.png
data_entity.png (37.66 KiB) Viewed 9262 times
Then you can reference the data elsewhere:
reference_chart.png
reference_chart.png (46.55 KiB) Viewed 9262 times
We should permit singular data, but at the moment we don't.
moudi
Senior Member
Posts: 69
Joined: Thu Nov 18, 2010 9:18 am
Vensim version: DSS

Re: Display simulated together with empirical values in a chart

Post by moudi »

sorry for the trouble... when I want to download the model, I get the message that the attachment does not exist anymore???
Administrator
Super Administrator
Posts: 4573
Joined: Wed Mar 05, 2003 3:10 am

Re: Display simulated together with empirical values in a chart

Post by Administrator »

You should be able to download it now.
Advice to posters seeking help (it really helps us to help you)
http://www.ventanasystems.co.uk/forum/v ... f=2&t=4391

Units are important!
http://www.bbc.co.uk/news/magazine-27509559
moudi
Senior Member
Posts: 69
Joined: Thu Nov 18, 2010 9:18 am
Vensim version: DSS

Re: Display simulated together with empirical values in a chart

Post by moudi »

Thanks, it works.
Is it possible to rename the results in the legend? The names appear rather "technical" and I would like to give them more meaningful names. I assume that it cannot be done in the legend, but just wanted to ask.
tomfid
Administrator
Posts: 3804
Joined: Wed May 24, 2006 4:54 am

Re: Display simulated together with empirical values in a chart

Post by tomfid »

I don't think so - you can change the title, but the varnames are automatic. You could rename the variable itself, of course.
moudi
Senior Member
Posts: 69
Joined: Thu Nov 18, 2010 9:18 am
Vensim version: DSS

Re: Display simulated together with empirical values in a chart

Post by moudi »

I recently had a problem with creating a data entitytype and get an error message, that the entitytype "Interventions" (which is the name of the table in the data file) has no key attribute. This problem did not occur in the previous test. What might be the problem?
Problem with data entitytype 180314.PNG
Problem with data entitytype 180314.PNG (316.25 KiB) Viewed 9099 times
tomfid
Administrator
Posts: 3804
Joined: Wed May 24, 2006 4:54 am

Re: Display simulated together with empirical values in a chart

Post by tomfid »

I'd guess the original version of the data entity was created from a dataset without the Cohort key attribute, so it can't be updated. You could try (a) adding the Cohort key attribute to the entity manually, or (b) delete it (the entity, not the data & mapping) and recreate.
Post Reply