community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!

1 Review

Our submission guidelines & status definitions before getting started

2 Search

The community for a solution or existing idea before posting

3 Vote

By clicking the star in the top left corner of an idea you support

4 Submit

A new idea to suggest a product enhancement or new feature


Suggest an idea

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. 

I have reviewed a number of batch macros that work well for mirroring the "NetworkingDays" excel calculation but it would be great to add an interval type for "weekdays" to the DateTimeDiff formula ie

 

 DateTimeDiff ( [Date01],[Date02], "WorkDays")  where any Saturday or Sunday between the dates would be discounted.

 

 

US and Canada datasets are underlined so far but,

 

Alteryx is expanding towards, Denmark, Germany, France and several other countries...

The question is; Why don't we have Eurostat data provided as well?

 

 

Picture4.png

 

Bulk options for some datasets are available.

Even one can get a grasp on micro datasets and Alteryx may have a deal inf this micro dataset is anonymized...

 

Picture5.png

 

 

Picture6.png

 

 

 

 

Hi,

 

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.

 

Just a thought,

Peter

  • Category Time Series

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:

 

https://community.alteryx.com/t5/Advanced-Analytics/ARIMA-model-missing-seasonality/m-p/87776#M3000

 

And here is the other thread where a different person had the same issue:

 

https://community.alteryx.com/t5/Advanced-Analytics/TS-Forecasting/td-p/28857

Hello all,

 

It would be awesome if Alteryx was able to accept Lat/Long and be able to tell you what timezone that location was in and be able to do time analysis from there.

 

Thoughts?

 

Thanks,

Nick

I find that the Scheduler is very limited in being able to customize when jobs are run. As far as I can tell there is no way to make a workflow run from 7am-5pm, every 2 or 15 minutes, only on weekdays. Using Cron expressions is a great option since it is a standardized format already used in the Analyst world.

 

My two examples would be written like:

0 0/2 7-17 ? * MON,TUE,WED,THU,FRI *

0 0/15 7-17 ? * MON,TUE,WED,THU,FRI *

 

http://www.cronmaker.com/

 

This would prevent running workflows all through the night and on days where it is completely unnecessary.

 

Thanks!

0 Stars

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.

 

Thanks,

0 Stars

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!

0 Stars

Hi,

 

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?

 

Kind regards,

Peter 

0 Stars

When enriching your date data, week information is pretty critical, I suggest adding %w to the format stings as well..

 

Picture2.png

 

Several month based expressions can also be made weekly, data time first of week #31, last of week #45 etc....

 

Picture3.png

 

 

 

 

Also came across a lot of questions at our community on how to turn week based data...

 

Writing the formula is obvious (Ceil(DateTimeDiff([Today],[Date],'days')/7))

but having a DateTimeDiff([Today],[Date],'weeks') is preferable don't you think?

 

Cheers

0 Stars

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:

 

 

 

0 Stars

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.

 

 

DatetimeTrim.JPG

0 Stars

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.

 

Thanks!

Top Starred Authors