The 2022 Coalesce Pre-Release

Breaking Changes

• Updating the package to reflect the changes in the v1.3 metric spec.
  • type --> calculation_method
  • sql --> expression
  • type: expression --> calculation_method: derived
• Updating the required_dbt_version to be v1.3

New Features

• Adding functionality to return a single value for a metric by using all_time in the time_grains by @callum-mcdata in #99
• Adding a new metric_list input to secondary calculations to allow for flexibility in which metric the secondary calculation is being applied to. By @callum-mcdata in #116
• Making develop have feature parity with calculate! You can now query any metrics defined in the provided yml, even if they are derived metrics. By @callum-mcdata in #118
• Allow users to override the default method for handling null values. Default behavior replaces null values with 0 - now there is a config to keep as null. Shout out to @dave-connors-3 taking on a bear of a PR . #96
• Adding the ability to define a window in the metric definition and have that be applied in the calculation. More information in the readme. By @callum-mcdata in #104

Quality of Life Changes

• The 👑 @dave-connors-3 cleaning up the whitespace in the compiled query so it can actually be read by humans! #94
• Restructuring the metrics in the package for code consistency and to remove branching paths based on different behaviors/inputs. #90
• Adding default ordering to the final returned dataset where the most recent metric value is first! #119
• Updating packages.yml by @callum-mcdata in #122

Bug Fixes

• Fixing the calendar table by @callum-mcdata in #98
• Hotfix: All_time with dimensions broken by @callum-mcdata in #108

Full Changelog: 0.3.2...1.3.0

0.3.6 - Limiting dbt-core versions

What's Changed

• This version is the final in the 0.3 series and limits the accepted dbt-core version to [">=1.2.0", "<1.3.0"]

PRs

• Fixing the required dbt version for the 0.3 series by @callum-mcdata in #128

Full Changelog: 0.3.5...0.3.6

0.3.5 - Adding Order By and Fixing Base Model Bug

What's Changed

• Adding Order By and Fixing Case When by @callum-mcdata in #123

Full Changelog: 0.3.4...0.3.5

0.3.4 - Adding `metric_list` to secondary calculations!

What's Changed

• Secondary Calcs - Lets Limit These Inputs by @callum-mcdata in #115

Full Changelog: 0.3.3...0.3.4

0.3.3 - Hotfixing Date Bug

What's Changed

• Hotfix for 0.3.2 by @callum-mcdata in #113

Full Changelog: 0.3.2...0.3.3

Deploy Macro, Removing Introspection, & Calendar Extension

Lets Celebrate Our New Contributors!!

• @leoebfolsom made their first contribution in #73
• @longtomjr made their first contribution in #77
• @dave-connors-3 made their first contribution in #80

What's Changed

• update link in readme to include sql_gen subdir by @leoebfolsom in #73
• docs: update 'where' in readme example by @longtomjr in #77
• Ensuring Numeric Output Data Tests by @callum-mcdata in #78
• update string parsing to accomodate double quotes by @dave-connors-3 in #80
• Removing dbt_utils Type Float dependency by @callum-mcdata in #84
• Removing model introspection and adding allow_calendar_dimensions by @callum-mcdata in #86
• Adding the develop macro by @callum-mcdata in #82

Full Changelog: 0.3.1...0.3.2

0.3.1 - Hotfixes and Implementing CI

What's Changed

• Adding Pytest Tests by @callum-mcdata in #65
• Cleaning Up Issues and PRs by @callum-mcdata in #70
• Adding same period and grain test by @callum-mcdata in #71
• Hotfixing Where Clause by @callum-mcdata in #69

Full Changelog: 0.3.0...0.3.1

0.3.0 - Expression Metrics & Refactoring

What's Changed

• Adding Multiple Metric Support & Recursive Logic by @callum-mcdata in #40
• Renaming To Calculate by @callum-mcdata in #46
• Updating Tree Logic by @callum-mcdata in #51
• Grain Validation by @callum-mcdata in #52
• Overhauling Common Dimension List by @callum-mcdata in #53
• V0.3.0 - Metric Function & Overhaul by @callum-mcdata in #37
• Hotfixing Prerelease Bugs by @callum-mcdata in #55
• Fixing Division By Zero and Allowing Expression Secondary Calculations by @callum-mcdata in #57

Full Changelog: 0.2.0...0.3.0

0.2.0

Description

BREAKING CHANGE - The custom_calendar variable now takes the name of the model, not the ref function that it previously had. For more information, please reference the README.

What's Changed

• Removing Cartesian Join by @callum-mcdata in #31
• Adding Where and Data Tests by @callum-mcdata in #34
• Altering Forced Dependency - Breaking Change on Custom Calendar by @callum-mcdata in #32

New Contributors

• @callum-mcdata made their first contribution in #31

Full Changelog: 0.1.5...0.2.0

0.1.5

What's Changed

• start_date and end_date casting fix by @fivetran-joemarkiewicz in #22
• Add more integration tests in #23

New Contributors

• @fivetran-joemarkiewicz made their first contribution in #22

Full Changelog: 0.1.4...0.1.5