I am plotting data from an MSSQL LIMS laboratory information management system. No problems there. This software is amazing.
However, I would like to use data link feature to show ALL analyses for a given sample. The time/date stamp is problematic for this, because it does not UNIQUELY identify a sample, because samples are logged in in batches so two or more have the same time/date but different project, project, and/or location.
Instead SampleID is the unique identifier but it contains both letters and numbers. E.g. 20200325A09 — is there a simple way I can query this without messing up plot? I figured out how to hide trends but alpha characters in query results still cause problems.