search

sanger / sample-tracking

Sample Tracking Report
0 stars 0 forks source link

ST0016 As a user I would like the Tableau report to include a new column "manifest_created" #13

Open sabrine33 opened 5 months ago

sabrine33 commented 5 months ago

The column should refer to the earliest date the manifest was created (sample_manifest.created event)

sabrine33 commented 5 months ago

@TWJW-SANGER While performing some sanity checks on the created manifest, I noticed a lot of rows with manifestcreated = null, which do not make sense. The current join between tables is done using the barcode (flat_events_view.subject_friendly_name = sample_flowcell_view.labware_humanbarcode). Additionally, I observed that in the flat_events_view, there are about 29,173 rows with role_type='labware', whereas in the report view, we have about 34,062 distinct plate barcodes. is there any valid explanation for this?