Release - July 25th, 2021

✨ New ✨

Charting Enhancements: Date Range, Granularity, Time Comparison

Details

Product Component

Metrics Catalog

More Detail

We're excited to announce three new charting features!

1. Date Range Selector: You can now toggle the date range of the chart (default 365 days) to presets or a custom range.
2. Granularity: You can now control the granularity of the X-axis through our new granularity menu. You can choose monthly, weekly, yearly in case you want to aggregate your data to different time levels. (Note that this granularity is currently independent of our framework granularity, which currently supports day)
3. Time Comparison: You can now calculate a Growth Rate between certain time periods. This uses a standard percent change calculation.

Verification Steps

Date Range

Navigate to Edit Chart on a metric page, find the "Date Range" menu, and TADA! (Also conveniently an anagram of data). Switch between Presets and Customs to find the desired range.

Granularity

Navigate to Edit Chart on the metric page and find granularity:

Change the granularity of the x-axis, which aggregates all values over a time period based on the aggregation of the measures.

Supported options: Daily, Weekly, Monthly, Yearly

Time Comparison

Ever wondered how your metrics compare to last week, last year, or last month? Us too! This is why we've introduced the ability to do growth rate calculations across various time ranges between metrics in a current and previous period.

Navigate to Edit Chart and find the Time Comparison menu. You can do Year over Year, Month over Month, Week over Week (assumes Sunday start), and Quarter over Quarter.

Also, the growth rate calculation is:

[((Values in Current Time Period) - (Values in Previous Time Period))/ Values in previous time period] * 100

Create Metric from measure from different data sources

Details

Product Component

Metrics Framework

More Detail

You can now create a metric from measures from two data sources with different primary identifiers. This mostly applies to ratio metrics. Previously, to create a ratio type metric, both of your measures (numerator and denominator) had to come from the same data sources

Verification Steps

Create two data sources with a given measure and a metric based on them

Example: Measures Data Source 1

measures: - name: forecast_value    description: forecast value    expr: 1    agg: sum

Example: Measures Data Source 2

measures: - name: actual_value    description: forecast value    expr: 1    agg: sum

Metric

metric: - name: forecast_versus_actual  description: Forecast versus actual value  owners:    - forecast@transformdata.io  display_name: Forecast over Actual  type: ratio  type_params:    numerator: forecast_value        denominator: actual_value  tier: 2

Materialization Fast Cache

Details

Product Component

Metrics Framework

More Details

The materialization fast cache is a release candidate feature, and provides the ability to store your materialized data (from Materializations) in a DB-based cache (e.g., MySQL) for faster access. Materializations by default store data in your data warehouse, and the latency can be many seconds. This feature is most useful for organizations that need low latency access to metrics.

Verification Steps

Reach out to Transform to learn more about the materialization fast cache.

Improved Ratio Metric Lineage

Details

Product Component

Metrics Catalog

More Detail

The lineage dropdown for ratio metrics on the metric page would only show the final metric, not the derivations. We want to make sure you can see all the lineage regardless of metric type, so we added the data sources and measure that the ratio type metric is based on.

Verification Steps

Navigate to Lineage on the metric page for your ratio metric. Confirm that a ratio metric shows the measures & data sources that the metric is derived from. You may notice that the hierarchy is no longer a singular layer, rather multiple layers to show more than a single data source.

🐛 Bug Fixes 🐛

Lifted Annotation Character Limit

Details

Product Component

Metrics Catalog

More Detail

Our annotation character limit was previously 500 characters. We don't want to limit your descriptions for your important annotations so we removed this limit.

Verification Steps

Create a 500+ character annotation.

Metric Link URL

Details

Product Component

Metrics Catalog

More Detail

This was a transient bug that would sometimes lead to metric page links from various parts of our UI erroneously leading to a 404 error.

Verification Steps

This is difficult to verify given its unpredictability. However, please let us know if you see 404 errors when navigating to metrics that exist.