Aggregate Time Series
Aggregate Time Series to M end, Q end, HY end (Jun/Dec or Mar/Sep), and Y end (Mar/Jun/Sep/Dec).
Input Parameters/Data
To: Aggregate to Weekly, Monthly, Quarterly, Half Yearly or Yearly.
By: Aggregate by Sum, Average, Median, Minimum, Maximum, Range, First or Last.
Half Year End: Could be Mar/Sep or Jun/Dec.
Full Year End: Could be Mar, Jun, Sep or Dec.
Data Input: Row(s) and column(s) of data.
Notes
Unused rows are hidden (from bottom). Rows without dates are ignored.
Unused columns are hidden (from right). Columns without labels are ignored.
Output
Data: Output of the aggregated time series.
View demo here
Learn the basics in 5 minutes with our Quick Start Guide. To make the most of Fontics, check out our Tips & Tricks.