community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.

1 Review

Our submission guidelines & status definitions before getting started

2 Search

The community for a solution or existing idea before posting

3 Vote

By clicking the like in the top left corner of an idea you support

4 Submit

A new idea to suggest a product enhancement or new feature


Suggest an idea
0 Likes

There is a great functionality in Excel that lets users "seek" a value that makes whatever chain of formulas you might have work out to a given value. Here's what Microsoft explains about goal seek: https://support.office.com/en-us/article/Use-Goal-Seek-to-find-a-result-by-adjusting-an-input-value-...

 

My specific example was this:

 

In the excel (attached), all you have to do is click on the highlighted blue cell, select the “data” tab up top and then “What-if analysis” and finally “goal seek.” Then you set the dialogue box up to look like this:

 Set cell: G9

To Value: 330

By changing cell" J6

 

And hit “Okay.” Excel then iteratively finds the value for the cell J6 that makes the cell G9 equal 330. Can I build a module that will do the same thing? I’m figuring I wouldn’t have to do it iteratively, if I could build the right series of formulas/commands. You can see what I’m trying to accomplish in the formulas I’ve built in Excel, but essentially I’m trying to build a model that will tell me what the % Adjustment rate should be for the other groups when I’ve picked the first adjustment rate, and the others need to change proportionally to their contribution to the remaining volume.

 

There doesn't really seem to be a way to do this in Alteryx that I can see. I hate to think there is something that excel can do that Alteryx can't!

0 Likes

Just ran into this today.  I was editing a local file that is referenced in a workflow for input.

 

When I tried to open the workflow, Alteryx hangs.

 

When I closed the input file, Alteryx finished loading the workflow.

 

If the workflow is trying to run, I can understand this behavior but it seems odd when opening the workflow.

 

0 Likes

When viewing spatial data in the browse tool, the colors that show a selected feature from a non-selected one are too similar. If you are zoomed out and have lots of small features, it's nearly impossible to tell which spatial feature you have selected.

 

Would be a great option to give the user the ability to specify the border and/or fill color for selected features. This would really help them stand out more. The custom option would also be nice so we can choose a color that is consistent with other GIS softwares we may use.

 

As an example, I attached a pic where I have 3 records selected but takes some scanning to find where they are in the "map".

 

selection_colors.PNG

 

Thanks

 

0 Likes

The Field Summary tool is a very useful addition for quickly creating data dictionaries and analysing data sets. However it ignores Boolean data types and seems to raise a strange Conversion Error about 'DATETIMEDIFF1: "" is not a valid DateTime' - with no indication it doesn't like Boolean field types. (Note I'm guessing this error is about the Boolean data types as there's no other indication of an issue and actual DateTime fields are making it through the tool problem free.)

 

Using the Field Summary tool will actually give the wrong message about the contents of files with many fields as it just ignores those of a data type it doesn't like.

 

The only way to get a view on all fields in the table is using the Field Info tool, which is also very useful, however it should be unnecessary to 'left join' (in the SQL sense) between Field Info and Field Summary to get a reliable overview of the file being analysed.

 

Therefore can the Field Summary tool be altered to at least acknowledge the existence of all data types in the file?

0 Likes

I have a very large geospatial point dataset (~950GB) .  When I do a spatial match on this dataset to a small polygon, the entire large geospatial point dataset has to be read into the tool so that the geospatial query can be performed.  I suspect that the geospatial query could be significantly speed up of the geospatial data could be indexed (referenced) to a grid (or multiple grids) so that the geoquery could identify the general area of overlap, then extract the data for just that area before performing the precise geoquery.  I believe Oracle used (uses) this method of storing and referencing geospatial data.

0 Likes

Would love a tool where I could do Weighted Averages etc.

 

Ideally be able to write: SUM(Price * Volume) / SUM(Volume) and it would work.

0 Likes

Dear Alteryx

 

Typing econometric formulas within the Formula tools can be very tyring when formulas are long and complex

 

What would be very nice, would be to have the possibility the get a a kind of "Formula" format (in adition to double , string, datetime ...).

When the format is set to Formula, Alteryx automatically detect that it is a formula and use it as such.

It would allow to import easily external models formulas without to type or paste them within Alteryx

 

Many thanks

 

Arno

0 Likes

Hi,

 

Today I pressed F1 in the Output Tool to find out what the setting Transaction Size does. It turned out that this is not documented.

 

It would be a great idea to make a documentation that covers the options of a tool.

 

Regards,

 

Frank 

0 Likes

Can you devise a way to bring out the dynamic network visualisation on to Powerpoint.  Right now, we can only see a static image on a browser

0 Likes

I found what I think is a bug.  Usually the bug maker is me, but on this occasion I really think that it could be Alteryx (version 10.1.6.60263).  Maybe we could add a category for posts as:  Is this a bug?  Currently, the idea labels allow for a "BUG".  But is bug reporting really part of New Ideas?

 

I'm going to report my findings to clientservices@alteryx.com.

 

For those interested in what I'm observing:

Try creating a INTERFACE using an ERROR MESSAGE tool.  Once you've got a formula and an error message, check the ANNOTATION.  Do you see one on the canvas and do you see it in the configuration?  Try putting a brief annotation into the Annotation box.  I believe that the Annotation should appear in the annotation box as it does with other tools. Check the canvas and see what happens.  Here's what mine looks like:

 

Annotate Bug.PNG

0 Likes

Scenario: I open a results window with a link, filepath, value, etc. and I want to copy the text.

 

If I click inside of that cell and press Ctrl +A, nothing happens.

 

If I click inside the cell, arrow to the end of the text, and then press Shift + Home; the contents of the cell are highlighted.

 

Why can't we have all of the Windows shortcuts?  Or am I missing something here?

0 Likes

Idea to have the option to include the workflow "meta info" (last tab of the workflow configuration when clicking on the cavas) when printing the workflow.

The Meta Info desciption and author sections would be particularly of value. Currently on the long file name is embedded in the header.

0 Likes

When building workflows, it would be nice to have "Save Workflow" and "Run Workflow" added to the right click menu when in the canvas.

 

Menu.png

 

Add to Right Click menu:

Save Workflow

Run Workflow

0 Likes

Would be nice to make it so if I change from RowCount to index it all is linked together.

 

Something like a $FieldName$ which would automatically get substituted. 

 

Also nice in other formula tools, but most useful in places where name needs to be duplicated over and over

0 Likes

My client today asked if Alteryx could be configured to build/run horizontally from right to left.  Thought I'd post the idea. 

0 Likes

The "Field Summary" tool and several others have a configuration requirement that provides a list of fields to select or deselect.  The selection action is singular meaning you can only effect the action on one item in the list of many.  As the number of fields we work with grows significantly this becomes a time consuming and tedious task.

 

This should be enhanced to allow highlighting of multiple fields to select or deselect as we can do in tools like the "Select" tool.

0 Likes

The field summary tool is an excellent resource to get an overview of the data and spot targets for analysis or data cleansing. 

 

Unfortunately it has limitations either in the number of fields included or some combination of the number of fields and one or more of its attributes.   There is nothing in the documentation I found to make a user aware of this. When you exceed fields selected the system just hangs, indicating it is running but there is no connection progress shown and nothing seems to happen, even if you limit input to 1 record.

 

Through trial and error I found an approximate limit in number of fields I can include and still have it work.

 

I request that Alteryx update the tool help info and devise enhancements to dynamically load balance the tool so it can scale to the number of fields requested or at least warn when the limit is reached or approached.  The latter warning could be similar to the red font warnings in the formula tool when you have a malformed expression.  However a load balancing version is most desired.

 

The issue as it stands results in users wasting a lot of time trying to make the tool work as expected, then report it to support as an apparent bug in the tool which can be argued both ways.

 

I realize in the real world there are limits but in this real world we are seeing the number of fields to analyze increase significantly, especially when you have a data license and integrate 3rd party data to you own native data adding a hundred or hundreds more fields.

0 Likes

How about adding the ability to split intersecting trade areas at the points of intersection to create two new spatial objects.  The two objects could then be used to process customer records and divide them into "territories" based on  the line of intersection.

 

TASplitExample.PNG

 

0 Likes

Hi Alteryx,

 

I tried importing a file into my text input tool and I ran across this error.

 error.png

 

Why is there a limit? Can we get rid of it since we're not living in DOS anymore.

0 Likes

I am trying to use the Dynamic Replace to selectively update records in a set of variables from survey data. That is, I do not have all potential values in the “R” input of Dynamic Replace. Instead, I have a list of values that I would like altered from their current values by respondent (RespondentID) and question # (Q#).  Currently, when I run the workflow, any Q#/ResponseID combos that are not in my “R” input are replaced with blanks. However, I would like an option that maintains the original data if there is nothing to replace the data with. Without this option, there are few (I'm still working on some ways) workarounds to ensure the integrity of the data.

 

Matt

Top Liked Authors