Alteryx Designer Desktop Ideas

Hello,

It would be great if there was an option to compute 'median' on numerical data column in 'cross-tab' tool. We trust 'median' a lot more than 'average' in many different computations.
I would stretch my suggestion far enough to propose adding quantile computations as well...

Thanks!

It would be handy to have an increment function similar to SQL's Identity datatype that allows you to specify a seed and increment value.  It would seem like a really simple tool to add.  Ideally the seed value could come from an incoming connection to give the flexibility of retrieving the seed value from a database.

I've found a workaround explained on my blog here, but it would just be handy to have this built in.
 

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).
 

You can select all fields at once, but it'd be nice to select a chunk of fields using CTL+Shift+Click

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 an app that contains 4 check boxes.  Each check box is independent, and when checked, two other prompts open up to the user (in this case, text boxes which are also independent of the other check boxes).

I would like to be able to "Check All", so that with one click, ALL four check boxes are checked, and their prompts all open up.

I think that it would be useful to add two new Rename Modes to the Dynamic Rename tool -- here are the existing ones:


I would add:
Take Field Metadata from Right Input Metadata
Take Field Metadata from Right Input Rows

These would allow mass changes in data type, size and scale based on either an existing data table's metadata or an external metadata table.

In the ‘Report – Table’ tool I would like to be able to force headings to multiple lines. For example If I have a heading such as “Catchment (%)” or “Spend (£)”, I would like there to be an easy way to make the (%) / (£) move to the second line when I have fixed width columns.
 

 

If we rename a field ‘X’ to ‘Y’  in the alteryx module, the renaming is not inherited by all the tools using that field in that module. The tools which are still using the old field name ‘X’ will fail until they are configured to use the new field name ‘Y’. Most of the tools I have worked will inherit the field renaming.
 
It would be very helpful if the renaming is propagated to all the tools in the module using that field name. 

In other data programs like access or Toad you can put conditions on a join. You can choose if something is greater than, less than, left join, right join, etc.
But with Alteryx you are only allowed to join a perfect match. It would be really great if you could add that functionality into 9.0

A client has requested that we provide the ability to have the two digit year begin a date string.  Currently, we have the following:

yyyy-MM-dd
yyyy-MM-dd hh:mm:ss
yyyy*MM*dd
yyyyMMdd

In addition, they have requested that we have the ability to convert from a date field to another date field.  Currently, we can only convert to/from a string to date and vice versa, but not date to date (which would be helpful in a date format).

I would like to work with percentages in a format similar to Excel, where the number remains a double for input, exports, and formula calculations, yet has an option to show the number as a percentage on reports and rendered outputs. 

For an email event, there are several defaults that are shown in the body (e.g., %User%, %ComputerName%, %WorkingDir%).

It would be nice to add a date in there, maybe %Date% or %DateTime% or something like that which would display the computer system time.

We use the test tool extensively in our App and Macro authoring. It would be very useful to have the ability to label the tested values so that when the Test tool writes to the output window it’s more descriptive.
Example:
Currently this is the report
Error: Market (1): Tool #235: The test "The count of Columns does not match the count of Labels." failed: TargetNumRecords(#2)==102, NumRecords(#1)==106
 
 
A more useful report would be
Error: Market (1): Tool #235: The test "The count of Columns does not match the count of Labels." failed: Columns (#2)==102, Labels (#1)==106

Whenever Alteryx recognizes a field as a Date, it should default to Date, not Date/Time. I don't think I'm in the minority, but I rarely need to see the date AND the time. 99.9% of all of my date fields do not have a time associate with them; such as: Open Date, Close Date, Remodel Date, Lease Expiration Date, Lease Start Date, Date Record Updated, Relocation Date, etc., etc., etc. So I always get results like 4/1/2013 12:00:00, which makes it difficult to query against without changing to just Date. I would venture to guess that most people don't use the time either, but I may be wrong. So, defaulting to just Date would save a lot of us that extra step for each date column.