Hi Allan,

Was the study made as a time-based study or a visit-based study?

Regards,

Jon

Hi Jon

It is timebased.

I believe I have followed the instructions here
https://www.labkey.org/home/Documentation/wiki-page.view?name=studySetupManual

I did however had some problems with importing the datasets, bur after converting the excelfiles to a newer version it seemed alright. Idont think it influence anything but it involves time so who knows :-)

Best wishes
Allan

Allan,
It looks like when study datasets are created manually from importing a file, the measure and dimension properties are not automatically set for dataset columns. The Time Chart wizard uses these column properties to determine which columns can be used as plot-able measures and which columns can be used as data dimensions in the plot. You can manually set these properties by going to the Manage tab in you study, click the "manage datasets" link, selecting the dataset (i.e. Lab Results), clicking the "edit definitions" button, click the column row in the Dataset Fields section (i.e. CD4+), click the Reporting tab, and checking the "Measure" checkbox. Attached is a screenshot of where to find the property.

Give that a try for a few of the numeric columns in your Lab Results dataset and then try creating a time chart using, for example, the CD4+ column.
-Cory

Hi Cory

You are right that the measure attribute wasn't set but that gives another kind of error and I already corrected that.

Somehow it seems the time-interval isn't calculated and hence no timechart. If I click view data on the timechart I can see that the day/visit/visitdate is empty. In the lab results dataset there is a day column which is filled

I have atteched some screenshot of different views: the timepoint setup, lab result properties, lab result content (top rows) and the data view from the time chart wizard.

Best wishes
Allan

Allan,
Thank you for the screenshots, those are helpful to verify your study configuration against my local study. Can you check one additional thing for me? Can you go to the Admin Menu for that study folder and select Admin > Go To Module > Query > select the "study" schema > select "ParticipantVisit" table > click "view data"? I'm curious if the "Visit Date" column of that table is being populated as expected for your study.
Thanks,
Cory

Hi Cory

Of course a picture is attached.

Best wishes
Allan

Thanks. That looks to be populated as expected. Can you export your study and attach the zip archive? Then I can try to triage the issue locally because everything seems to be configured as expected. To export the study, you can go to the Manage tab for that folder and click the "Export Study" button at the bottom. The default options for the Folder Management Export page should be fine.
Thanks,
Cory

Hi Cory

Thanks for all your effort, it is appreciated.

I have attached the study.

Best wishes
Allan

Thanks, Allan. I loaded your folder archive locally to my release15.3 LabKey server, and I can't seem to reproduce the behavior you are seeing. Attached is the Time Chart plot that I get when I create a new time chart and choose the Lab Results > CD4+ measure to plot (without changing any of the other default settings for the time chart).

We do set some study properties slightly differently when a study is loaded from a folder/study archive vs when it is created manually, like you did for the tutorial you followed. Could you try one more thing? Create a new folder and try importing the archive that you sent me into that new folder (via the Admin > Folder > Management > import tab). Then try recreating the Lab Results CD4 time chart and let me know how that goes.

Thanks,
Cory

Hi Cory

I tried to import the one I sent to you, but with the same result, no plot.

I did however solved the issue, by adding the following To the Tomcat server's JVM start options.
-Duser.language=en
-Duser.region=en

This also solved another error I got previously when importing excelfiles:( https://www.labkey.org/announcements/home/Server/Forum/thread.view?entityId=6056464c-3922-1033-a313-22a830bc2d76)

It seems that there is a basic problem with at least danish locale/language settings in how labkey handles dates.

Thanks for all your assistance it has been very helpfull.

Best wishes
Allan