Alteryx Designer Desktop Ideas

It would be helpful to have a unique feature within Calgary in order to return a unique count or a data extract. The current Crss count will error if there are two many rows.

Dear Alteryx Team

A nice to have :
Possibility to create output directories automatically using a given fieldname in order to organize properly macros outputs

Thanks a lot

Arno

 

I love the new 9.5 Filter tool interface.  Very simple to create filters!

A simple addition could be to add an "And" and "Or" button next to the wizard so we can build more complex filters with multiple conditions

In the Gallery, when reviewing the results of a recently run app, the option to save the results to Dropbox is currently an option.  This is a great, however, the only file format that is allowed to be saved there is .pcxml.

Please add the option to save any of the other report formats to Dropbox (.xlsx, .pdf, .pptx, .html, etc.).

It would be great if you could select multiple Data Fields in a single Crosstab

For example. I would like to SUM (Methodology) Pet Food Sales (Data Field 1) & Baby Food Sales (Data Field 2) By Store (Grouping Field) By Day of Week (Header field).
 

It would be great if there was an option to delete an expected column from a select tool. Sometimes I have to do a lot of work to rename different columns and would love to be able to copy & paste a select tool to partner with a slightly different input file. It would be great to delete an expected column, so I would not be forced to unselect the column to prevent error (I'd rather have the column treated as an *unknown) and I could use the remaining columns which are still applicable.

It would be good if in the date format option for the Parse tools etc, if there was an option for the 1900 date format used sometimes in Excel/SQL. This is where the date is represented as the number of days from 1/1/1900. If this support was added then the same support for time be represented as a decimal {0,1} would be good as well. Besides this being a nice addition to the software, it would also help with any workarounds stemming from an excel file being open when imported causing the format to come through differently. (Currently if the Excel input file is open in the background which can happen on network available files, the time comes in to Alteryx asa decimal and the date appears as 1900 format).

It would be great if we could output the coefficients of regression equation to a table so that one can use them in rest of the module. Currently, Alteryx can output the table/coefficients in charts/reports form which is not re-usable as such in the module. 
The values of coefficients/Residuals/Errors would be very useful in building macros for techniques like Missing Value Analysis which can't be done in Alteryx as of now.

I would like to be able to use the join tool to join on inequalities.  We could join two tables, A and B on A.value is >= B.value1 AND A.value <= B.value2.  This would replicate the "between" function in SQL.  The equvalent feature in Tableau is pictured below.

I'm working on loading some public data available as an .xls doc on the web. I can use the download tool to fetch the file, but then have to save it, and reopen it in a separate input data tool. It would be so much easier if I could just flow the download result into an excel parser tool, but I don't see that as an option unless the download file is XML or CSV.

Currently if I receive a file where fields are empty rather than Null(), the summarize won't count them with the CountNull option. Fairly easy to put a formula right before when there is just a couple of fields and change with an IF IsEmpty() but with a file with a large number of fields and large file size, a multiple field tool eats up a lot of time converting.  Not sure if it would just be trading processing speed in the summarize to do basically the same thing.

With a module that contains a lot of tool containers, it would be nice to have an option (similar to Disable All Tool That Write Output in the RunTime TAB) to disable all Tool Containers and then I can go pick the one or two that I would like to enable.

Can you add the Data Output along with the Report Output on the Association Analysis tool.  

We needed to manually change this on our end but it would be nice if in 9.5 this easy upgrade was done already...

Rather than giving the users a big list of different date formats to choose from, allow the user to construct their own format with syntax of the incoming date that they are dealing with.

Currently I need to do a string function moving dates around to match a predefined syntax...

Can you add some additional options to the running sum tool?  I know this can be done in the Multi-Row formula, but it just takes too long to program and Alteryx is designed for speed and I know it can be done.  Can you add options to average, standard deviation, etc. also with running sum?  And then add a rolling time window on it.  That would be great!

Thanks.

Hi ,
Today i stuck in one position where my current module gaves an error because it doesnt found the Fields name. I define the field name in Formula tool for validation and harmonization. So as my Fields changes formula is also changes. But i donot want to make any changes in my Module.

So what i am thinking it will be better that we can define a formula in any file format like (.xlsx or .csv) and take the Input in formula tool.
So we do not have to change the module again and again. We just need to change the mapping file against the lates file coming. So we can check the file and define the formula in mapping file.

Thanks in Advance.

Hello, 

I am not sure if this capability exists but I assume it does not.

We have a need to optimize a Linear Program (LP) model that consists of a system of equations and has both:
An objective function and a series of constraints. One of the software capabilities that SAS offers that currently
Alteryx does not have is this optimization capability. 

I am wondering if the capability is currently not available, is this capability in the Product Roadmap?

Thanks,

Ricardo

Hi,

Instead of having multiple filters to create mutliples new branches for downstream analysis, Alteryx should have one filter with multiples ouputs ports. Each filter would is own statement. 

This would reduce the numbers of filters in a canvas.

I have been using the outputs from Spline Regression to facillitate analysis of demographic data (specifically Department of Labor Quarterly Employment data).  I have data from 1992Q1 to 2014Q1 and use Spline Regression to get fitted values for each quarter with predictors being the year/quarter, Year/quarter multiplied by a dummy variable for each of the 4 US Presidents, and a dummy variable for each president. 
So I can compare results across various groupings by geographic, and other levels as well as the BLS aggregation level. I can analyze raw data or have the values to be fitted indexed to 1992Q1.
I use the default settings for Spline and it builds the best fit including where the node periods for each spline section.  To help interpret the results, though, I use the output to compare the actual vs. fitted values (e.g. employment Level) and then look at the changes by quarter. 
With the spline regression building the best model with optimal line segments, the results make it possible to see how employment progress or regress correletat with with presidential terms of office or specific impacts of economic recessions on employment data.

I can supply an example of the process, if anyone is interested.

I'd appreciate any comments and/or suggestions to improve the process or interpret the results.