Page 1 of 1

Display simulated together with empirical values in a chart

Posted: Tue Feb 27, 2018 8:24 am
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

Re: Display simulated together with empirical values in a chart

Posted: Tue Feb 27, 2018 4:53 pm
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.

Re: Display simulated together with empirical values in a chart

Posted: Tue Feb 27, 2018 6:04 pm
by tomfid
Here's an example.
Test Data (2).zip
(157.25 KiB) Downloaded 439 times

Re: Display simulated together with empirical values in a chart

Posted: Tue Feb 27, 2018 6:07 pm
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 9264 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 9264 times
3. That gets you a data entitytype:
data_entity.png
data_entity.png (37.66 KiB) Viewed 9264 times
Then you can reference the data elsewhere:
reference_chart.png
reference_chart.png (46.55 KiB) Viewed 9264 times
We should permit singular data, but at the moment we don't.

Re: Display simulated together with empirical values in a chart

Posted: Mon Mar 05, 2018 1:29 pm
by moudi
sorry for the trouble... when I want to download the model, I get the message that the attachment does not exist anymore???

Re: Display simulated together with empirical values in a chart

Posted: Mon Mar 05, 2018 7:57 pm
by Administrator
You should be able to download it now.

Re: Display simulated together with empirical values in a chart

Posted: Wed Mar 07, 2018 8:06 am
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.

Re: Display simulated together with empirical values in a chart

Posted: Sat Mar 10, 2018 1:56 am
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.

Re: Display simulated together with empirical values in a chart

Posted: Wed Mar 14, 2018 9:48 am
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 9101 times

Re: Display simulated together with empirical values in a chart

Posted: Wed Mar 14, 2018 3:22 pm
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.