Don't forget to register for our panel discussion with Dean Stoecker, Amy Holland, and Mark Frisch occurring next Wednesday, June 1!

2022-05-26 Updates: Email: If you're not seeing emails be delivered from the Community, please check your spam and mark the Community emails as not junk. Thank you for your patience.

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Featured Ideas

I would like to see a time interface tool similar to the Date and Numeric Up Down tools. I am working on some macros where the user can select the time they would like to use a filter for the data. 

 

Example: I want all data loaded after 5:00 PM because its late and needs to be removed.

Example 2: I want to create an app where the user can select what time range they would like to see records for (business hours, during their shift, etc) 

 

Currently this require 2-3 numeric up downs or a Text box with directions for the user on how to format field with Error tools to prevent bad entries. It could even be UTC time.

 

Time Interface ToolTime Interface Tool 

The Data Sources page currently lists all the different data sources that Alteryx supports - however for an administrator it's almost impossible to ensure that their designer users have the drivers for these, or are on the right version.

 

As an early step - can we add 1 more field to this list which points to the downloader for the driver where applicable

https://help.alteryx.com/current/DataSources/SupportedDataSources.htm

 

The next step is to create a bundled driver pack that Admins can download once to cover all the relevant drivers needed for the data sources provided & supported.

 

cc: @revathi @AshwiniChezhiyan @LizaNemchynova

 

It appears that the Workflow Dependencies window does not report dependencies from all tools. In the example image, you can see that the file input from the Amazon S3 Download tool is not listed. Some tools may have dependencies that do not easily fit the current field structure of the window, but maybe the input/download tools could be listed with an asterisk or partial reference.

Missing Amazon S3 DependencyMissing Amazon S3 Dependency

Analytical apps currently do not have the ability to provide any indication of progress to users when hosted on the galaxy.

 

It would be valuable to be able to provide a progress bar or some indication of progress to the user when invoking analytical apps from the gallery.

Let's "Elevate" Alteryx to enter the Euclidean space and add the Z-Coordinates to our spatial tools!

Capture.png

 

So - with Challenge 111 - many folk used the Optimization tool

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-111-Make-a-Weekly-Challenge-Dream-Team/m...

… and Joe has done a great training on this here

https://community.alteryx.com/t5/Live-Training/Live-Training-Prescriptive-Optimization/m-p/44779

 

But it's still to hard to use.   It requires you to have pre-knowledge of a bunch of parameters and different types of knowledge.

 

Can we improve the interface on this tool so that it can be used by folk who do not have a background in R - for example, take all the different inputs, and make them parameterized on drop-down boxes or input boxes on the tool?

 

Thank you all

S

 

CC: @JoeM

It would be interesting to have the ability to change the orientation of a tool container separate from the orientation of the workflow. For example having a vertical tool container within a horizontal workflow will help keep the workflow short enough to view on one page. Also it would look alot better to collapse and expand vertically in a horizontal workflow.

 

 

Please offload map rendering, in Browse Tool, to the video card using DirectX or OpenGL, the software rendering currently used is embarrassingly slow and disruptive.  

As Alteryx becomes more focussed on the Enterprise - it is important that we build capabilities that support the needs of large-scale BI.

 

One of these critical needs is dealing with heterogeneous data from different systems that use different IDs for every critical entity / concept (e.g. client; product)

 

Here's the example:

Problem:

- In any large enterprise - there are several thousand different line-of business systems

- Each of these was probably built at a different time, and uses a different key for specific concepts - like Client & Product

- Most large enterprises that I've worked at do not have a pre-built way of transforming these codes so...

- This means that any downstream analytics finds it almost impossible to give single-view-of-customer or single-view-of-product.

 

Solution option A:

Reengineer all upstream systems.   Not feasible

Solution option B: 

Expect some reference-data team to fix this by building translations.   More feasible but not fast

Remaining Solution Option:

Just as Kimball talked about - the only real way is to define a set of enterprise dimensions, which are the defined master-list of critical concepts that you need to slice-and-dice by (client; product; currency; shipping method; etc) in a way which is source-system agnostic

Then you need a method in the middle to transform incoming data to use these codes.   This process is called "Conforming"

 

What would this look like in Alteryx?

Setup

  • We would use the connect product to define a new dimension - say "Product".
  • Give this a unique ID which is source-system independant; and then add on the attributes that are important for analytics (product type; category; manufacturer; etc)
  • Then decide how to handle change (slowly changing dimension or SCD type 0,1,2, etc).   Alteryx should take full responsibility for managing this SCD history; as do many of the competitors
  • We then create a list of possible synonym types (within Connect).   For example - a product may have a synonym ID from your supplier; from your ERP system; from your point of sale system.  that's 3 different IDs for any product.
  • We then load up the master data - this is painful but necessary

In Use:

  • I read in data into alteryx via any input tool
  • I bring in a "Conforming" tool off the toolbox (new tool which is needed)
  • It asks me which column or columns I wish to conform
  • For each - it asks me which synonym type to use
  • It then adds a translated column for me to use which ties back to the enterprise dimension - and spits out the errors where the synonym is necessary.

 

Impact:

In BI in smaller contexts, or quick rapid-fire BI - you don't have to worry about this.   But as soon as you go past a few hundred line-of-business systems and are trying to do enterprise reporting, you really have to take this serious.   This is a HUGE part of every BI persons's role in a large enterprise - and it is painful; slow and not very rewarding.   If we could create this idea of a simple-to-use and high-velocity conforming process - this would absolutely tear the doors off enterprise BI - and no-one else is doing this yet!

 

@AshleyK @BenG @NickJ @ARich @patrick_digan @JoshKushner @samN @Ari_Fuller @Arianna_Fuller 

I really like the Directory tool.  Its very handy, especially in combination with the Dynamic Input.

But... I'd like to see other object (files and folders) attributes, like object level security (who has read, write, full, etc), last user to access, and user that created.

It would be nice if this option would take you to the correct download page relative to the version the user has installed. Currently, this always loads the download page for the current version which is confusing for users of a company who are still required to use an older version.

 

image.png 

Alternative data sources namely #altdata are key for enriching data. One source is social media.

I believe Alteryx lacks in social media analytics.

 

  • I would like to propose a Instagram connector...
  • Crawl comments, tags(useful for text analytics)
  • Impression and likes... (time-series data)

 

If you are into #media, #advertising, #marketing analytics, #influencer analytics please support the idea by seconding...

 

https://www.instagram.com/developer/authorization/ is the link for the graph API updated after the latest acebook scandal... now fixed...

Picture2.png

 

Picture3.png

 

Picture4.png

 

Picture5.png

 

 

 

When a tool container is disabled, I'd like the lines that are going into it to be different from "enabled" lines. 

 

They could be grey or dotted for example.

 

When working on a workflow and disabling containers, I find that the lines entering disabled containers become confusing or cluttering. It would be much simpler to focus my attention efficiently if lines that remain enabled could be distinguished quickly.

Recently my trial license expired, and after receiving our activation licenses, I needed to upgrade from the 'User' version to the 'Admin' version.

 

When uninstalling the previous 'User' version, it appeared to complete successfully, and I then started installing the 'Admin' version from the installer.

 

After installation completed, I noticed that three versions of Alteryx appeared in my Windows 'Programs and Features' in Control Panel - Alteryx (Remove Only), Alteryx (Admin), and Alteryx (User).

 

When attempting to uninstall the 'User' version, it appeared to complete as expected, but did nothing when examining the application or root directory location, and I could still access and open and use the 'User' version of Alteryx.

 

To make a long story short, after going into regedit and removing all registry keys named 'Alteryx' including the SRC source key for Alteryx, I was able to manually remove all three of these versions and reinstall the 'Admin' application successfully.

 

Some kind of an uninstaller to wipe out all Alteryx directories, installations/versions, etc. to perform a clean uninstall/reinstall would be super valuable and probably save some folks a ton of time who are evaluating the product and moving from a Trial(User) version to an activated Admin license.

When output is disabled, Alteryx's output tools are helpfully grayed out and include the message 'output has been disabled by the workflow properties.'

However, if a macro has an output, there is no visual indicator that output is disabled, even though the macro's output will also be suppressed by this workflow configuration.

Obviously, macros can be very complex, and could have both a file and a macro output, or have an optional file output, so these cannot be entirely locked out just because there is an output.

To that end, I suggest some other kind of color-coding/shading be applied visually to these tools, and that a message be added to the interface for these macros that says something like "output has been disabled, this macro may not perform all of its functions".

I just spent about 10 minutes debugging why a macro wasn't working properly in one workflow but was working in another, and it was because I had disabled output, which I wasn't thinking of because this particular macro uses the Render tool to produce a hyperlink.  I wouldn't have spent more than 30 seconds on this if there was some kind of visual indicator showing me what I was doing wrong!

It may be user-friendly to display the DSN description. It's usually stored in the windows registry under "description" :

 

descirption_dsn.png

 

This should display in the log and when you configure a connexion.

Currently I am running two version of Alteryx and some of the macros were created/updated in the newer version of Alteryx. I would like to see only one error message displayed for all of the macros created in a newer version rather than having a dialog box pop up a dozen plus times (one for each macro) every time I open an instance.

 

Macro Error MessageMacro Error Message

Hey all,

We have a policy (similar to the best practices guide published recently by the Copenhagen user group - thank you @danielbrun2) that Alteryx canvasses should run without warnings.

 

However - some of the warnings are tremendously painful to track down. For example - a union that brings together 20 or 30 input streams which gives you a warning saying "not all fields contain field X".

 

Can we change this to multiple warnings saying "Input X does not contain field X" so that we click straight through to the offending warning?

Additionally - when there's a conversion error - we then have to run the flow again with filters and diagnostics to find the offending row. Can we have a way that alteryx automatically sidelines an example row so that you can solve it in one pass?

 

If we look at all the warnings with the intention of "how do we make this something that can be solved right now, without having to run complex diagnostics, so that the very next run is 100% clean" that would be a big help.

 

Thank you Sean

 

https://community.alteryx.com/t5/Inspire-2017-Buzz/24-Best-Practices-for-Moving-from-Ad-Hoc-Analysis...

 

When I publish using the tabcmd publish command in an event or using the Publish to Tableau Server Macro, the extract becomes LIVE. I do not want it to become LIVE, because when it does, I cannot refresh the extract using the tabcmd refreshextracts command or setup a refresh schedule in Tableau Server. Is there anyway to make this tde stay an extract after Alteryx rewrites the file? When the extract is live it will not refresh until I manually select Refresh in Tableau Server when I am in the Workbook that is connected to the data source I am publishing.

 

I posted the above question and was told this would be good to add to the New Idea module. Thanks!

I have a problem when transferring records between different O365 Sharepoint Sites.  It seems that Alteryx cannot maintain 2 separate connections at the same time.  I can transfer fine if I read from one site to a temp file and then, in another workflow, read from the file and write to the second site.

 

I can work around the problem using Block until Done, but there are some situations where I need to be able to compare between lists in 2 different sites and write back to one or both depending on the results.  it would be much more convenient to be have multiple connections open simultaneously.  I'm aware that Alteryx uses the SharePoint API to move information around.  This API does allow multiple connections.  I'm not familiar with the internals of how Alteryx accesses the API, perhaps the OAuth token is shared through out the workflow process,  but this should be posssible

 

Thanks for considering this

 

Dan

   

 

Top Liked Authors