HistogramRule: HistogramRule Object

In lantanacamara/googleSheetsR: R package for connecting Google Sheets API

Description

HistogramRule Object

Usage

HistogramRule(interval = NULL, start = NULL, end = NULL)

Arguments

interval	The size of the buckets that are created
start	The minimum value at which items are placed into buckets
end	The maximum value at which items are placed into buckets

Details

Autogenerated via gar_create_api_objects Allows you to organize the numeric values in a source data column intobuckets of a constant size. All values from HistogramRule.start toHistogramRule.end are placed into groups of sizeHistogramRule.interval. In addition, all values belowHistogramRule.start are placed in one group, and all values aboveHistogramRule.end are placed in another. OnlyHistogramRule.interval is required, though if HistogramRule.startand HistogramRule.end are both provided, HistogramRule.start mustbe less than HistogramRule.end. For example, a pivot table showingaverage purchase amount by age that has 50+ rows: +—–+——————-+ | Age | AVERAGE of Amount | +—–+——————-+ | 16 | $27.13 | | 17 | $5.24 | | 18 | $20.15 | ... +—–+——————-+could be turned into a pivot table that looks like the one below byapplying a histogram group rule with a HistogramRule.start of 25,an HistogramRule.interval of 20, and an HistogramRule.endof 65. +————-+——————-+ | Grouped Age | AVERAGE of Amount | +————-+——————-+ | < 25 | $19.34 | | 25-45 | $31.43 | | 45-65 | $35.87 | | > 65 | $27.55 | +————-+——————-+ | Grand Total | $29.12 | +————-+——————-+

Value

HistogramRule object

lantanacamara/googleSheetsR documentation built on May 3, 2019, 11:52 p.m.