We have discussed on several occasions and in different forums, about the importance of having or providing Alteryx with order of execution control, conditional executions, design patterns and even orchestration.
I presented this idea some time ago, but someone asked me if it was posted, and since it was not, I’m putting it here so you can give some feedback on it.
The basic concept behind this idea is to allow us (users) to have:
This approach involves some functionalities that are already within the product (like exploiting Filtering logic, loading & saving, caching, blocking among others), exposed within a Tool Container with enhanced attributes, like this example:
The approach is to extend Tool Container’s attributes.
This proposition uses actual functionalities we already have in Designer.
So, basically, the Tool Container gets ‘superpowers’, with the addition of some capabilities like: Accepting input data, saving the contents within the container (to create a design pattern, or very commonly used sequence of tools chained together), output data, run the contents of the tools included in the container, etc.), plus a configuration screen like:
This should end a brief introduction to the idea, but taking it a little further, it will allow even to have something like an Orchestration layout, where the users can drag and drop containers or patterns and orchestrate them in a solution, like we can do with the Visual Layout Tool or the Interactive Chart tool:
I'm looking forward to hear what you think.
This has probably been mentioned before, but in case it hasn't....
Right now, if the dynamic input tool skips a file (which it often does!) it just appears as a warning and continues processing. Whilst this is still useful to continue processing, could it be built as an option in the tool to select a 'error if files are skipped'?
Right now it is either easy to miss this is happening, or in production / on server you may want this process to be stopped.
I surprisingly couldn't find this anywhere else as I know it's been discussed in person on many occasions.
Basically the Formula tool needs to be smarter in many ways, but this particular post focuses on the Data Type component.
The formula tool, should not always default to V_String as the data type when entering data or a formula into the formula tool, it should look at the data type and estimate the most likely option.
I know there are times where the logical type might not be consistent in all fields, but the Data Preview and the Function of the formula should be used to determine the most likely option.
E.G. If I type a number or a date directly into the formula tool, then Alteryx should be smart enough to change the data type from the standard V_String to Int, Double or date.
This is an extension to the ideas posted here:
I often need to create a record ID that automatically increments but grouped by a specific field. I currently do it using the Multi-Row Formula tool doing [Field-1:ID]+1 because there is no group by option in the Record ID tool.
Also, sometimes I need to start at 0 but the Multi-Row Formula tool doesn't allow this so I have to use a Formula tool right after to subtract 1.
So adding a group by option to the Record ID tool would allow the user not to use the multi-row formula to do this and to start at any value wanted.
Love the new updates to the Browse tool in 2019.2! However, if you choose the option Open results in new window, which I do often so I can see my whole dataset, the search/filter/sort functionality goes away. Would be great if that new functionality also worked in the new window. Thanks!
Can't wait for the new base maps!
In-app screens, lot of space is wasted because components/tools can just be stacked one below the other.
It would great if we could also insert them horizontally.
Tags : screen, app, macro, layout, tools, UI
The Alteryx.Flexnetoperations.com license management site needs major work.
On the View Licenses page it shows all licenses going back several years. A basic need is to show only licenses which haven't expired, but that is not an option.You cannot even sort on the expiration column while you can sort on most others columns.
The most simple need is to see a list of my current active license users - but I do't see a way to do that.
I tried an "Advanced Search" and chose expiration date after 2019-10-29 and none of my licenses which expire in 2020 appear - I get a blank list.
Similarly on the administer machines page you cannot filter to hide expired licenses or even on the licenses column (which doesn't sort either).
The help link on the page doesn't bring you to help specific to that page but the general activation help front page. After several clicks I found this page:
But the help is incomplete (doesn't list Machine types or the difference between Active and Inactive)
Also, there is no export capability - copy and pasting into Excel is a formatting headache as it brings in check-boxes.
Lots of room for improvement here.
P.S. I understand that work is being done on this, but an ETA would be greatly appreciated.
I would like Alteryx to create an internship support program that provides a license similar to a trial but for an extended period, say 6 to 8 weeks, and tied to core certification. you could repackage much of the existing training into a curriculum aimed at educating new users sufficiently on the elements necessary to pass the Core certification within a short time frame.
Our organization just launched an internship program and had our first group of interns start 5 weeks ago. I had to come up with a plan that provided the intern a valuable experience. I decided to make Alteryx Core certification a key objective and put him on a spare license we had for the duration and worked with him to get his core.
I think this could be a great marketing tool for Alteryx. It would get more people entering the workforce educated about your product so that no matter where they end up they might already be a fan and suggest the tool as a solution in a new job that doesn’t currently know about you. Conversely it gives interns a certification that shows they know more than the other applicants for a job where Alteryx is already a tool. I am sure there are tax benefits to Alteryx as well for each license used.
This is kind of how we discovered Alteryx, we had issues with volume of data and technology limitations (Excel) and someone had used Alteryx at a prior company and suggested we try it out. We purchased a couple licenses, then within a couple years we had 16 licenses. You can’t sell someone who doesn’t know you exist…the internship type license is a good idea to expand the list of people in the workplace who know you exist. Even better they will have have reached a level of knowledge, core certification, to have a basic appreciate your value.
When you go to the web portal for downloads - it only allows you to download the latest release of a given major version.
For example - 2019.2 had 2 releases:
However when trying to download previous versions of 2019.2 (e.g. 2019.2.5) - the only version available is the latest version
Please can you allow server admins to download ANY public released versions?
We need either a customizable view/downloadable report and or a view like the License view with license and machine and user and account elements at the first level of report.
The license site (licenses.alteryx.com) is a step in the right direction but needs enhancement. Now it offers 4 different views of what must be essentially the same data source in a file or DB table(s). The problem is each view leaves out something important or requires you to drill down and lose your broader view across users or licenses. Also these you be downloadable to support driving automation of internal functions.
To extend the conversation the online license site should also be the trigger and management mechanism to add or remove licenses. Authorized license admins should be able to add seats to an existing account/license. this would trigger a confirmation email with bill for incremental prorated amount so all seats are co-terminus and truly interchangeable so as personnel change they can be reallocated without concern for which one terms next month or next year.
Additionally the Admin should be able to assign or re-assign any new or existing license seat to someone after adding their user data. the system would then trigger an email to the user with the correct key to use based on that assignment.
And finally, at least in this idea submission, I want to have additional fields the admins can populate for site specific information such as department, budget center, region, etc. This would allow an admin to see the rest of the data from internal perspectives like what licenses and seats are on what budget center. this could be downloaded to integrate with and facilitate internal accounting and budgeting systems. A department head can see who has what and what if any spare licenses are available in his area or budget center. In the current mixed deployment of seats across an organization and across alteryx accounts if we can tie specific licenses and seats to a department or budget center we can reallocate spare licenses in other departments to another and keep account straight internally regardless of Alteryx account management.
We are a small shop growing from 2 initial licenses to roughly 20 users across 4 or 5 departments with each doing their own purchases but in the mix of orders and renewals and new licenses with 2018 upgrades we now have users shotgunned across all contracts in a tangle of associations with no clear view of which department's budget to hit for which licenses and how to allocate unused licenses or how best to incrementally add seats. recently another department wanted to get 3 licenses and ended up on another departments budget center due to the confusion of licensing allocation as we look at this. this is just one simple example but we are already seeing other teams poach unused licenses during personnel shifts and changes and budget arguments cropping up.
Being small and seeing what I see i can imagine the issues of a large shop.
Finally, this submission is inspired by recent interaction with Alteryx Fulfillment team due to our own internal efforts to organize and clean up our licenses and contracts. Fulfillment helped me out by generating a report with all the columns I wanted but missed one. The original report took about a day from request to delivery. I asked for the additional column and they said they could do it within a few days. This is of course a one-off. But one of the powerful aspects of Alteryx is quick turnaround...it will really take a few minutes to add the column but will take them days to get to it.
One quick turnaround partial solution to most of this request would be to provide us, the Admins, a tool to extract the full set of correlated data. Essentially take the report FulFillment has produced for me and make it an app or site feature that provides downloadable output. We Admins download it and then add our own site specific columns like department and such and at least see and manage the licenses and seats from our own customized reporting. When and if you do enhance per the request as a whole this could be kept or sunset according to what users want at the time. I expect this partial solution could be implemented very quickly and for very low cost.
In my company, we have our personal account (let's say myorganization\saubert) and, if we have the right to, a LOCAL admin account (eg : .\adminsaubert) to make install of sofware, etc...
So, the license is on my personal account
Now, I want to access the System settings :
And then I have this very friendly message :
If i click on "OK", it opens the License manager.
If I click on "Cancel", it closes the windows and I'm unable to change my system settings.
I think changing these system settings shouldn't require a license.
Now that Alteryx releases updates to Designer every quarter I'll likely be updating my copy of Designer frequently. Meanwhile, my IT team doesn't want to have to update Server every quarter to stay compatible. Problem there is, when I create workflows in the latest version of Designer they can't run on the older version of Server, nor on the Gallery.
Some features that would allow me to work around this:
I'm guessing this is a niche problem that few others will encounter:
Under the new licensing system (licenses.alteryx.com), I don't have the ability to truly release a license seat without user interaction. Currently, I have to revoke the license and then have that user start up alteryx on their machine to complete the process. Until the user starts up alteryx, I cannot reallocate that license.
I would like the ability to obsolete a license where as soon as I click the button in the licensing portal, I can immediately reallocate that license to somebody else. This functionality existed in the previous licensing system and is not available in the new licensing system.
it's not easy for an Alteryx Admin to keep track of all the versions & downloads they need to keep updating for their user base.
In our corporate environment, we also have to wrap any installers in a specific wrapper for them to be pushed out to user workstations, and many of the downloads on the alterxy site are not directly available but instead have to be done via the Alteryx Download Manager - as soon as the download manager tries to download the actual installer, this fails on our security firewall.
Please can you make all the key addins available on the downloads page http://downloads.alteryx.com/downloads.html as a final download rather than as a reference to the download manager, with clear version numbers
- Tableau Starter kit: the actual final installer is called Starter_Kit_for_Tableau.exe
- Starter kit for Microsoft
Additionally - it would be VERY useful if on the Downloads page, you could add a 3rd party section, and include a link to the latest tested drivers for :
- SQL Server
- Apache (Spark/Kudu)
- R tools for Microsoft
This would really help Admin teams to keep on top of the responsibility for keeping the environment up to date.
It would be very helpful to be able to assign a seat on a license to a portal user. We currently distribute licenses manually, but when folks get a new computer, sometimes the keys get lost in translation.
From an administrative standpoint, it would be helpful if when a user signs into licenses.alteryx.com, they could see the key name/amount of seats assigned to them. This way, the user does not have to rely on an admin to access their assigned key, and the keys themselves stay secured in the portal.
In the new licensing system at licenses.alteryx.com, I would like to be able to filter the "Administer Machines" tab by permanent vs. trial licenses. This tab is really helpful to gauge usage of our licenses by user, but right now, any trial licenses that have been parsed during the procurement process also show up as active machines.This is a bit confusing and hard to shuffle through the unlicensed users vs. licensed, especially since the actual key information on that page is only available when hovering over "License Info".
The ability to filter by more than one license key would also help with this problem.
I'm looking to optimize how we allocate licenses at our organization.
Seeing who has a registered license via the public Gallery has been helpful; but is there a way we can quantify usage?
Possibly a tool usage or an overall workflow run count?
Some of this suggestion may not be feasible due to Azure pricing guidelines - I am basing the idea/model off of anecdotal evidence.
Currently Alteryx Designer is available on Azure as a BYOL model, and Alteryx Server is available with both BYOL and a per hour license model.
I think it would be incredibly helpful to come up with a tiered "per hour" license model for Alteryx Designer in the Cloud, that leveraged something along the lines of "data consumption" or "data load" as a metric in order to offer up a price point that would allow for a more spread out "trial" period.
Something akin to "up to 8 hours/ 4 GB of data per month" at a free tier (obviously those numbers could change pretty easily).
In particular, my area has a lot of folks in IT who are anecdotally interested in leveraging Alteryx, but when we have been able to give them a trial license, they typically only find an hour or two over the course of a month to leverage it. Rather than constantly having to seek new trials for these users, I'd like to be able to suggest that they leverage Azure at a relatively low/fixed cost.
My experience with new Alteryx users is that they typically encounter a "cliff" where they try to think about problems the "old" way. Even though the old way is much slower, this resistance often limits their exposure to the tool until they solve a problem "the alteryx way" and realize how much easier things can be. Having this available over the course of, say, 3 months, where a user who managed to find 15 minutes could log in, play with the tool, and log out, at a cost-effective price point, would help to expand the use of Alteryx further for our organization.
Each license key can only handle up to 300 installations. For big companies like us in PwC, this is a struggle because we distribute software via SCCM and each territory needs to create a special script to handle this limitation. We have lots of folks using Alteryx so it would be great if you guys can find a way to remove this limitation or provide us with an easier and more efficient way to deploy the software to a huge amount of users world-wide. Thanks!
Is it possible to get a monthly subscription service to spread out the cost - perhaps to make it more beneficial your end we could have a 6 month minimum contract?
With some consulting projects you'd only really be able to bill the pro rata cost so that would help.