topic Re: Graph builder - plotting two x-y lines with selected rows and a third with all rows in Discussions

Graph builder - plotting two x-y lines with selected rows and a third with all rows

GregMcMahon — Thu, 15 Aug 2024 14:33:46 GMT

Hi folks,

Yes, I know the answer to this will be amazingly simple and so am asking with plenty of egg on my face, but I'm spinning wheels right now. These are actual versus predicted plots, and I want to plot two lines using only validation rows from a validation column (for a neural and a standard least squares regression), as well as the result from the regression with all rows. Thought the answer might be in local data filter with the validation column but no luck.

Thanks and warmest regards,

Greg

Re: Graph builder - plotting two x-y lines with selected rows and a third with all rows

jthi — Thu, 15 Aug 2024 14:56:16 GMT

Most likely the easiest options are to either create new column(s) with some missing values or stack your data and plot with that. Below is an example of using duplicate column for x-axis with some missing values

Re: Graph builder - plotting two x-y lines with selected rows and a third with all rows

GregMcMahon — Thu, 15 Aug 2024 15:05:41 GMT

Thanks Jarmo - I knew it would be ridiculously simple....