Alteryx Designer

Share your Designer product ideas - we're listening!

Sort values in Interactive Chart

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:

IMG0-Flow.png

 

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?

 

Img1-NoSorting.png

 

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)

Img1-NoSorting.png

 

 

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?

 

Img2-AxesSortedButNotValues.png

 

NOTE: Finally got the outcome needed by forcing the sort before the interactive chart tool

 

 

Img3-ExpectedOutcomeAfterSorting.png