ICEBOX - User needs UI to see LOESS and Linear graphs to review team performance in tt reports

[jamesmrollins]

References

• 2445 Team PSD 3.0 - 9 Data Feeds

• 2348 User needs more accurate time reporting of Sim UI events.

• Power BI Story 13

Situation

• [x] @dkngenda has developed an Rnotebook in lzim/research that has an example of the charts.
• [ ] There is a Team PSD 3.0 - Data feeds that portrays the charts in the Data UI.

Question

• [x] Convene @dkngenda @jamesmrollins @jeffhoerle @lzim @lijenn @mnallajerla and discuss
• [ ] Do we fold in the LOESS and Linear graphs into the Data UI or the Sim UI or Both?

[jamesmrollins]

Sim UI 3/2

• The reports are for the tt 3 report (not Data UI).
• Need to take the R code that produce the graphs and put them in the tt's.
• Outlined in the 3.0 data feeds (separate david PowerBI build) in the #2445 thread.
• The current data feeds do not narrow the data set to the clinic level. There is a prototype, but not ready for prime time.
• Still some questions remain on how we keep the R notebooks updated.
• @jamesmrollins will reach out to @dkngenda to discuss.
  • As per @lzim: Right now - David's code Linear/Loess EBP Trends in Team PSD 3.0 Power BI dashboard. Only narrows to sta6a or "clinic" (e.g., Menlo Park) broader level NOT the way the team defined themselves in the Clinic Selection of the Data UI. Next Step for Research Workflow AND dependency w/#2507
• Talk w/ @jeffhoerle about whether there are any smart workflows to bring the Clinic Selection Export to the PTSD_OMHO (operations & tt3) & ORD workgroups (research) that produce the Linear/Loess graphs.
• We did some preliminary testing w/NIH sites and we did a DART amendment to request the location SID table necessary for measuring our Specific Aims using the team's Clinic Selections.

[jamesmrollins]

As per conversation 3/7 with @dkngenda:

1. @dkngenda has an R notebook that queries the PTSD Research Database and pulls necessary data into Power BI for the LOESS and Linear plots. R code embedded in Power BI uses the ggplot2 function to crunch the numbers and display them on the map and graphs.
2. @jamesmrollins will consult with @hirenp-waferwire to determine how to emulate the same functionality as the ggplot2 object in R code.
3. @jeffhoerle may need to design another tab to use @dkngenda 's query against Lindsey's operational database. The tab would provide an export based on the team's drill down and report via an .xlsx.
4. The team member or facilitator then would upload the file for processing and availability in the tt3 report.
5. The R script shown below is executing on CDW data pulled using PowerBI.

Screenshot of ggplot2 - Geoplot, LOESS and Linear plot

R code executing ggplot2 instructions.

[jamesmrollins]

Hi @hirenp-waferwire. Please take a look at the ggplot discussion above. We will need the ability to receive data and plot data accordingly. Is there a java, JSON or R Code emulator that could support the ggplot2 functionality? Let me know if you want to discuss. Meanwhile, I will work with @jeffhoerle to determine how we might move the data across the platforms.

[jamesmrollins]

As per SWG 3/9

• Since research is a primary need, we would need to add the clinic SID Location Numerics table to the research R Code notebooks.
• Need to show plots by the team's actual clinic selection.
• @jeffhoerle will develop a "LocationSID Export" tab.
• The simplest thing we need is a PDF file of this plot at Session 12.
• Need to make this accessible to end user, via the tt3 report.
• Take a look of how to import the PDF chart as a graphic file.

[jeffhoerle]

"LocationSID Export" tab has been implemented and is now published to PROD.

[jamesmrollins]

As per 9/14 Sim UI Workflow mtg:

1. We will move this feature to the October Epic for prioritization.
2. Will need to potentially integrate with efforts of @KimCase123, Emily2 and @dkngenda, who are working up reports for supporting research aims 1a and 1b, as we share a dependency to share the results of clinics by location who are seeking results.
3. James will seek opportunities to use the same efforts to feed information to the sim ui.

FYI: @emilymetcalf114