search

Science-for-Nature-and-People / Midwest-Agriculture-Synthesis

Synthesizing and visualizing the impact of conservation agriculture
6 stars 4 forks source link

filter reference list and display as table on reference tab #34

Open LesleyAtwood opened 5 years ago

LesleyAtwood commented 5 years ago

Use paper_id lists in summary table to filter reference list and display it on the reference tab.

When the user clicks back to the figure will it retain the selected filters?

nathanhwangbo commented 5 years ago

Just added this! The plot filters should be retained when you switch between tabs

swood-ecology commented 5 years ago

Awesome. A couple more issues here:

  1. I think the short_id column can be dropped from the table
  2. Can the DOI by a hyperlink?
  3. Can there be a column that shows which of the treatments and outcomes are present in each paper?
LesleyAtwood commented 5 years ago

Currently the reference list doesn't include treatment and outcome information, which may make #3 a little challenging.

If I were to update the reference list to include that information what would be the best way to do it? With the caveat that most papers have more than one response variable [outcome]. Use a many-to-one approach so we filter specific rows? This could create redundancies if the user views more than one outcome at a time

swood-ecology commented 5 years ago

I don't think you would have to change how the filtering is done. I'd just suggest having a column that has comma-separated practices and another that has comma-separated outcomes that get visualized.

LesleyAtwood commented 5 years ago

The reference list is currently filtered by Paper_Id only.

With a comma-separated list of practices and outcomes, the end result would be list of practices and outcomes included in each paper. I like the idea of this, but it may be overwhelming to have an exhaustive list of all the outcomes for each paper. Plus it won't be as easy to filter/organize the output so it logically matches the figure. Separate columns would be needed for that.

swood-ecology commented 5 years ago

How would you approach it?

LesleyAtwood commented 5 years ago

Here's a possible solution:

We convert the reference table to widget table using renderDataTable({df()}). This widget includes clickable sorting features and a search box.

Then we can use some feature (detect_stri, arrange ??) to reorder the comma-delimited list of outcomes so the most relevant outcome(s) are displayed first. This should make it easier to sort.