Function quarterToDateSum
quarterToDateSum(
measure,name?):CalculatedMeasure
Creates a calculated measure that calculates the running total starting from the beginning of the quarter up to the current day, week, or month.
The time resolution is determined by the minimum date level of the date dimension in the query that uses the returned measure.
Parameters
| Parameter | Type | Description |
|---|---|---|
measure | Measure | Measure to apply the QTD Sum to |
name? | string | Name for the new measure |
Returns
A calculated measure instance
Example
Calculate the running total of total cost from the Sample Ecommerce data model, starting from the beginning of the quarter up to the current day, week, or month.
measureFactory.quarterToDateSum(measureFactory.sum(DM.Commerce.Cost))