Time Series Aggregation
Time-series Aggregation
Artemis Sheets allows you to pull in time-series metrics into a single cell. Using one of these functions would sum the requested metric across a given time period and return a value in a single cell.
Supported time frames:
L7 - last 7 days
L30 - last 30 days
L90 - last 90 days
CM - current month (returns full calendar month for as-of-date)
CQ - current quarter (returns full calendar quarter for as-of-date)
LTM - last twelve months
YTD - year to date
Sample Syntax
Sample syntax #1: "=ART("ETH","L7_REVENUE")
The above formula would pull the sum of the past 7 days Revenue from DefiLlama.
Sample syntax #2: "=ART("ETH","LTM_TT_REVENUE")
The above formula would pull the sum of the past twelve-months Revenue from Token Terminal.
Note: pulling TokenTerminal data requires a valid API key generated from a TokenTerminal Pro account. This can be entered in Extensions -> Artemis Sheets in Google Sheets and the Ribbon / Taskpane in Excel.
Last updated
