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

Display simulated together with empirical values in a chart

Post by moudi » Tue Feb 27, 2018 8:24 am

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 58 times

tomfid
Administrator
Posts: 2373
Joined: Wed May 24, 2006 4:54 am

Re: Display simulated together with empirical values in a chart

Post by tomfid » Tue Feb 27, 2018 4:53 pm

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: 2373
Joined: Wed May 24, 2006 4:54 am

Re: Display simulated together with empirical values in a chart

Post by tomfid » Tue Feb 27, 2018 6:04 pm

Here's an example.
Test Data (2).zip
(157.25 KiB) Downloaded 82 times

tomfid
Administrator
Posts: 2373
Joined: Wed May 24, 2006 4:54 am

Re: Display simulated together with empirical values in a chart

Post by tomfid » Tue Feb 27, 2018 6:07 pm

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 1397 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 1397 times
3. That gets you a data entitytype:
data_entity.png
data_entity.png (37.66 KiB) Viewed 1397 times
Then you can reference the data elsewhere:
reference_chart.png
reference_chart.png (46.55 KiB) Viewed 1397 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

Re: Display simulated together with empirical values in a chart

Post by moudi » Mon Mar 05, 2018 1:29 pm

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: 3094
Joined: Wed Mar 05, 2003 3:10 am

Re: Display simulated together with empirical values in a chart

Post by Administrator » Mon Mar 05, 2018 7:57 pm

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

Re: Display simulated together with empirical values in a chart

Post by moudi » Wed Mar 07, 2018 8:06 am

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: 2373
Joined: Wed May 24, 2006 4:54 am

Re: Display simulated together with empirical values in a chart

Post by tomfid » Sat Mar 10, 2018 1:56 am

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

Re: Display simulated together with empirical values in a chart

Post by moudi » Wed Mar 14, 2018 9:48 am

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 1234 times

tomfid
Administrator
Posts: 2373
Joined: Wed May 24, 2006 4:54 am

Re: Display simulated together with empirical values in a chart

Post by tomfid » Wed Mar 14, 2018 3:22 pm

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