Alteryx Designer Ideas
Share your Designer product ideas - we're listening!Upgrade Alteryx Designer in 10 Steps
Debating whether or not to upgrade to the latest version of Alteryx Designer?
LEARN MORE1 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 star in the top left corner of an idea you support
4 Submit
A new idea to suggest a product enhancement or new feature
Hello Product Management,
I'm trying to emulate a graph from the book, Effective Data Visualization by Dr. Stephanie Evergreen. Here's what I have so far:
This was a little bit of work to create and while it isn't what I exactly had hoped for, it does approximate my attempt. Ideally, I would do the following to complete the exercise:
- Have a Y-Axis (none) line on for both Old/New Sites (dual-axis)
- Replace the Y-Axis number with the Label for the departments
- Remove the (line) from the label
As observations, in order to add carriage returns to NOTES, i had to use HTML tags <br>. The settings for points and lines required me to do lots of configuration. Maybe a format painter would help to copy the format from one set of point/lines to the next. Once I completed a chart/insight it would be "nice" to be able to copy and configure the other. If you have an insight and wish to create a chart, you have to reconfigure the new element from scratch.
I do have an error in the creation of the chart that says, "Error parsing configuration." I have no idea what error exists. I submitted a ticket on that issue.
I haven't created this chart via Excel, but the textbook shows you how to create the result in Excel. The graph is easy for me to see and to understand. I like it and think that it could be a valuable way to demonstrate the potential for Alteryx visualizations.
Cheers,
Mark
The "Manage Data Connections" tool is fantastic to save credentials alongside the connection without having to worry when you save the workflow that you've embedded a password.
Imagine if - there were a similar utility to handle credentials/environment variables.
- I could create an entry, give it a description, a username, and an encrypted password stored in my options, then refer to that for configurations/values throughout my workflows.
- Tableau credentials in the publish to tableau macro
- Sharepoint Credentials in the sharepoint list connector
- When my password changes I only have to change it in one place
- If I handoff the workflow to another user I don't have to worry about scanning the xml to make sure I'm not passing them my password
- When a user opens my workflow that doesn't have a corresponding entry in their credentials manager they would be prompted using my description to add it.
- Entries could be exported and shared as well (with passwords scrubbed)
Example Entry Tableau:
| Alias | Tableau Prod |
| Description | Tableau Production Server |
| UserID | JPhillips |
| Password | ********* |
| + |
Then when configuring a tool you could put in something like [Tableau Prod].[Password] and it would read in the value.
Or maybe for Sharepoint:
| Alias | TeamSP |
| Description | Team sharepoint location |
| UserID | JPhillips |
| Password | ********* |
| URL | http://sharepoint.com/myteam |
| + |
Or perhaps for a team file location:
| Alias | TeamFiles |
| Description | Root directory for team files |
| Path | \\server.net\myteam\filesgohere |
| + |
Any of these values could be referenced in tool configurations, formulas, macro inputs by specifying the Alias and field.
Problem:
When searching for Alteryx help on Google the search results rarely return the current version of the Help documentation from the Alteryx website. Instead, what often happens is that an old version of the Help documentation is returned.
For example, a search for 'Run Commend Tool Alteryx' returns links for the 2018.3 and 11.3 instances of the help page:
These relate to prior versions of Alteryx and a better result would be to link to the /current/ version of the page (the URL for which never changes).
https://help.alteryx.com/current/RunCommand.htm
The problem above can be replicated for almost any tool or variant of search terms.
Since Google is such a crucial resource for troubleshooting, there is a risk that (a) users will inadvertently access out of date documentation and (b) users will be confused by the presence of multiple search results.
Solution:
By adding a 'robots.txt' file to web pages for prior versions of the tool these results can be suppressed from Google search results.
https://support.google.com/webmasters/answer/6062608?hl=en
This should result in the /current/ documentation pages rising in search results and being more prominent when users search for help on Alteryx using Google.
I think I'm liking the new UI, but I think it's necessary to bring back save, undo and re-do buttons....
1. Frequent saving of workflows is crucial and not everyone uses keyboard shortcuts
2. The ability to undo (lots) of changes is a key part of iterating and rapidly building workflows in Alteryx and again not everyone uses keyboard shortcuts to do this.
Looks like there's potentially space to add this to the right of 'help' (I suspect this might be technically quiet difficult) or to the left of 'run', 'schedule' and 'active documents' as seen in the image below.
Out of interest, where has the 'documents' terminology come from?
I really like that I can scroll -- using my mouse -- between the tool groups in Alteryx. Can this UX be added to scroll through my workflows? I usually have a bunch open, and this functionality would be awesome to have there, too! 
PS: Yes, I know I can do Ctrl+Tab...but mouse scrolling is more efficient.
If you are connecting to an Oracle database you can get faster results with adding a short hint to your SQL query. For a query like this
SELECT customers.cust_first_name, customers.cust_last_name,
MAX(QUANTITY_SOLD), AVG(QUANTITY_SOLD)
FROM sales, customers
WHERE sales.cust_id=customers.cust_id
GROUP BY customers.cust_first_name, customers.cust_last_name;
add /*+ PARALLEL(4) */ (or depending on your CPU size 8) and that SQL becomes this;
SELECT /*+ PARALLEL(4) */ customers.cust_first_name, customers.cust_last_name,
MAX(QUANTITY_SOLD), AVG(QUANTITY_SOLD)
FROM sales, customers
WHERE sales.cust_id=customers.cust_id
GROUP BY customers.cust_first_name, customers.cust_last_name;
There is a similar capability for SQL Server too...
SELECT *
FROM Sales.SalesOrderDetail
OPTION (MAXDOP)
I suggest adding this feature in in-db tools so that no one needs to alter the SQL query itself...
You can check out the inner workings for oracle here; https://docs.oracle.com/cd/E11882_01/server.112/e25523/parallel002.htm
- Atabarezz on: AI assisted workflow in AYX!
- hblaiklock on: Text above and below table in report text tool
-
chris_love
on:
Raise a Conversion Error if string data will be tr...
- Atabarezz on: Admin Needs More Control
-
KaneG
on:
Workflow Bookmark
- jamielaird on: Use robots.txt to prevent old Help documentation a...
- Atabarezz on: Drawing Tools e.g. Line/Arrow, plus a few more
-
Hollingsworth
on:
Conditional Split Tool
-
SeanAdams
on:
Directory Creation Tooling
-
joe_lipski
on:
change font
