Sort values in Interactive Chart

[SeanAdams]

Could we please change the Interactive Chart tool, to:

• recognize when upstream types have changed and reconfigure (in the case of numerical types marked as string)
• For line charts - sort the values in order of the X value

Sample Flow - derivation of challenge 201:

Issue 1:

- 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?

Issue 2:

- 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)

Issue 3:

- 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

ChartingNotSorting.yxmd

[KylieF]

Thank you for your feedback and idea!

We’re currently working diligently to insure all product ideas are reviewed and commented on by Alteryx when the necessary criteria are met. If you haven’t yet, check out our Submission Guidelines which go over the idea boards in a bit greater detail.