Specifying dates in range or masks

[philippe peetersParticipant]

Hi all,

I have a dataset where the x value is given as a date (yyyy/mm/dd). I would like to perform a fitting within  a given limited  time window. How can I express the “Fit X range” as a date range ?
I’ve tried something like 2020:1:1,2020:3:31 to express a range between January 1st and March 31 of the year 2020 but it doesn’t work.
Is it possible or do I have first to compute an additional column with, let’s say, the day of the year and select on that column ?

Thank you

[dgteamModerator]

Hi Philippe – The format for the date range you looks correct.  Here is a simple example where Fit X range is set to 2000:1:1,2000:2:1.  As a result, the linear fit only uses the three highlighted points in that range.

So maybe something else is not right.  Is your data set to the correct date format?  Another possibility is if you are using a LOESS fit you may have to increase the smoothing window in order for the fit to work.

 

[philippe peetersParticipant]

It works. After many trials and errors with the syntax, I unfortunately left a semi-column in one of my attempt and furthermore my fitting function choice was not optimal.
I didn’t find this syntax explained in the manual.

Thanks

 

[dgteamModerator]

Glad it is working now.  Thanks for pointing out this was not in the manual.  We will add this explanation of using the data format.

[Author]

Posts