Alteryx line chart (versin 11.7.4): Automatic selection of chart series

Dhaval

I am trying to plot a very basic line chart using charting tool.  I have an output from a cross-tab tool.  I need to plot first column on X-axis and all remaining column on Y-axis.  Problem is that number of columns and column titles are not fixed.  They can keep changing. The chart tool fails to generate desired graph - it ignore new column and columns for which header/title are new.  Can someone help?  I am looking to solve this issue specifically in version 11.7.4.

jamielaird

Hi @Dhaval 

I can't think of a very elegant solution to this, but here's a suggestion:

• Read in your data without field names in a structure where the first column is the X axis value and Field2, Field3 etc. are the values you want to see on the Y axis (i.e. your lines).
• Add and correctly name enough columns to cover the maximum possible extent of the data (e.g. up to 20 fields).
• Create a chart and add all 20 fields as layers. Many of these will be blank so no line will show.
• Hide the legend
• When new data flows in as long as it comes into one of your preconfigured field names 'Field4, Field5, etc.' it will be plotted on the chart.
• Use another method to build a legend that accurately labels the data, for only the rows that have genuine values. You would change Field1, Field2, etc. for the actual field names. This would need to be created as a separate object, possibly as a table. You'll have some work to do to match up the colours but hopefully they would be assigned in a default order you can replicate.
• Use a layout tool to place your legend next to the chart.

As I said, it's not very elegant, but that's the only approach I can think of. You might be able to do something using a macro and overlaying the PNGs outside of Alteryx but I'm not sure about that.

Tricky question!