Display simulated together with empirical values in a chart

[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 829 times

[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]

Here's an example.

Test Data (2).zip

(157.25 KiB) Downloaded 1012 times

[tomfid]

You need 3 parts:

1. The data has to be formatted with a key attribute(s) and DateTime column:

data_format.png (20.02 KiB) Viewed 15342 times

2. Then you can generate a mapping, first detecting the types, then generating a data entity:

mapping.png (41.13 KiB) Viewed 15342 times

3. That gets you a data entitytype:

data_entity.png (37.66 KiB) Viewed 15342 times

Then you can reference the data elsewhere:

reference_chart.png (46.55 KiB) Viewed 15342 times

We should permit singular data, but at the moment we don't.

[moudi]

sorry for the trouble... when I want to download the model, I get the message that the attachment does not exist anymore???

[Administrator]

You should be able to download it now.

[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]

I don't think so - you can change the title, but the varnames are automatic. You could rename the variable itself, of course.

[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 (316.25 KiB) Viewed 15179 times

[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.