Aggregate all declining values Calculation based on a condition Counting days when market is closed Do calculation when series fall below its average Number of series which have risen Counting time Count(), Count valid, Counter() Count days Count days between Fed Funds Rate hikes/cuts and cuts/hikes Countdown till 0 How far from a point? How … Continue reading “All about counting observations”
Overview Settings Period Percentage Rolling Examples Questions How do I calculate a rolling sum? How to keep series as is and start aggregating it from certain point in time? Overview Example of general use of Aggregate analysis comparing aggregated values by each year annually and starting 3 year from the end of series: The Aggregate … Continue reading “Aggregate”
There are two main possibilities to aggregate series: 1. Aggregate analysis Specify the period over which you want to aggregate the series. You also have the option of making this a rolling sum. 2. Formulas AggregateSum(series) Sums up all values from the start of the series. AggregateSumAnnual(series) Sums up values of a series on a … Continue reading “How to aggregate a series?”