Alteryx Designer Desktop Ideas

It would be great to just have a little tool like a comment box that could be based on whatever you want... like if you always want to see the max date at a certain point, or the grand total. It would be similar to how you can put formulas in the titles in Tableau like "Current as of <MAX(Date)>" or something like that. The best way (I think) would be to have it like the Annotations, but make it so you can turn it on or off at any stage in the workflow (right now annotations are only show or hide all) and make it dynamic based on results from the workflow up to that point. Right now I'm accomplishing this just by using a summary and browse tool, and then I put the result in the title of the toolbox manually.

Sometimes when you make changes to a filter tool or some other tool's configuration and immediately click on another tool on your workflow, the chanegs you made to your first tool won't register.  The only way to get them to register is if you click the canvas afterwards.

When scoring data if you have values in predictor fields not seen in the data that was used to build the model the score tool will not score the record.  Makes sense but it would be nice to know how impactful the issue is.  Please provide a count of records not scored for these reasons as well as a count of records not scored because of exceeding the limit in the configuration tab of the score tool. and a count for any other reason a record is not scored so we have a clear understanding of how many were scored and how many were not and why.


 

While trying to debug data parsing, I end up with browse tools all over the place and it makes the pallet a mess and time consuming to organize.

It would be much nicer to just have a little corner of all icons to have a sub icon or something I can click on to see output.  Multi output could be a little more tricky ... so better yet, maybe have small browse icons on the connectors you can click on for results of that feed?

Then have a menu option to turn all off/on.

I have the Show Properties Window selected, but it is not showing up on my screen. At first I thought it was just hidden and that I could just pull it back from being hidden, but I can't find it anywhere. 

Thanks! 

Like the ability to create data tables for reporting purposes, makes life a lot easier.  I would like to suggest the ability to be able to define the height of each row in the table.  There is a lot of wasted space between the rows and becomes challenging when you are trying to work with getting everything on one page or keeping the table contained within a box on the report.

I would love to have alteryx dump the excess amount of records on a new sheet in the same excel file that the user creates for dumping the output.

Problem: When you configure fields manually in the union control and then go back to remove a field it throws up an error that "XYZ field missing"
Solution: One needs to change the config to "arrange fields by name" then refresh before you can arrange fields manually

I would like this problem to be handled by some method that tracks for changes and warns the user rather than throw an error.

Correct me if I am wrong, when I use the trade area tool, the only non-spatial data appended to my input dataset is the RadiusSize field. Can this be expanded to include the Units selected (km, miles or minutes) and the dataset used for drive time, plus AreaSqMi, etc? Values like 10 in my RadiusSize field are useful but I would like to have all Trade Area details.

Actually, could you incorporate trade area tool into the spatial match tool since these tools are usually used one after the other?

Bedankt!

The tabs for the Workflow-Configuration sheet has the Canvas tab as the first one and defaults back to the Canvas tab after running.  I want to be able to have the Workflow tab be the first tab and return to the Workflow tab after running.  This can either be the default, or user-selectable ordering of the tabs.

Thanks.

I have a strong feeling Alteryx doesn't handle ascii control character End of medium (EM) when writing to an excel sheet. Created an unreadable excel file. However if you write the same data to csv and then open it in excel everything is fine. My idea is to have the bug fixed or to be informed what I did wrong.

I would like to use the precreate statement as part of a app. That means if a user selects ID '12345' from an interface tool, I would like to delete recs in SQL server with that same ID through the pre create statement, then afterwards I would append new records with the same ID.
What I really miss is having the ability to send one Name & Value to an interface tool like label or readonly textbox.Then I could use Label/Textbox->Action->Output and change the precreate statement that way. 
I tried the formula way but SQL think I am running a stored procedure.
It looks like I need to use a listbox or dropdown tool and do it that way but that means I am cluttering my app with unnecessary tools. 
Could you give interface tools a 'hide' property or allow a field to be passed to the pre-Create SQL statement?
Unless there's another way to do all this? 

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.

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 think it would be extremely useful to have a switch connector available in Alteryx. What I mean by a switch connector is a connecting line with an on/off state that will block the data stream through it when off. Something like below:


Switch Connector in an "Off" state

This would be extremely useful when you only want data to flow down some of the paths. In the example above, I might turn the switch connector to off because I want to see the Summarize results without outputting to a document.

The current methods for having a path/set of tools present but unused are insufficient for my needs. The two methods I and Alteryx support were able to find were:

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.  

I'd love the ability to Input an already-formatted Print Layout area within an Excel document, or a .PDF document in an effort to standardize reports needed on a regular basis.

Our department doesn't create everything that rolls into these reports, but we'd love the ability to incorporate external documents and save our company hours.

Is it possible to format an input tool to only look at the Print Area? If not, that capability would be wonderful.

Thanks!

I'd like to see some added configuration in the Chart tool to allow more space for the chart legend so that the names of elements don't have to be truncated.  The only way to eliminate truncation right now is to decrease the font size and/or increase the width of the table which also in effect reduces the font size.  This is specifically an issue in "Stacked Column" or similar charts.

Issue: When I use any of the Multi-Field Formula tool, I lose the variable names in the field description. This is a problem when I'm working with demographic data because the name of the variable is often something like PCT0010005. The user friendly name is in the field description metadata.

Solution: Please have the Multi-Field Formula tool behave as the Formula tool does by persisting the field Description values.

Thanks!

John Hollingsworth