ytd: Current period year-to-date

In alejandrohagan/fpaR: Common Business Intelligence Functions for F&PA work

Current period year-to-date

Description

• For each group, ytd() will create the running annual sum of a value based on the calendar type specified

• The function returns a ti object which prints out the summary of steps and actions that will take to create the calendar table and calculations

• Use calculate to return the results

Usage

ytd(.data, .date, .value, calendar_type)

Arguments

.data	tibble or dbi object (either grouped or ungrouped)
.date	the date column to group by
.value	the value column to summarize
calendar_type	select either 'standard' or '5-5-4' calendar, see 'Details' for additional information

Details

• This function creates a complete calendar object that fills in any missing days, weeks, months, quarters, or years

• If you provide a grouped object with dplyr::group_by(), it will generate a complete calendar for each group

• The function creates a ti object, which pre-processes the data and arguments for further downstream functions

standard calendar

• The standard calendar splits the year into 12 months (with 28–31 days each) and uses a 7-day week

• It automatically accounts for leap years every four years to match the Gregorian calendar

5-5-4 calendar

• The 5-5-4 calendar divides the fiscal year into 52 weeks (occasionally 53), organizing each quarter into two 5-week periods and one 4-week period.

• This system is commonly used in retail and financial reporting

Value

ti object

See Also

Other time_intelligence: atd(), dod(), mom(), momtd(), mtd(), mtdopm(), pmtd(), pqtd(), pwtd(), pytd(), qoq(), qoqtd(), qtd(), qtdopq(), wow(), wowtd(), wtd(), wtdopw(), yoy(), yoytd(), ytdopy()

Examples

ytd(sales,.date=order_date,.value=quantity,calendar_type="standard")

alejandrohagan/fpaR documentation built on April 12, 2025, 9:51 a.m.