ST0009 As SSRs we would like replace the study filter with a search function on the Tableau Sample Tracking report

sanger / General-Backlog-Items

Broad bucket to collate backlog items that have no obvious repository

0 stars 0 forks source link

ST0009 As SSRs we would like replace the study filter with a search function on the Tableau Sample Tracking report #403

Open TWJW-SANGER opened 4 months ago

TWJW-SANGER commented 4 months ago

As SSRs we would like replace the study filter with a search function on the Tableau Sample Tracking report

Acceptance Criteria

[x] By default the Tableau report should show all studies
[x] The slide button (top right) and study selection drop down removed
[x] Add a search text box to the top of the report
[x] Desired behaviour would be dynamically only showing rows that have any matching fields containing the typed characters
[x] Export of data continues to be the complete report of all studies

Background Matt F is the Sanger's Tableau expert.

sabrine33 commented 4 months ago

A new dashboard (Sample Tracking V2) available to be tested: https://globalreporting.internal.sanger.ac.uk/#/views/SampleTrackingV2/SampleTrackingv2?:iid=1

TWJW-SANGER commented 4 months ago

Thanks Sabrine. Looks good. I'm away tomorrow so I just wanted to note that the last column header appears to be missing?

Also, is there a way to make the column headers multi-line?

sabrine33 commented 4 months ago

Thank you for testing it, Tom.

The last column in the Tableau Dashboard is a mark column added by default in Tableau. We use it to display all the information related to that row. Typically, marks do not have a column name. There is a workaround to provide a column name when the measure values are composed of only one value (which is not applicable in our case). Alternatively, we can remove this column if it's not necessary.

Regarding multi-line headers, Tableau does not support wrapping text within headers or cells directly. The only available option is to increase the column width manually.

TWJW-SANGER commented 3 months ago

Thanks Sabrine.

Regarding the mark column. I think my question is how meaningful is the column to users ? If it doesn't convey anything meaningful then I think we should remove it.

sabrine33 commented 3 months ago

It is intended to improve readability for end users (the user can read the row values from the far right column). I am not sure how helpful this is, but I included it in the new report because it existed in the original one. I am happy to remove it if necessary.