Alteryx Designer Desktop Ideas

We should have a simple mathematical functions under Formula Tool - Math functions to calculate specific Percentile data point. Or it can be a separate tool to derive various other statistical information.

The Python equivalent is Numpy.Percentile() OR quantile().

I have explored Alteryx app, help documentation and community posts without success.

In the Results - Workflow - Messages and Message Tool would like to add a new message type called Passed.

Changes:

1. In Results - Workflow Messages add new section between Warnings and Messages of Passed with Green Circle Icon

2. In Message Tool, add Message Type of Passed

Rationale:

This would be used for verifying data and indicating that tests have passed. I think one of the great advantages of Alteryx is all of the data verification you can do.  For example I can download a report of the totals of all transactions for the year and compare to my daily transactions making sure they sum to the same number.  Automated testing!!!  The issue is I have to report when the test pass as a warning and I would rather have some green success messages of Passed!  I like the visual indicator of success rather than just reporting the negative warnings & errors.

Thanks for considering.

The Join tool is one of the most used in the Community. After delivering some training for new users (Not technical) I see that it's difficult for them understands some some Joins, specially when the relationship between  the Sources it's not 1:1.

So I propose to show the Summary visually, extending the Browse current information:

- List of Left Fields Joined / Excluded

- List of Right Fields Joined / Excluded

Also It should be convenient a tool to analyze the potential relationship between the sources, to be used previous to Join...

Thanks!

When I use the rectangular lasso to select some tools and/or control click them, I want to see a count of selected tools please.

Hi, I would like the ability to hover over a point/polygon on a Browse tool that displays geospatial data and be provided with some information on the data that isn’t currently offered.  Namely, I would like the ability to hover over a point/centroid and have a bubble (a.k.a. tool tip) pop up displaying the exact coordinates of that datum, the row ID and some other unique identifying information (e.g. name, store number, etc).  Other geospatial tools provide this functionality.  See below:

Google Maps:

Alteryx:

And by the way, I realize Alteryx is not Google Maps, but as a data “consumer” or “interactor”, I think it’s just human nature for people to want them to “feel” the same.  Something to strive for, at least.

I would also like the ability to click a datum displayed on the browse tool and have it highlight the row on the Results pane.  The clicking functionality works going from the Results pane to the Browse tool, but not the other way.

Thanks!  Kurt

When I use Alteryx with Git, I experience a strange bug. I have a workflow with a batch macro inside and the macro questions are mapped to fields. When I save and commit the workflow, the macro questions are not mapped for anyone else who opens that version. Every time that workflow is opened after a commit, we have to map the macro questions. Why does this happen and how can we resolve it? Thank you.

As the titles says, the move up/move down buttons from the select tool or a similar logic are not available yet.

It would come in handy to have this option when creating apps.

I want to create Descriptions for my fields in addition to those Alteryx auto creates, Text to Columns tool for example. I want to load these descriptions automatically into Tableau Hyper files so when I use the Tableau describe field feature, I will see them there. It also sets up the potential to create a data dictionary in the Tableau workbook based on these descriptions. Please give the option to load field descriptions into Tableau hyper files. Thank you.

When models are complex and extensive, it can be difficult to locate specific sections of a workflow despite any effort to organize the tools. I believe that it would be beneficial to have a feature that saves focused views of the model, e.g. zoomed into a specific location or set of tools, with a configuration of expanded or contracted containers.

The intent would not to affect the data flow but rather facilitate the data analyst's movement within the file.

Please see the (simple) example below, where the zone if red could be a saved view, onto which the screen would zoom and shift when selected.

I would like to be able to have the Map Tool to change the Reference Base Map to Tom Tom CA if there is a Country column in the incoming data stream that reads "CAN".  Or change the Expand Extent from the default 10(%) to the number that's in a column called "Extent".

Right now I can only do it using the Macro interface tool, but I still have to make my selection after I select which data point(s) I'm using.

I want it to generate specific-format maps based on the input data I provide, so it could run automatically.

I guess, aside from the Spatial Field, Grouping Field, Thematic Field, and Label Fields, I'd love a Configurations Field(s).

I would like to see an included select window for (nearly) all tools. Sometimes almost half of my workflow are select tools because I try to minimize my data and improve naming as much as possible.

Example:

1) Removing unnecessary columns

2) Removing Lat/Long columns

3) Removing not needed columns from distance tool.

Another example would be the typical usage of cross-tab. In 90% of my cross-tab usage, I put a select tool behind it.

I think it would be good to have an included select window in nearly all tools. There are probably tools that don't need them, but I think it would be a good addition to many tools.

I would suggest to add an included select tool for (at least) these tools:

- Input Data

- Cross-tab

- Tile

- Formula

- Multi-Row Formula

- Multi-Field Formula

- Text To Columns

- Cross Tab

- Transpose

- Create Points

- Distance

- Trade Area

- ... 

For example, allowing the letters in front of the column titles to be formatted differently to make them stand out on a report. 

Creation of a Multi Append Fields tool instead of having to use Multiple Append Fields to join man different columns.

When using the equal sum option in the Tile tool, you have the choice to sort by a column. However, it's not clear from the tool whether the data is being sorted in ascending or descending order.

Confusingly, the data is sorted in descending order, compared to the default of ascending in the Sort tool. This seems counterintuitive, as a user would expect the same defaults across tools (we did! and it caused some consternation when we worked out it wasn't) and also because in most of our use cases, you want the highest tile to be the highest rank, e.g., if you were sorting households by income.

I have two possible suggestions:

     1. Update the tool properties so that it reads "Sort column (descending)". (Probably the easiest change!)

     2. Allow the user to specify a direction with another drop down that becomes active when you select a sort field (similar to the sort tool).

I know that the functionality of suggestion 2 is available by adding a Sort tool before the Tile and sorting the data in ascending order. However, having to do that every time seems to defeat the point of being able to sort in the Tile tool.

Thanks for reading!

Jason

Standard Tile configuration:

Option 1 (mock-up):

Option 2 (mock-up):

Hello,

I am using google analytics connector (v7.0.7) with alteryx  designer version 2019.4. I am using online option to sign in and able to extract required dimensions and metrics but when it gets disconnected, I have to select everything again.

That would be very helpful if  I can simply save my settings with selected dimensions, metrics and segments etc.

Thanks 

I would love to see an optional output anker for the render tool.

This would allow us to push a pdf/png into the python module. We could then build twitter/social media 'add ons' using python and fully automize the process.

Hi 

1:
I'm from Denmark, and like several other european countries we use commas instead of dot as decimal seperator. And we use dot as thousand seperator.

So if im working in a flow with loads of price fields, lets say cost price, amount per unit, amount and amount including vat i need to do a multi field replace. Else I dont get the output i can work with in excel or other programs.

So it would be great beeing able to set seperators on a flow level, like you can in excel when importing.

2.
Beeing able to set a date format on a flow level.
Lets say my input data is 12.12.2019 and i need 2019-12-12 in my output. If i work with several different date fields i need to use several datetime fields.
Alternate could be a multi field datetime ? 

3.
Having a search function when using the select ? And maybe a numbers order.

So if i scroll down, i could enter 3 - which means this would now be my 3. shown field? 

A great feature would be for CASS to provide the address type as Residential or Business.  Better yet, further breakdown of address type into single-family, apartment, retail, office, commercial, warehouse, etc.  This would be very beneficial when analyzing address data from the Tom Tom Address Points Calgary database and can allow a end-user to filter prioritize addresses in their analysis based on the type of address.

The performance profile option outputs a list into the results window. It is difficult to check the tools and continuously scan back to the profile. Make it easy! Put the times and percentages in the connection progress tooltips of all the tools.