TS Plot tool error "could not convert index to appropriate type"
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I'm new to Alteryx predictive tool and have followed the booking tutorial online for monthly time series plots. It seems a simple process so I am trying to use the TS Plot tool to plot the data points that I have for USD/GBP exchange rates on a daily basis.
I have the following fields:
- Date (Date) ##there is a record per day in the format (2015-01-01)
- Quote (Double) ##this is the value quoted on each day
The properties I have in the TS Plot tool are as follows:
Target field: Quote
Frequency: Daily (all days)
Plot type: Time series Plot
(all other options I've kept defaults)
I have tried various options but cannot ge the tool to run without error. No matter what I choose I am confronted by the error:
"Error: TS Plot (2): TS Plot: Error in as.xts.ts(data) : could not convert index to appropriate type"
I have also tried splitting the date field into Year, Month, Day and setting the starting period in the tool properties etc. but get the same error.
Does any one have any ideas as to how to resolve this so I can plot the time series? I feel like I'm missing a step or something so would appreciate any help/advice.
Thank you,
Solved! Go to Solution.
- Labels:
- Predictive Analysis
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I think that there is a fix for that in an updated R tools download.
http://downloads.alteryx.com/predictive.html
Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Great, that makes sense as I've recently updated to Alteryx Designer 10.0. I should have realised there would also be an update to the predictive tools. Thanks, I will download the updated tools and report back.
Thank you for your response
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Just to confirm the updated predictive tools resolved the error. Thanks again
