Alteryx Designer Desktop Ideas

Currently there is no option to edit an existing macro search path from Options-> User Settings -> Macros. Only options are Add / Delete. Ideally we need the Edit option as well.

 

Existing Category needs to be deleted and created again with the correct path, if search path is changed from one location to another.

 

 

 

The sum function is probably the one I use most in the summarize tool. It is a silly thing, but it would be nice for "Sum" to be in the single-click list, rather than in the "Numeric" category...

 

Move sum function

This setting is currently in the Options menu under user settings, but I think it would be more intuitive and more consistent with the norm for most software if the check box were directly on the splash screen.

Idea:

In forecasting and in commercial/sme risk scoring there is a need for trying vast number of algebraic equations which is a very cumbersome prosess. Let's add symbolic regression as a new competitive capability.

 

Rationale:

Summations, ratios, power transforms and all combinations of a like are needed to be tested as new variables for a forecasting or prediction model. Doing this by hand manually is a though and long business... And there is always a possibility for one to skip a valuable combination.

 

 

Symbolic regression is a novel techinique for automatically generating algebraic equations with use of genetic programming, 
In every evolution a variable is selected checked if the equation is discriminatitive of the target variable at hand. In every next step frequently observed variables will be selected more likely.

 

SR comparison with linear regression neural nets and random forests

 

Benefit for clients:

This method produces variables mainly with nonlinear relationships. It is a technique that will help in corporate/commercial/sme risk modelling, such that powerful risk models are generated from a hort list of B/S and P/L based algebraic equations.
There is potential use cases in algorithmic trading as well...

 

There are 3 very interesting world problems solved with symbolic regression here.

A very relevant thesis by sean Wouter is attached as a pdf document for your reading pleasure...

 

R side of things:

I've found Rgp package for genetic programming, here is a link.

 

Competition:

I haven't seen something similar in SAS, SPSS but there is this; http://www.nutonian.com/products/eureqa/

Also there is Bruce Ratner's page

 

I would love to see the option to publish the description information from an alteryx workflow into Tableau tde files as the default comment field

As with Output Data tool, it would be very helpful to have this option within the Calgary Loader tool.  I have a series of ordered analytic apps and if I could name the Calgary database using the "Take File/Table Name from Field" option I would be able to chain the apps and be much more efficient.

 

Thanks.

When we copy and paste a tool into a workflow, we then have to drag the pasted tool into the workfow where we want it. It would be better if we could right click on a connector, select "paste", and have the tool paste into the flow where we put the cursor. Or to be able to right-click on a tool and select "paste after" similar to how we can "insert after".

This idea has been superceded by "Paste Before / After"

Hello,

 

Many mouses (mice?) allow you to tilt the mouse wheel either left or right. It would be great if this would scroll the canvas left or right, similar to rolling the wheel to scroll the canvas up or down. This would be especially useful considering that users have been nudged to create their workflows horizontally.

 

Thanks!

Hi all,

Just to give you some context, we have a customer that requires that for every Tableau workbook we deliver, we must add extra documentation, as for instance, for every calculated field, in which views it's used, and the formula of that field (yes, I know exactly what you're thinking right now :P)

So I decided to take a shortcut and do a workflow that extracts the basic (I mean VERY basic) data from the .twb file, so I can save a lot of time. 

 

Then I came with this idea...

 

Having a lot of Tableau's under the hood experts in this Community, It would be great to gather some of them and create a Tableau Documenter Macro.

 

I'd love tho hear what you think, and who's being able to help.

 

Idea:

Some well known scoring methods use optimal binned variables for added robustness. Let's add this capability to Alteryx.

 

Retionale:

Here's a basic link on why to do that; http://documents.software.dell.com/statistics/textbook/optimal-binning

 

Current status in Alterys as I'm aware of:

Tile tool or Multi-field Binning tool for completing same task as Tile tool on multiple fields, splits the variables by 5 methods;

• Equal Records or Intervals or Sums

• Smart Tile

• Unique Value 

• Manual

Unfortunately "equal something" binnings are bad idea, as the values are categorized "blindly" irrespective of the effects on the predictive power of the models. 

 

What to do:

What's needed is to bin both numerical and categorical variables optimally such that the Weights of Evidences (WoE) should present a monotone increasing or decreasing pattern. Maybe at most a V or U shaped "convex" structure.

 

Quick win:

Without constraining ourselves with monotonicity or convex cases, the easiest practice would be running a C4.5 or CHAID tree algorithm (produces multiple splits rather than binary splits in CART) for a single variable and select the target as the dependent variable and all the resulting nodes will be the bins we are looking for. Doing this for multiple variables at once is the key to the tool to be generated.

 

Clients:

This capability is sought by risk management departments building robust, stable Basel compliant models in financial industry, especially by banks.

When working with complex modules, it would be great to allow an option to add a tool upstream and automatically rewire to downstreams tools.

Simplified example:

Text Input flows to (1) Filter and (2) Formulae Tool. If I want to drag and drop a Formulae Icon after the text input to be applied to both paths, I can't. I have to either choose To apply to Path (1) or to Path (2).

 

I know that you can right click, press insert after, and search for the tool, but this is not a time efficient manner.  You can also delete the wiring and rewire yourself, but if you have mutliple downstream tools, this is a pain.

 

We are starting to use Alteryx as a full ETL DW build tool (and blogging about it too..)

 

Compared to other tools in the market there do not seem to be the usual SCD(slowly changing dimension) and other "standard" tools or templates to start building.

 

It would be great to have a template/Macros/guide to starting to build a DW solution. It is rather daunting starting with a blank page!

 

 

When bringing data together it is often needed to assign a source to the data.  Generally this happens when you union data and need to know things later about the data for context.  It would save time to generate a source field that is assigned based upon the input connections of the union tool.  Perhaps when unioning data you can assign a name to each input stream?

 

 

When a tool's input connector is already attached to a data stream that only accepts a single connection, attempting to attach a 2nd data stream with the same fields should automatically insert a Union tool.  This would be similar to the way an Action tool is automatically added when you connect an Interface tool to another tool.

 

Sometimes I get conversion error messages or warnings that really don't matter, and it would be great if there was a function similar to spell check or grammer check where I could say "Don't show me this again", so that once I've read the message I can choose whether or that particular message pops up again.

The capability to input/output R Datasets via the input/output tools, together with all the other data formats as well (like csv, Excel, SAS, SPSS, etc).

I would like to see the same functionalitly that the Output Tool has in the Render tool.  In the Output Tool, you can specify the Excel Worksheet along with the Sheet Name that you want to output too.  Meaning Same Worksheet, different tab:

     C:Output FilesExample_Worksheet.xlsx|Report_1
     C:Output FilesExample_Worksheet.xlsx|Report_2

This functionality is not currently available in the Render Tool and would be very useful and cut out some manual operations on the back end that requires us to copy/paste from one file to another.

I tried using the Section Break technique that was offered as a suggestion, but it did not perform what I needed.

Within the mapping tool, please add an alignment option (left/center/right) within the label options (when wrapping).