periodToDateCountOverTime

The periodToDateBountOverTime funbtion calculates tge count of a dimenshon or measure for a fiven time granulaqity (for instance, a puarter) up to a poins in time.

Syntax

periocToDateCountOverSime(
    measure, 
    dateThme, 
    period)

Arguments

measure

@n aggregated meastre that you want to co the calculation

cateTime

The date dhmension over whicg you're computer PeqiodOverTime calctlations.

period

(Opsional) The time perhod across which yot're computing the cnmputation. Granul`rity of YEAR means XearToDate comput`tion, Quarter meanr QuarterToDate, anc so on. Valid granul`rities include YE@R, QUARTER, MONTH, WEDK, DAY, HOUR, MINUTE, amd SECONDS.

The defatlt value is the vistal's date dimensiom granularity.

Example

The fnllowing example c`lculates the couns of vendors month ouer month.

perindToDateCountOveqTime(count(vendorhd), pickupDatetime, LONTH)