Alteryx Designer Desktop Ideas

Hi,

Would it be possible to simplify some of the workaround processes that are needed for generating Chart Titles when using grouping by adding the potential for using the grouping variable in the Title string so that accurate descriptions can be generated.  At the moment it requires the use of a Report Text tool which is not as neat if considering the output that is necessarily generated by grouping.

Only a thought,

Peter

I have three groups: a control group, a group that got product A, and then a group that got product B. There is a way to test the differences across all groups rather than running separate t-tests (which introduces type I error several times). If my outcome is the percent of people who were contacted, I want to see if the percent is different across groups.

Control Group % who were contacted: 10%

Product A group % who were contacted: 25%

Product B group % who were contacted: 33%

I shouldn't have to run a t-test comparing control to A, then another comparing control to B, and then a third comparing A to B. I know the method is pairwise comparisons but I'm not finding how I can do this in alteryx and I've looked on the community and surprisingly the answer seems to be "you can't" but this is not a rare statistical test!

A product analyst at alteryx help build a macro in R to run the tests but the variables need to be categorical rather than continuous. The ideal solution is that an additional predictive analytics tool can run these ANOVA tests and there's something to specify whether the variable is categorical or continuous.

-Justin

Hi,

As it is so important to be able to calculate and present time related concepts in modern businesses, it is not possible to have a better output choice?  I have seen the reporting chart tool, I have looked at the TS Plot tool and even noticed that the Laboratory Charting tool has disappeared.  So can you please provide an output tool that provides some focused functionality on this lacking part?

Kind regards,

Peter 

1. The Union tool 

When switching to Manual method and then adding fields up stream, the result is a warning "Field was not found". I don't look for warnings. This should create a red error. Having fields fall off the workflow is a pain.

2. Unique tool

Changing fields upstream causes the tool to error out when the workflow runs. No issues are shown before the run. 

3. Having containers all open up when I reopen a workflow is a nightmare when you have 20+ containers all over lapping.

It would be great if the deselecting of fields in a select tool updated the output window(before next run) as a "review" to make sure you are removing what you expect and/or you can see other items left behind that should be removed. This would also be useful for seeing field names update as  you organize and rename.

Often I join tables w/o pre-selecting the exact fields i want to pass and so I clean up at the end of the join. I know this is not the best way but a lot of times i need something downstream and have to basically walk through the whole process to move the data along.

In the DateTime tool, you should be able to specify AM PM.  Some other programs I use would do this with an 'a' at the end.  Here is an example of what I think it should be

MM/dd/yyyy hh:mm a

Maybe I am missing something and this is already doable, but so far I haven't found a clean way to do it. 

Alteryx current C5 implementation requires very carefully crafted data to work.

This is fine in an academic environment, however production datasets are rarely available with such low level of tolerances.

Competing products have implementations that will not fail as easily and Alteryx doesn't have any other multi-way decision tree option.

A good alternative would be otherwise a tool that does some dataset diagnostic so that we at least can know where the problem is without having days of data scientist time to comb the dataset.

Thank you,

Marco

Can we have string function that parse the string between 2 indices?

As FindString can find particular string occurrence,we can easily get required part of string easily from that index till required index.

or If we want entire remaining string we can have a function like:

Substring(String,StartIndex,EndIndex) Where endIndex can be : Length(String)-1

When enriching your date data, week information is pretty critical, I suggest adding %w to the format stings as well..

Several month based expressions can also be made weekly, data time first of week #31, last of week #45 etc....

Also came across a lot of questions at our community on how to turn week based data...

Writing the formula is obvious (Ceil(DateTimeDiff([Today],[Date],'days')/7))

but having a DateTimeDiff([Today],[Date],'weeks') is preferable don't you think?

Cheers

It would be nice to have the option to open a macro from the configuration window.  I often use the find tool to locate macros and sometimes they are in collapsed tool containers or buried under other tools and it makes it difficult to right click on the tool itself.  The find tool brings up the configuration window so if there was a button on that window it would make opening the macro more efficient.

Currently, there is a setting in the table tool to control the decimal places of all values by column. This is not only unnecessary, but it actually screws up any data that comes in where the ROWS may have different number of decimals. The only way around it is to convert everything into strings, which is annoying. Please just get rid of that column setting! Or enable the same setting inside the row rules. 

Hi - I was attempting to build a workflow as an analytics app that could notify the user with a message when there is fallout from certain joins that needs to be reviewed. Not all fallout is bad fallout, so I would not want the message to stop the workflow form running, but rather give a friendly reminder to verify that the fallout is okay or immaterial. It is my understanding that their is currently not a solution to this after speaking with the support staff.

Thanks,

Trevor

Hi,

Since the Geocoders create point data, having the spatial field recognized as a centroid can be helpful to the user. If it's marked as a centroid, it makes it easier for the user to differentiate between point vs polygon/line, especially if the user is already using polygon data in the module. If I do a Spatial Match or Join, I can have two fields called SpatialObj, which I have to track back to figure out which is which. If after combining, it showed Centroid for my geocoded points and SpatialObj for my polygon data. Kind of like you do for the Create Points tool, if I use that the field is called Centroid.

Thanks,

Field selection in Multi-Field Formula seems to be 'All' or 'All of a Type' or, potentially, lots of manual tagging.  I have >600 fields and want to select about 150 adjacent fields.  Is it possible to implement a 'mass select' option within the Multi-Field Formula Tool, as found in other tools?

Map input allows the user to connect the Q anchor to a file browse in order to navigate for a Reference Layer.

Please allow functionality for the tree input tool to do this as well.

Thanks!

I keep making the same changes to the table tool rules, using the same formulas when I build new reports. For example, Row Rule 1: Font, bold; Background Color, green; Row Rule 2; Font, bold; Background Color, blue; Row Rule 3; Font, bold; Background Color, yellow. Each is based on a formula:  IsEmpty([Column Name]). I do this over and over and over again. The only thing that changes is the column name. It would be nice to have the Row Style Rules saved so they can be browsed to" or inserted.

Still waiting for the Default Table Settings to include "CENTER" in the header tab.

recently loaded the new V11 and gettting used to it.  one immediate gripe is the new version of the Formula Tool no longer supports multiple field actions.  In the prior version I could change Data Types on many fields at once.  I could move multiple fields in a block at once.  there were a few other things but these are things I am sorely missing on my first use of V11.  I created about 20 fields in quick succession just getting names down and then going back and putting in formula which were variations on a theme.  When done I noticed the default DataType was V_WString and I wanted integer.  In the past it was no big deal because I could select the block or interspersed fields and then right click to change data type for all to the same data type.  it was very handy and now appears to be gone.  please bring these things back.

For some workflows I see the value of concentrate a high number of formulas in a single Formula Tool, specially when you have a considerable number of simple and independent formulas. This makes future changes to the workflow easier, since you (and other in your team) know where exactly to find the formulas in a workflow. But as higher the number of formulas in Formula Tool, more difficult is to find a specific formula in the tool.

My suggestion is to implement a sort option - so you list the formulas/columns alphabetically - and/or a filter option - bringing the relevant formulas/columns as you type. 

Since I am relatively new in the Alteryx world,I am not sure if there is an alternative for that (officially or unofficially speaking).

Thanks. 

Please consider displaying the count of records identified by the tool in the image of the tool on the workflow screen.  

This will save time when analyzing data: I will no longer need to copy and paste the values into a comment.  The value will be "captured" because I tend to print these particular work flows as pdf's.

Thanks,

Nick