get_results: A function to perform all queries and dump results into a...

In johnchower/flashreport: Calculations for Gloo's weekly flash report

Description

A function to perform all queries and dump results into a long data.frame.

Usage

get_results(date_ranges, query_types, user_group = integer(0),
  user_group_query = character(0), user_group_name = character(0))

Arguments

date_ranges	A data frame with columns range_types, max_dates where each row represents a date range.
query_types	A character vector describing the types of queries to run. Appropriate entries correspond to the names of S4 query type classes defined in R/query_functions.r (currently 'auQuery', 'paQuery', 'notificationsQuery' are the only valid options).
user_group	integer vector of user_ids to restrict results to. Cannot specify both user_group and user_group_query.
user_group_query	Character containing a SQL query that returns a table with a single column, user_id. Cannot specify both user_group and user_group_query.
user_group_name	Character, a name for the user group you're running the query on.

Value

A data frame with columns user_group (character), date_range (date ending), variable (character), value (numeric).

johnchower/flashreport documentation built on May 19, 2019, 3:03 p.m.