Release - November 15th, 2021

✨ New ✨

Site Style Updates

Details

Product Component

Metrics Catalog

More Detail

We've done a rebrand on colors and fonts and a few other aesthetic pieces, so you'll likely notice a makeover on our User Interface. In other words, "new look, same great product!"

Verification Steps Login to the product and notice the new look and feel.

Grain to Date for Cumulative Metrics

Details

Product Component

Metrics Framework

More Detail

You can optionally specify grain to date in your cumulative metric configuration to accumulate the metric from the start of a grain (i.e. week, year, month). When using a window, like a month, Transform will go back one calendar month, whereas grain to date will always start at the beginning of the grain regardless of the latest date of data.

In this example, we are calculating cumulative transaction revenue month to date using grain_to_date.

metric:  name: "revenue_mtd"  description: "revenue mtd"  owners:    - bobby@transformdata.io  type: cumulative  type_params:    measures:      - txn_revenue    grain_to_date: month

We support grain to date at the day, week, month, and quarter level.

Verification Steps

Update or create a new cumulative metric with grain_to_date configuration

View SQL Modal

Details

Product Component

Metrics Catalog

More Detail

For any metric chart, the ... menu's "View Query Logs" option has been replaced by a "View SQL" option. We made this change from feedback that users mostly use this menu to quickly access the SQL and don't need to see the full query logs. This new option opens a modal that shows the source SQL and generated SQL for the given metric. The "View Server Logs" button in the modal takes you to the same place the "View Query Logs" button did to view the full query logs.

Verification Steps

Open the menu at the top of any chart and confirm you can access the View SQL modal.

Total in Chart Tooltip

Details

Product Component

Metrics Catalog

More Detail

For additive metrics that can be summed to produce a total from a grouping, we added a "Total" at the top of the tooltip. The total will show the sum of values for metrics based on measures that use sum and sum_boolean aggregation types (e.g., additive typse)

Verification Steps

Select a "Group" in Edit Chart for a metric based on a measure that uses the sum or sum_boolean aggregation. Hover over the tooltip for any day and confirm a total is present in the tooltip.

New Legend

Details

Product Component

Metrics Catalog

More Detail

We have a new legend, which color codes and labels dimension groupings on the metric chart!

Verification Steps

Create a grouping and ensure you see a legend that specifies which color applies to which dimension values.

Questions editable/deletable by admins

Details

Product Component

Metrics Catalog

More Detail

Questions previously were only editable/deletable by question authors. We now allow admins to edit/delete/resolve replies on questions.

Verification Steps

Edit/Delete or take actions on questions that you did not author.

User and Team management page updates

Details

**Product Component**

Metrics Catalog

More Detail

We've made a few aesthetic and functional changes to the User Management and Team Management pages. Specifically,

User Management: we've updated controls for updating user roles and other actions

Team Management: We've consolidated the form for adding team members to any team, updated controls for both updating team roles and removing team members.

Verification Steps

Visit User Management and Team Management and notice new aesthetics and controls.

🐛 Bug Fixes 🐛

Date Selector Bug

Details

Product Component

Metrics Catalog

More Detail

There was a bug where any "x to date" selection in the date selector (e.g., month, year, quarter, week) would not return values even if values are present. This has been resolved.

Verification Steps

Use any preset selection with "x to date" for a metric that has values for the time period and ensure data is returned.

Client Side Exception Error

Details

Product Component

Metrics Catalog

More Detail

We fixed an intermittent error that reported there was a client side exception when interacting with Transform charts.

Verification Steps Confirm you no longer see occurrences of the "Application Error A client side exception has occurred"

JDBC Order By Error

Details

Product Component

Interfaces - JDBC

More Detail

Using ORDER BY in JDBC would incorrectly throw an error. This has been resolved

Verification Steps

Use ORDER BY in a query in the JDBC driver. For example:

SELECT * FROM MQL_QUERY(<messages by user__country, date ORDER BY date>);