ctsit / redcap_query_collection

A collection of SQL queries that shine light on your REDCap metadata
Other
2 stars 3 forks source link

Add a report the uses redcap_repo_data #4

Closed pbchase closed 4 years ago

pbchase commented 4 years ago

Please add an RMD that generates reports of the REDCap Repo data returned by get_redcap_repo_data.R

The first two reports should show the tables of data

# Published REDCap modules by institution
redcap_repo_data %>%
  select (-author, -author_email) %>%
  distinct() %>%
  count(institution) %>%
  arrange(desc(n))

# Last updated date for modules published by UF
redcap_repo_data %>%
  select (-author, -author_email) %>%
  distinct() %>%
  filter(institution == "University of Florida - CTSI") %>%
  arrange(desc(date_added))

At the same time revise get_redcap_repo_data.R so that the redcap_repo_data data frame is returned by a function. This should simplify reuse in other reports.

pbchase commented 4 years ago

address by PR #5