Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Open
sabrine33 opened this issue Jun 12, 2024 · 1 comment
Open

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

sabrine33 opened this issue Jun 12, 2024 · 1 comment
Labels
enhancement New feature or request

Comments

@sabrine33
Copy link
Contributor

sabrine33 commented Jun 12, 2024 •
edited
Loading

The column should refer to the earliest date the manifest was created (sample_manifest.created event)
@sabrine33 sabrine33 added the enhancement New feature or request label Jun 12, 2024
@sabrine33 sabrine33 changed the title Add new column to the Report "manifest_created" ST0016 Add new column to the Report "manifest_created" Jun 12, 2024
@sabrine33 sabrine33 changed the title ST0016 Add new column to the Report "manifest_created" ST0016 As a user I would like the Tableau report include a new column "manifest_created" Jun 12, 2024
@sabrine33 sabrine33 changed the title ST0016 As a user I would like the Tableau report include a new column "manifest_created" ST0016 As a user I would like the Tableau report to include a new column "manifest_created" Jun 12, 2024
@sabrine33
Copy link
Contributor Author

sabrine33 commented Jun 19, 2024 •
edited
Loading

@TWJW-SANGER
While performing some sanity checks on the created manifest, I noticed a lot of rows with manifest_created = 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_human_barcode).
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?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
enhancement New feature or request
Projects
Sample Tracking Report
Status: Done
Milestone
No milestone
Development

No branches or pull requests
1 participant
@sabrine33