Reply
Frequent Visitor
Posts: 5
Registered: ‎12-19-2018

Issue uploading dates into R

Hi,

 

I am trying to upload two columns ("timestamp" and "value" from my query into R so I can create some process control charts using some features in R.

 

However, when I click to import the timestamp into R it imports it as a dataframe(value, Year, Quarter, Month, Day) which prevents me from being able to create even a simple graph of a continuous date on the x-axis and value on the y axis.

 

Can someone please show me how to fix this?

Highlighted
Community Support Team
Posts: 1,352
Registered: ‎07-30-2018

Re: Issue uploading dates into R

HI, @kster45

It may due to Hierarchy feature for Date field like this:

 

8

Then you can disable it by right-click date field

9

Then use R code

Result:

 

10

 

Best Regards,

Lin

 

 

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.