I’m trying to figure out why Spotfire is having issues with making line connections on my scatterplot. All points of data have an x-axis for Days and a y-axis for Running Depth. All points share the same Well Name (or property name). Some points can be associated as moments of realized failure marked by the “x” shape, while most other points were not failures. My line connection is indicating to connect by Well Name, but whenever I have failure points, Spotfire line connection adds other lines. How can I get this to stop?

I am trying to make a box plot of data in Spotfire that tracks the median/distribution for the top 10 most active compounds discovered in a drug discover project to date. For example, imagine we had the following (abbreviated) data table: