This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Python pandas dataframes and data types (numpy arrays, lists, dictionaries, etc.) are much more robust in general than their counterparts in R, and they play together much easier as well. Moreover, there are only a handful of packages that do everything a data scientist would need, including graphing, such as SciKit Learn, Pandas, Numpy, and Seaborn. After utliizing R, Python, and Alteryx, I'm still a big proponent of integrating with the Python language much like Alteryx has integrated with R. At the very least, I propose to create the ability to create custom code such as a Python tool.
Would it be possible to use the ISO week date system, which everybody uses?
In numerous workflows, I used to define the week number of a date with the formula DateTimeFormat(d, "%W") and it was perfectly working till the 1st January, 2019.
But from this date, the week numbers defined by Alteryx are not the same than the ones in the calendar we all use!
Alteryx says that from the 1st to the 6th January, 2019, the week number is "00" instead of "01"!!! And so on until the week 52 which, for Alteryx, goes from the 30th to 31st or December, 2019: the week 52 has only 2 days!!
As the year 2018 begins with a Monday, there is no problem but for 2019 it is completely weird! And it will repeat in 2020...
The rule from the ISO week date system is pretty simple: "The ISO 8601 definition for week 01 is the week with the Gregorian year's first Thursday in it."
Am I the only one that finds it frustrating that when you are summarising values by dates that all the natural sorting is lost. A good example is using the DateTimeFormat function to strip out the days so that you can get monthly totals but this is then saved as a string so time-related ordering is then lost. Is it possible to add the ability to summarise by time periods (weeks, months, quarters, etc....) and for the natural progression of time / days to be maintained as I am constantly having to reinvent the order.
In addition, it would be useful if we could extend this to provide time-based running totals so for example one tool could be configured to point at transaction data (date & value) and would automatically summise the Jan value and then monthly year to date value by period (selected as weekly, monthly, etc...) up to the max date value in the dataset.
I had an issue with the ARIMA tool using the R function auto.arima() which missed the obvious seasonality in my data set, but when I manually adjusted Model Customization > Customize the parameters used for automatic model creation > The seasonal components > Alter the degree of seasonal differencing and selected 1, the outputs were much better. The problem is that while this fixes my singular ARIMA model, I want to be able to run this through Model Factory too as I have hundreds of data sets on which I'd have to make this adjustment since auto.arima() misses the seasonality on most of them and produces useless results. Apparently I'm not alone in having this issue as I was directed to another comment thread where someone had the same problem and desired fix as me.
TL/DR version -- please make is possible to manually adjust the parameters of the ARIMA Model Factory tool, or at the very least add the option to alter the degree of seasonal differencing.
And for supporting information, here is my thread:
Since we know Alteryx uses R for a lot of its predictive and data analysis tools. It takes a while to run the workflow whenever there is R based tool is involved. I was told by a solution engineer that its because its opening and closing R in the background.
Sometimes my workflow has a bunch of tools which are running R in the background and it takes forever to run the workflow.
I think there should be a user setting which allows user to choose if the want to start R along with Alteryx and keep it running in the background.
Hi there, I am looking for examples of financial modelling within Alteryx i.e. Discounted cashflow forecasting - Has anyone seen anything like this before? I've been through some Udemy Alteryx online training, but just can not figure out how to even use the NPV formula in Alteryx. Thanks!
As it is so important to be able to calculate and present time related concepts in modern businesses, it is not possible to have a better output choice? I have seen the reporting chart tool, I have looked at the TS Plot tool and even noticed that the Laboratory Charting tool has disappeared. So can you please provide an output tool that provides some focused functionality on this lacking part?
I'm stealing this idea from Tableau's number formatting, it's a timesaver.
In the DateTime tool if I've initially selected a value besides Custom in the "Select the format..." list then when I click Custom rather than having the Custom textbox be blank I'd like to have it automatically populated with whatever formatting string I just selected. Here's an example screenshot:
It was great to find the DateTimeTrim function when trying to identify future periods in my data set.
It would be even better if in addition to the "firstofmonth" , "lastofmonth" there could be "firstofyear", "lastofyear" functionality that would find for instance Jan, 1 xxxx plus one second and Jan, 1 xxxx minus one second. (Dec, 31 xxxx 12:58:59) respectively.
I'm not sure if time down to the second would even be needed but down to the day period.
I will be using TS Model Factory tool for running ARIMA quite extensivelty and understand that existing tool does not allow for model customization options. I will really appreciate if we can have customization options which helps to specify order of AR or MA components like it can be done in ARIMA tool.