cohort

< Back to Reference | View source

cohort()

Cohort Analysis

Usage

cohort(.data, .date, .value, time_unit = "month", period_label = FALSE)

Arguments

Argument	Description
.data	tibble or dbi object
.date	date column
.value	id column
time_unit	do you want summarize the date column to ‘day’, ‘week’, ‘month’,‘quarter’ or ‘year’
period_label	do you want period labels or the dates c(TRUE , FALSE)

Value

segment object

Description

Database-friendly cohort analysis function. A remake of https://github.com/PeerChristensen/cohorts, combining cohort_table_month, cohort_table_year, and cohort_table_day into a single package. Rewritten for database compatibility and tested with Snowflake and DuckDB.

Details

• Groups your .value column by shared time attributes from the .date column.

• Assigns each member to a cohort based on their first entry in .date.

• Aggregates the cohort by the time_unit argument (day, week, month, quarter, or year).

• Computes the distinct count of each cohort member over time.