Hi, I seem to cannot get this right.
For context, I have a couple hundreds of thousands of records, each record in the following field format:
|Invoice ID||Amount Billed||Account Receivable||Invoice Date||Collected Amount||Past Due Amount||Due Date||20+ more fields tied to action filters|
The data input is coming from Alteryx, but I cannot modify Alteryx workflow. I have to work with the fields I have above.
My task is to plot on a line graph where [Amount Billed] and [Account Receivable] is plotted along the [Invoice Date] x-axis, with $ amount as y-axis. Which is easy.
Next, I have to plot on the line graph where [Collected Amount] and [Past Due Amount] along the [Due Date] x-axis, with $ amount as y-axis. Which is the result:
Now if I try to combine the two graphs together using both date series as synchronized dual axis, each measure value got drawn twice because each measure value has two data series as described in the field format table above.
Any ideas how to solve this? Your help is appreciated.
I am trying to make it so that each of the 4 measure values have exactly one line, and 2 measure values are plotted against one time series, and the other 2 measures plotted against the other time series - as described earlier.
Again, I cannot modify the Alteryx workflow, even if an easy solution is to have Alteryx duplicate rows for each time series.