Alteryx Designer Desktop Ideas

We just updated to 11.7 from 10.5.

 

The Container adding/removing rules were changed somewhere in there and the change made it much harder to remove tools from containers. Is there any way to undo these changes or look into a better set of rules to use?

 

Nick

Hi,

 

I understand that we can find tools that uses formula by ctrl+F. 

I wish we can find text and replace the formula like excel does.

Sincerely,

knozawa

 

It would be a timesaver for workflow documentation if macro metadata could be passed through to the workflow where the macro is deployed.  The image below suggests that the Description encased in the macro could be copied across to the corresponding Annotation panel.  I would also suggest that the Meta Info panel have a checkbox to control this new funtionality.

 

It would be great if there was a way to convert datatypes within the Table Reporting tool.  The specific example that sparked this idea is calculating percentages so they are shown in the report with the decimal place moved over.  Today, within the formula tool I need to calculate the percentage and then multiply it by 100 in order for it to display the way I'd like in the report.  However, if I need to leverage this percentage for another formula I most likely will have to divide the percentage I calculated first by 100 before I continue my calculation.

 

It would be nice to not have to multiply by 100 to move the decimal place over 2 spots and instead use the table tool to convert the number into a percentage we're all used to seeing.  I'm thinking something similar to excel where you can click percentage, currency, etc to convert your number.

Instead of being a module setting, showing counts should/could be a user setting.

The "Open Example" feature that has been implemented for many tools helps new users quickly learn how to exploit Alteryx.  I would like to see Alteryx make further investments in this area and in particular I would like to see enhanced and organized documentation for functions with more and better examples.  I would encourage Alteryx to engage its ACE community and the other advanced users who are active in the Community to contribute to this effort. 

Often when we need to use the Filter tool and select the Custom filter option, it requires us to write conditions such as "IF", "OR" and so on.

 

Was hoping if some suggestions or hints could be embedded in the custom filter for those of us who have no experience even in basic coding.

 

 

It would helpful if you have a tool which will help us to filter out the data using CASS results column in a meaningful way. On the other day, I CASS'ed 2MM customers and ended up with 1500 combination of CASS result codes. I don't think we would have time to sit walk through all the 1500 combination to find out which I should call it as correct addresses and not the right ones. If you have one already that I didn't know of, please guide me.

Thanks
Arun

When you have a complex workflow and you need to identify what happens to a specific field throughout a LONG workflow, it would be great to have the paths, connections, etc highlighted.  

 

If the field is modified in a tool (formula for instance), the tool gets highlighted in orange.  If it just passes through a tool, it is highlighted in green and a tool where it gets dropped is colored red.

 

This will help in identifying which tools modify a field of interest as well as identify tools which "deselect" a field and cause it drop out.   I spend a lot of time tweaking workflows developed by other analysts, so this will greatly speed up troubleshooting and assessment time. 

 

 

 

 

This can be a simple add on to the sample tool or possibly a separate tool. This would give you the ability to select which row the Header row(and use field values for header) and/or data starts. This is particularly useful if someone has extra rows with report titles and information, etc. This tool could also select rows to skip, ie blank rows in matrices or rows that do not contain data. 

I'm a long time user of Photoshop and it would be great to get some similar zooming and panning functionality into Alteryx.  Such as:

- hold down the "space bar" see a hand and pan across the canvas.
- hold down "CTRL" or "ALT and zoom on the canvas
- use the mouse scroll to zoom on the canvas

This is a low priority one, but I constantly find myself wanting to do this and it seems to be both an easy fix and something which should exist anyway.

I have ten input tools, I want to be able to highlight all, right click and select "add all browses" or something similar. 

That's it. Nothing earth-shattering, nothing deeply insightful, just something that would brighten up my day and maybe save a bit of time.

 

Thanks.

Greenplum is a new in-db capability; which our company has started using frequently. GP is a distributed database, across many nodes, much like how Redshift and other new database technology works.

 

In order to properly use these databases the Alteryx tools MUST have a way to distribute our tables across the nodes how we desire. Currently the tools for In-DB will distribute by the database default (almost always taking the first column in the table to distribute) which has terrible affects on performance. The work around has been to run SQL outside of the Alteryx tools to run ALTER TABLE DISTRIBUTE BY statements for all tables; also this cannot work on TEMP tables as those tables are created and deleted at the end of the workflow.

 

The idea I want is an additional option for Distributed DB's to choose the distribution column OR choose the "RANDOMLY" option for distribution of tables [DISTRIBUTED BY statement]. This would make my DBAs very happy and make it possible for me to run even more challenging requests to my system.

 

As far as I know, in the current version (Jan 2018) of Designer the presentation settings for the canvas are global and are set by the user in the Canvas settings tab of the User settings.  There appears to be no way to adjust canvas settings at the individual workflow level that would over-ride the global defaults.  (Please tell me if I am wrong).

 

I propose that the user defined global defaults be retained but that the workflow configuration window include a new tab where local settings can be set.  This tab should include a button that enables a user to reset all local settings to the global defaults. 

 

 

Here are a few things that I feel would be useful enhancements for the stacked column chart:

1. In series styles, replace current "Label Data Points" Yes/No dropdown options with "No/Top/Bottom/Left Side/Right Side/Alternating Sides" options to allow label text to fall above the line marking the top of the set (current implementation), below the top line, to the left or right or alternating between left and right.  Side labels reduce the need for #3 below and alternating side labels partially mitigate the need for #2.

2. If "Label Data Points" is turned on, allow an option to set a minimum threshold to display the labels.  In the current implementation the data point labels are placed on top of each other in cases where series with comparatively high volume are mixed with series with very low volume unless there is only one low volume series and it happens to be the last series in the set.  With alternating side labels from #1 above this would only be an issue if more than one consecutive low volume series was displayed.

3. Lighten default series colors or change default text color to white.  Black label text does not stand out or is unreadable against most of the default colors (dark blue, dark brown, etc.).

Sometimes the field names for an imported file are very unhelpful.  Consider the image below as an example.  Even though the AUTO FIELD tool has been applied to this imported CSV file it is still necessary to inpect the source data before assigning field names and descriptions. 

 

MY SUGGESTION:  insert a data preview column in the Configuration view between SIZE and RENAME.  This data preview column would show the first row of data but a scroll function would allow the user to advance to the next or previous record within this view.  This feature would enhance the productivity of analysts in the data preparation phase of their work.

 

 

 

 

 

 

 

 

 

Currently Atleryx just takes a flat file and create a Tableau Extract (.tde) file.  I would like to be able to to take two files and cube them together like Tableau allows me to use when I create my own Tableau Extract using Tableau.  Right now I have to export two different files into excel files and then use Tableau to cube them and create an extract that gives me more power and functionality than the extract that Alteryx provides.

Hi,

 

I am working on a macro that has multiple listboxes and xml tree controls in it and the listbox controls have a feature in the top right to select all or none, effectively allowing you to clear any entries you had made and start fresh.  In the tree control, there is no such feature but it would be nice to have instead of having to remember and go through and find all the entries you had made to start fresh.

To the point of the macro interface, when developing and testing using the interface designer, you are able to 'reset' the interface using a button at the top of the left pane.  It would be nice if that was available in the macro interface at run time. And that would solve the issue with the tree control in one step.

 

Thanks,

Dan

Dear Alteryx Team !

 

When running an app the actual Analytic App Progress window is not very informative and can not help to know where do we stand in the process.

 

In order to improve that issue, it would be very nice to give the hand to developers to let them choosing which message should be display in the progress window.

 

Minimal need :

• At each macro step : A view of which macro is actually running with their corresponding iteration counter

 

Optimal need :

• Allowing to completely design and name the messages to display at each macro steps and iterations (free text + iteration counter + time estimation ...)

Many thanks

 

Arno