Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

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

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

Submission Guidelines

Featured Ideas

0 Likes

Just like there is search bar for Select Tool, there should be one for Data Cleansing tool also.

Hi currently if you use the cross tab tool and the names of the new fields should have special characters they end up being replaced in the new headers with underscores "_", and then need to be updated in someway. It would be great if this was all done in the tool. In other words the new headers have the special characters as desired

Is it possible to add a search feature to the Summarize Tool that is similar to the search feature in the Select Tool?  Selecting specific fields to summarize in small datasets is fine, but if I am dealing with a table that has 200 fields searching for a specific field can be cumbersome.  Type in a few key letters to filter the available fields would be helpful.

Looking for a tool to replicate the Goal seek functionality built into Excel.

Seems it could be solved by using R or iterative macros however a tool would make life much easier,

0 Likes

We had a workflow where we needed to count business days. The standard solve of generating rows for each day between the dates wouldn't work as it would slow down the workflow too much.

 

Something that takes 5 seconds in Excel turned into a tremendous pain.

 

It would be really nice to have a built out tool where you can input the start date / end date (or what field they are tied to).

Which days of the week are considered business days and which days are not.

Which holidays should be excluded and available to add custom holidays.

Add the remove or add Prefix or Suffix Feature on the Summary Tool because this is where the prefix is added automatically by the Summary tool, so instead of adding a new select tool after the Summary tool to remove the prefix. why not to embed it with the summary tool it self. 

SaadNaser_1-1680691189920.png

SaadNaser_2-1680691215294.png

 

 

 

 

 

 

It would be nice to be able to concatenate numeric values (integers, doubles, etc.) directly in the Summarize Tool.

 

I know this would involve converting it to a string on the backend, but I don't believe there would be any data loss when going from numeric to string. I know this can be done by using other tools like Select of Formula to convert to string before the summarize but I don't see any reason why this couldn't be accomplished in a single tool.

 

pfiskrat_0-1672938971429.png

 

 

Thanks,

Paul

Why Alteryx does not have an easier way (Drag, Drop, Click and Run) to calculate moving averages with a specified lookback? There are so many things that one has to adjust before calculating moving averages for a simple numeric column.

I understand that there is a CrewMacros called "Moving Summarize" which does that, but it has a limitation of a lookback period of 100. What if you have data with millions of rows where you need a lookback in 1000s then there is no easy solution to this.

 

Does anyone know that this configuration is in the making? Moving Average is bread and butter for analysts like me. I am urging Alteryx developers to build this tool asap. and it will bring lot of comfort to my troubled soul.

 

Maybe i am clearly missing something here, please enlighten me!

 

Thank you!

0 Likes

For the summary tool, allow for the field data definition type of the output.  

Hi,

 

I spend too much time creating functions and supporting fields to help me aggregate based on dates.  I think that it would be very useful if the Summarize (US spellings....!!!) tool could be extended to include Date Aggregations that were naturally built in such as using a Date field to Group By Year, Month, Date.

 

I think that this would be a very easy update to the existing functionality and would be very useful as good time could be spent to provide all the usual date / time aggregations pre-made for users.

 

Kind regards,

Peter

As in title - it might be helpful to define custom name when you are using Transpose tool instead default nomenclature "Name" and "Value".

0 Likes

Hi 

In all its simplicity, I would like to be able to group by Month based of dates:


Hamder83_0-1668170619078.png


To acieve something like this:

Hamder83_1-1668170691432.png

 

A simple quality of life improvement that I would love, is the ability to rename the output of the transpose tool in its configuration, rather than only having 'Name' and 'Value' 

 

Would just let me drop the renaming of these fields afterwards :)

0 Likes

The Summarize tool returns NULL when performing a Mode operation. This doesn't seem to be documented anywhere in Alteryx documentation nor the community. Please fix this behaviour.

When using the transpose and cross tab tools, I find that I frequently need to reorder the columns selected in the "Key Columns" and "Group data by these values" sections of the tools respectively by using a select tool. It would be helpful to provide users with the ability reorder fields displayed in these tools similar to the functionality provided in the select, join, append, summarize tools etc. Currently the tools default to outputting these columns in the order they come in through the incoming data stream. 

 

gautiergodard_0-1664985433971.png

gautiergodard_1-1664985447423.png

 

 

Lots of use cases involve concatenating some values based on group by clauses within the Summarize tool.

It will be great to have the option to Concatenate Unique as an aggregation method, so the results will have just one appearance for each value in the results.

Plus, having the option to get the chance to have them sorted or not will be awesome.

I test the  10% percentile for {1,2,3,4,5,6,7,8,9}, whch alteryx gives 1.8, while it should be 1.
According the help, it should return the value of the target row, which shall not result any decimal in this case.

Capture1E.PNG

Currently both the formula and summarise tools round to 6.d.p for finance calculations such as IRR. People coming from Excel will be used to a higher precision then this. It would be great to up the precision in line with other platforms to 8.d.p +

IraWatt_0-1655249178429.png

 

Hello --

 

Many times, I want to summarize data by grouping it, but to really reduce the number of rows, some data needs to be concatenated.

 

The problem is that some data that is group is repeated and concatenating the data will double, triple, or give a large field of concatenated data.

 

As an example:

Name                                         State

ANew York
ANew York
ANew Jersey
BFlorida
BFlorida
BFlorida

 

The above, if we concatenate by State would look like:

ANew York, New York, New Jersey
BFlorida, Florida, Florida

 

What I propose is a new option called Concatenate Unique so I would get:

ANew York, New Jersey
BFlorida

 

This would prevent us from having to use a Regex formula to make the column unique.

 

Thanks,

Seth

Issue

 

Whenever a Summarize tool is used, it renames the output field (e.g., sales becomes SUM_sales or AVG_sales).  

 

Proposal

 

I think a reasonable compromise is to by default not rename fields in the Summarize Tool, but to include an option (in the tool, or in global settings) to allow for renaming.

 

Rationale

 

I have yet to come across a use case where automatic renaming of aggregated fields is desirable. What I have come across is the annoyance to rename the fields back to what they were with a Dynamic Rename tool, and sometimes having to do this multiple times (e.g., converting back a SUM_SUM_SUM_sales back to sales). Additionally, automatic field renaming causes workflow errors when workflows are later modified by adding/removing a Summarize tool (e.g., if you later add a Summarize tool, all downstream steps will expect the "sales" field and not know to use the "Sum_sales field). 

 

Automatic Renaming feels very much like historic Excel with Pivot Tables field renaming and not reflective of modern code-based workflow best practices.

 

I appreciate you considering this improvement.

Top Liked Authors