Could we please change the Interactive Chart tool, to:
Sample Flow - derivation of challenge 201:
- The first interactive chart on this flow has no sorting at all performed by the charting tool - this may be due to the fact that the X & Y axes are in string fields. Generally line charts would attempt to sort both the axes and the values (where the values should order according to the X axis). Please can you add a default sort anyway?
- If you then change the data types on these fields to be numeric - the charting tool still does not sort them until you reconfigure the tool manually
- REquest: please can you get the tool to remember the data types, so that it can prompt you; or even better just reconfigure?
(image looks identical after retyping the fields)
- When you do a manual reconfigure of the tool after changing the types - the axes are sorted, but the values are not - so you end up with a chart that crosses back and forth. Generally line charts are ordered in the order of the X Axis for the values
- Request: Please sort values on the line chart automatically in order of the X value?
NOTE: Finally got the outcome needed by forcing the sort before the interactive chart tool
With the new intelligence suite there is a much higher use of blob files and we would like to be able to input them as a regular input instead of having to use non- standard tools like Image, report text or a combination of directory/blob or input/download to pull in images, etc. I would like to see the standard input tool capable of bringing in blob files as well.
There is an extensive need from customers to be able to create emails but not send them (right away at least). This would be an enhancement to the email tool to allow for checking a box to say "Save in Draft" and if that box was checked the send email functionality would not be called but the email would be created.
The only thing I have ever found that Excel can do that Alteryx can't is creating a pivot table that allows the user to drill up and down levels of aggregation by collapsing or expanding levels in the data hierarchy. (like this).
Can you add an interactive table to the new interactive charting tool that can provide this level of functionality? It's embarrassing to have to tell Excel users they can't do this in Alteyrx, and likely leads many of them to stick to Excel--and miss out on all the other great things Alteryx can do.
The email tool, such a great tool! And such a minefield. Both of the problems below could and maybe should be remedied on the SMTP side, but that's applying a pretty broad brush for a budding Alteryx community at a big company. Read on!
What I said the first time I ran the email tool without testing it first.
1. Can I get a thumbs up if you ever connected a datasource directly to an email tool thinking "this is how I attach my data to the email" and instead sent hundreds... or millions of emails? Oops. Alteryx, what if you put an expected limit as is done with the append tool. "Warn or Error if sending more than "n" emails." (super cool if it could detect more than "n" emails to the same address, but not holding my breath).
2. make spoofing harder, super useful but... well my company frowns on this kind of thing.
Hi to all,
I have seen one or two posts requesting ability to total up rows and/or columns of numbers, however this idea also requests the ability to subtotal data by a field and also produce an overall total.
This could be an extension to existing tools such as 'Summarise' and 'Cross Tab' or could be a stand alone tool. Desired output of using a tool like this would produce something like this:
This would be incredibly useful for building reports within Alteryx as well as analysing the data, and cut down the amount of tools currently required to produce this. I have seen a third party tool which does some of this but this adds the ability to subtotal.
thanks - Roger
Hello Alteryx Team
I would be great if you could enhance the emailing function to Include sending emails using the Microsoft Exchange Web Service (EWS). And not just SMTP as there are companies that do not Allow sending emails using SMTP but EWS is allowed.
When using Interactive Chart tool; or Insight tool - every time you click on it you are asked to configure, even if you've already configured this previously.
Please could you change this so that it displays the "Configure this tool" screen ONLY if there is no configuration in place.
It is just a bit of annoyance, really. I'd like to see the option of inputting a hexcode of color and/or a screen color picker in the color dialog. At the moment, you have to change R, G, B separately or play around with the cursor to find the right color.
The color dialog is relevant for the documentation purposes but also reporting tools and I'm sure it would make life easier to some people, especially when branding colours are important.
The reporting tools do not currently support HTML structured or unstructured lists https://www.w3schools.com/tags/tag_ul.asp
All vertical combination creates tables which group the lines together. Even if you manually create this - you get an error saying that ul (or ol or il) are not supported in composer
This creates a challenge in 2 ways:
a) When creating lists in reporting outputs - you lose the functionality of structured lists (numbering with letters; numbers etc)
b) additionally - selecting the text in tables behaves differently than selecting data that is created in lists.
Please could you add the ability to create lists in addition to tables in the reporting tools by supporting the ol; ul; and il tags?
NOTE: this could initially be done just by supporting the tags; and then later this could be a summarize option on the summarize tool; and a bullet option in the text tool.
I am trying to generate the multiple sheets in the same Excel using Render tool. one of the sheet having around 100 columns and other two sheets are having only 20 columns. If am configuring paper size to 50 inches in render tool, its affecting the other sheets too and Report doesn't look good since columns width are getting extended to some extent.
So, it will more helpful if there is an option to configure each sheet paper size or a rule kind of thing.
Please let me know if there are any option to that.
Thanks in advance...
Report text tools currently only give the option to allign left, right or center. Would be great if we could have the option to have a true 'Justify' option also as it makes chunks of text look so much cleaner
Alteryx has the ability to connect to data sources using fat clients and ODBC but not JDBC. If the ability to use JDBC could be added to the product it could remove the need to install fat clients.
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:
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.
Figuring out who is using custom macros and/or governing the macroverse is not an easy task currently.
I have started shipping Alteryx logs to Splunk to see what could be learned. One thing that I would love to be able to do is understand which workflows are using a particular macro, or any custom macros for that matter. As it stands right now, I do not believe there is a simple way to do this by parsing the log entries. If, instead of just saying 'Tool Id 420', it said 'Tool Id 420 [Macro Name]' that would be very helpful. And it would be even *better* if the logging could flag out of the box macros vs custom macros. You could have a system level setting to include/exclude macro names.
Thanks for listening.
I'd like to see an enhancement that at the install level (through an XML configuration file for example), the use of the From field in the Email reporting tool could be disabled for population by the end user and instead would auto-populate with that current users e-mail address. Currently users can populate the field with any address on their domain, which is useful, but also poses a risk in that messages can be made to appear to be coming from a party that is not aware of it. We'd like to be able to control that on install and "turn off" access to the From field
Currently, there isn't any option in the Salesforce Input tool > Existing Reports to remove the 2000 record limit for queries. Is there any way of removing that cap so that our queries will return the correct number of records?
I know this has been posted before, but the posts are fairly old, and I have just confirmed with Support that it is still an issue. Seems to be a pretty basic request, so I'm putting it out there again under this new heading.
The issue is that if you have data in a field, and you have that data separated by a new line (\n), it will show up fine in a browse tool, or pretty much any other output (database file, Office Document file, etc.). But if you try to use the Table Tool under Reporting, it ignores the line break and strings the data together.
The field data looks like this in a browse or most other outputs:
Hello, my name is
and I love
But when I try to pull this field into a Table Tool, it shows up like this:
Hello, my name is Michael Barone and I love Alteyrx
Putting this out here again in hopes that it gets lots and lots of stars so it gets put on the road map!!
Using other data viz tools like Tableau, we often plot yearly timeseries of data onto the same line chart so we can quickly compare year-on-year differences. All data viz tools seem to have complexities but the logical approach is the same. What you do is map all the years data to a relative year, i.e. this year, and then give each year it's own title. See the example below snipped from a Tableau dashboard:
In this example 7 years of data have been plotted on the same chart. Note the x-axis, In Tableau we are able to format the X-Axis labels to only show month and day (Mon-D). This removes the common relative year, i.e 2019.
As expected, Alteryx is awesome at preparing data to do this kind of thing. Using the interactive charting tool you can build really nice charts. However there is currently no way to format the X-Axis label, you must show the relative year too, as shown in the picture below (snipped from the browse tool, outputted from the interactive chart tool):
It was really easy to prepare the 5 year min, max and average lines, which is almost impossible to do in Tableau!
My idea in a nutshell is, please change the interactive chart tool so that the labels on the axis can be formatted to the user's choice, i.e. in this case formatted from datetime to "%B-%d".
Please note, the workflow i'm building in this case, is creating 3 line charts of related data, each by year. The end product is a daily email sent to users.
It would be good if the Email Tool could be enhanced so that it can send HTML e-mails, by that I mean the body of the e-mail is HTML based on a field in the workflow that contains a string of HTML.
Currently we are having to use batch files with command line e-mail clients to send e-mail with HTML generated within Alteryx workflows.