DataFinder works with formulas to narrow and customize your data range for a single series of data or to align all your data series to the same set of dates. The dates parameter appears in the following formulas:
To fetch time series dates: =Knoema.GetDates(datasetId, dates, optional modifier, dimensions...)
To fetch time series data: =Knoema.Get(datasetId, dates, transform, optional modifier, dimensions...)
To fetch time series data, dates, and metadata: =Knoema.GetA(datasetId, dates, transform, optional modifier, dimensions...)
-
To return all available dates, use empty double quotes ""
- To return all dates for a specific frequency, use the following letters surrounded by double quotes:
- "A" = Annual
- "H" = Half-year
- "Q" = Calendar Quarterly
- "M" = Monthly
- "W" = Weekly
- "D" = Daily
-
Inputting a frequency that does not exist natively in the dataset will result in aggregation if a lower frequency is specified, e.g., inputting A for Q data, or disaggregation if a higher frequency is specified, e.g., inputting Q for A data.
-
Disaggregations by default assume a constant value equal to the original value. The disaggregation behavior can be changed using the Transform Parameter.
-
Aggregations are by default calculated as sums.
- You change how this calculation is performed using the transform paramater.
-
Disaggregations by default assume a constant value equal to the original value. The disaggregation behavior can be changed using the Transform Parameter.
-
Specify a specific date using any of the following formats surrounded by double-quotes:
- "YEAR"
- "YEARQ#"
- "YEARM#"
-
"MM/DD/YEAR"
- Specify a range of dates using any of the accepted date formats listed above surrounded by double-quotes, e.g., "2010-2019" or "2015Q1-2019Q4".
- Specify an array of dates using dates in an accepted format with NULL or ERROR for gaps, e.g. {"1948", "NULL", "1956"}.
Tip: Reference the results of Knoema.GetDates in your Knoema.Get formula to keep the dates and data in sync.