View source: R/code_sql_group_by.R
code_sql_group_by | R Documentation |
SQL Code to get aggregated statistics for groups
code_sql_group_by(
sql,
aggregator.cols,
group.by.cols,
include.all.possible.combos = FALSE
)
sql |
SQL which selects records |
aggregator.cols |
the aggregation rules to apply for each measure (ie: count(*) AS N) |
group.by.cols |
the columns that you wish to group by |
include.all.possible.combos |
when TRUE does group by statements for every possible combo and then uses UNION to put them all together. |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.