v0.11.0
TL;DR:
- Include requested fixes that have been made available in the GM Functions development Gsheet between May this year and today
Improvements:
- Added support for "zerofill" interpolation
- Added support for "4ilevels" geo set
- Added pagination to GM_INTERPOLATE and GM_UNPIVOT, allowing them to be used on larger datasets
- Add ability to import specific versions of data dependencies
- Fixed bug in GM_INTERPOLATE which included the header row when interpolating, resulting in lost Georgia results if the column header was "geo"
Updates based on changed structures:
- Synced ID validation with DDF requirements, allowing underscores
- Updated expected headers for open-numbers catalog + made the check less strict
- Updated expected columns for the data geographies sheet (which is the lookup sheet for GM_PROP)
Smaller fixes:
- Default sort by aggregation property name instead of aggregation property value
- Fixed various bugs related to spreadsheet validation:
- Sheets with the suffix "-column" not considered output sheets
- Check that indicator units does not start or end with a space
- Improved tests and docs
Install this version by following the instructions in the v0.11.0 Google Spreadsheet