Issue uploading dates into R

[Anonymous]

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?

[v-lili6-msft]

HI, @Anonymous

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

Then you can disable it by right-click date field

Then use R code

Result:

Best Regards,

Lin