Skip to main content

· 3 min read

✨ New ✨

Transform Connector for Sheets Updates

Details

We’ve made a few updates to Google Sheets connector!

1) We now have the concept of Saved Queries in Google Sheets. This allows users to save queries they issue with the custom menu, edit them, and refresh on load of the connector. Note currently Saved Queries in the Transform App are independent from Saved Queries in Google Sheets.

2) We’ve added the ability to retrieve the custom function command from the custom menu selections.

3) Instead of users needing to select granularity before Time over Time, we default to the most granular option available for the metric (for most most metrics this is daily).

4) We now automatically select metric time when users make selections.

5) When adding WHERE constraints, we now automatically format the input to fit with accepted parameters.

6) We added validation into the limit field so we now do not allow you to input text in the limit field.

Read more documentation about these features here.

Constraints on input measures for a metric

Details

Users can now define constraints on input measures for a metric. For example, to define a ratio metric for fraction of frequent purchasers, in the past you’d have to define a separate measure using a custom expr like SUM(IF(…)), or possibly even split one measure into a separate data source with a data source level constraint. Now, users may choose to apply the constraint directly to the measure, like so:

  metric:
name: frequent_purchaser_ratio
description: Fraction of active users who qualify as frequent purchasers
owners:
- support@transformdata.io
type: ratio
locked_metadata:
value_format: ".2%"
type_params:
numerator:
name: distinct_purchasers
constraint: is_frequent_purchaser
alias: frequent_purchasers
denominator:
name: distinct_purchasers

Note the new constraint and alias parameters for the measure referenced in the numerator. The constraint parameter defines the constraint the user wishes to apply. That constraint filter will be applied to the measure it is attached to, and no others.

The alias parameter is only necessary if the same measure is used more than once in the metric but with different constraints, as shown above. This is necessary to avoid column name collisions in the rendered SQL queries. If all input measures are already distinct, the alias parameter may be omitted.

This may be used with any metric type. In expr type metrics the expr should always refer to the alias, if it is set, as below:

 metric:
name: purchase_rate_90
description: Fraction of purchases with < 90 pct chance of being returned
owners:
- support@transformdata.io
type: expr
locked_metadata:
value_format: ".2%"
type_params:
expr: "(total_purchases - predicted_returns_90_pct) / NULLIF(total_purchases, 0)"
measures:
- name: total_purchases
- name: predicted_returned_items
constraint: prediction_score > 0.9
alias: predicted_returns_90_pct # alias not required, but you may always include one for clarity

🐛 Bug Fixes 🐛

Null and non-string dimension value filter bug

Details

We fixed a bug where you could not filter on any non-string dimension values when querying a metric. This includes null, booleans like true, false, and any undefined fields like nan.

Update query metadata without making a change

Details

We fixed a bug where Saved Query creators couldn’t make changes to the metadata of the query (name, description, etc) unless they made a change to the query parameters themselves.

· 2 min read

✨ New ✨

Table View

Details

We're excited to announce table view as a chart type in Transform. You can toggle to the table view using the menu at the top-right hand corner of every chart in Transform.

The table feature includes the ability to order the data in the columns in your view, autofit the columns, and copy data out (using keyboard shortcuts) into spreadsheeets.

P.S - we're even more excited about this because introducing table view sets the foundation for us to allow users to query things that cannot be plotted - like multiple dimensions and metrics at once. Stay tuned for these updates!

Boards Beta (v2.1)

Details

We're excited to release v2.1 of Boards!

This release includes:

  • The ability to set a board as a "Favorite" using the star icon on the Board page next to the Board name.
  • The Boards landing page now includes a few more sections to help you find Boards you’re looking for: (1) Favorites, (2) Boards you’ve recently viewed, and (3) Popular Boards in your organization.
  • All saved query charts on Boards now have an "Explore in Query" button which takes you to the Query page with the parameters of the query you were looking at on the Board. So, if you’ve applied global filters on your Board, those filters will get carried over to the Query page.

🐛 Bug Fixes 🐛

Server Log Results Tab

Details

We resolved an error where results tab on the MQL server log page wasn't rendering properly.

Metric Page Custom Time Range Error

Details

We resolved an error where changing the time range to a custom selection would not let you update the chart after selecting.

· 2 min read

✨ New ✨

Boards Beta (v0.4)

Details

More Detail

We're excited to announce v0.4 of Boards! This release includes a global filter bar at the top of each Board page. The filter bar allows you to:

  • Filter by a date range
  • Filter by any dimensions and values shared across the metrics and saved queries on the Board
  • Reset all of your filters

Any filter you create will get applied to all of the charts on the Board.

Note: Filters will persist if you refresh the Board page but will get reset if you navigate to another page and come back to the Board page. If you want to share a view of the Board with your filters applied, you can click the clipboard icon to the right of "Edit Dashboard" and share that link with others.

For more information, see the documentation here: https://docs.transform.co/docs/transform-app/boards/boards-filter

Share of Bar Charts, Area Charts, and Single Value Charts

Details

More Detail

We've released more new chart types! This includes Share of Bar Charts, Regular and Share of Area Charts, and Single Value Charts.

Find the chart toggle on the top right hand corner of every chart.

MetricFlow VS Code Extension

Details

More Detail

We've released our first version of the MetricFlow VS Code extension. This extension provides basic schema checking when editing MetricFlow YAML files.

Install the extension and learn more about it on the VS Code marketplace page here: https://marketplace.visualstudio.com/items?itemName=Transform.metricflow&ssr=false#overview

Dev Mode

Details

More Detail

Our new Dev Mode feature lets you view a development model in the Transform application, allowing you to see changes to your metrics, Boards, and saved queries before promoting them to production.

For more information, see the documentation here: https://docs.transform.co/docs/metricflow/guides/dev-workflow#testing-with-the-transform-app

· 2 min read

✨ New ✨

Bar Charts and New chart toggle

Details

More Detail

We've releeased the first wave of our new chart types - bar charts! This includes a regular bar chart for a single time series as well as grouped and stacked for dimension groupings. This also includes a new chart toggle on top of every chart widget in the Transform app where you can switch between desired chart types.

Find the chart toggle on the top right hand corner of every chart.

Google Authentication

Details

More Detail

You can now use Google to sign in with Transform! Use the "Sign in with Google" button on the login page.

Similar to Transform's user/password authentication, users signing in with Google must have an active Transform organization that accepts the email domain you are signing up with, or you must be explicitly invited by another member.

Note: If you initially sign in with user/password and then switch to signing in with Google, you must login with Google for all future logins.

Data Source Inference Beta

Details

More Detail

We have added data source inference as a Beta feature. It allows new users to quickly get started with Metricflow by bootstrapping their data source configurations from a warehouse connection. Currently, only Snowflake is supported, but stay tuned for future updates!

Please note that this is still Beta feature. As such, it should not be expected to be free of bugs, and its CLI/Python interfaces might change without prior notice.

Learn more about data source inference through the documentation.

· One min read

✨ New ✨

Query Beta (v0.2)

Details

More Detail

We're excited to announce v0.2 of Query! You now have the ability to save a query you've created to a Board. This release also allows you to make a query personal or published, so you don't need to worry about testing queries out/exposing them across your organization when they aren't ready to be viewed yet.

Boards Beta (v0.2)

Details

More Detail

We're excited to announce v0.2 of Boards! You now have the ability to add both metrics and saved queries to your Board. You can add saved queries to your Board directly from the drag-and-drop sidebar on the Board page or you can add a query to your Board from the Query page.

· 2 min read

✨ New ✨

Metric Time

Details

**More Detail**

We're excited to be introducing the ability to assign non-primary time dimensions to measures in MetricFlow, preventing duplicate data source configs. If you want the measure to use a time dimension other than the primary time dimension, you will be able to specify an agg_time_dimension. The agg_time_dimension can be any time dimension defined in the dimension section.

  measures:
- name: users_deleted
expr: 1
agg: sum
agg_time_dimension: deleted_at

This change will also remove the requirement to consistently name the primary time dimension across your model. However, there will still need to be a primary time dimension defined in a data source with measures.

In order to minimize breaking changes in the API and CLI, the engineering team built in a fix that will resolve your existing primary time to metric_time, so you will observe the output change when making a query, so all existing queries and materializations will continue to work.

Trim Data Toggle Updates

Details

More Detail

We updated our "Trim" data toggle to be more clear. It is now an ON/OFF toggle that indicates whether trimming is on or off. When the toggle is on, data is trimmed for incomplete time periods. When the toggle is OFF, all data is returned. Visit the Query page or Metric Page under Granularity to see the new toggle.

🐛 Bug Fixes 🐛:

Annotation Creation on Chart

Details

More Detail

The ability to click on a chart to create an annotation could cause accidental actions to create annotatoins. We updated this functionality so that annotations can now only be created when a user clicks + drags together. Visit any chart module to confirm.

· 6 min read

✨ New ✨

Query Beta (v0.1)

Details

More Detail

We’re excited to announce the v0.1 Beta release of Query which allows you to flexibly and safely build queries in the Transform application. You can start from scratch or jump off from an existing query to build your own.

This first version of the beta is mostly foundational (give or take a few features), and sets the stage for this powerful new page. It currently matches parity to the functionality you can perform on the metric page, which includes slicing and dicing a single metric in various ways. You’ll also notice that our chart widgets are new, and you now have the ability to create an annotation with a drag and drop (this applies to charts application-wide).

Stay tuned for updates to this page in the coming weeks, which include:

  • More chart types - get ready for bar charts, area charts, tables, and single value charts!
  • The ability to query multiple metrics at once
  • The ability to add your queries to Boards

One thing to note:

  • You can now only create Saved Queries on this new beta page, so you can no longer create them on the metric page. You will still be able to access all your saved queries on the metric page which can be found in a new section under the metric chart.

To Access Query: Click the Query icon page on the left navigation in the Transform application to visit this page, You can also access it through the metric page via the “Build Queries” button, or under the Saved Queries section on the metric page.

Boards Beta (v0.1)

Details

More Detail

We’re excited to announce the v0.1 Beta release of Boards which is now live in the Transform application. Boards allow you to watch and manage collections of metrics you care about for yourself, your team, and your company. This first beta release achieves parity with our previous Collections page and sets the stage for a revamp of the entire experience so you can easily create and maintain dashboards in a way that is safer and more approachable for everyone in your company.

Keep an eye out for even more functionality in the coming weeks, including:

  • The ability to add saved queries to your Boards
  • More chart types for the metrics and saved queries on your Boards (e.g. bar charts, area charts, single value charts, and tables)
  • The ability to apply global filters to all of the metrics and saved queries on your Board

One update to note:

With this release of Boards, you might also notice that the Teams button is no longer on the left navigation of the Transform application. We want to take more time to build a better experience for Teams, and identity more broadly in Transform. In the meantime, you will still be able to create teams and access your existing team pages. However, we have removed the Team Collections and Team Queries tabs on team pages, so you will only see team metrics. To access Teams:

  • Click the settings icon on the left navigation
  • Click “Manage Teams” under the Team Settings section

To Access Boards: Click the Boards icon on the left navigation of the Transform application.

Start & End Times in CLI

Details

More Detail

On the CLI, we can now pass time-constraint with --start-time and --end-time to the query.

Similarly, on the python interface, we can pass start_time and end_time to the query.

Verification Steps

Verify that the time constraints on the query results are correct when passing --start-time and --end-time to the query.

New Notification Settings Page

Details

More Detail

This updates the Notification Settings Page to allow for bulk updates. Previously all settings were on a per-metric basis, but this didn’t make sense for more general notifications — and it prevented folks from, e.g. subscribing to or unsubscribing from all “new annotation” notifications at once.

The new page breaks things into four logical categories:

  1. “Methods” — the ability to subscribe to or unsubscribe from notifications on a per-channel basis (currently “in app” and “email”).
  2. “General” — the ability to subscribe to or unsubscribe from “subscribed to metric,” question, and reply notifications on a per-channel basis.
  3. “Subscription Content” — the ability to subscribe to or unsubscribe from annotation & new subscriber notifications on a per-channel basis, either in bulk or for any specific metric.
  4. “Alerts” — the ability to subscribe to or unsubscribe from metric-specific alerts on a per-channel basis, in bulk, for any specific metric, or any specific metric alert.

Reuse Model in CLI if config-dir Directory Unchanged

Details

More Detail

Before, when resolving the model key when passing --config-dir we would always re-run commit-configs on the passed directory.

Now, we stash the model id when we commit a local model, and then check when we pass config-dir if we’re using the same directory and that the directory hasn’t been changed. If it hasn’t be changed, we re-use the stashed model id instead of commiting the model again.

This should substantially speed-up sequential commands using the --config-dir option

✔ 🌱 Successfully parsed local configs
✔ Query initialized: 1656095076961_0000023
✔ Success 🦄 - query completed after 10.25 seconds
[results]
1d1h ◒
▶ mql query --metrics wau_rolling_7 --dimensions ds --config-dir .
Using local model id 54985, created 20 seconds ago
✔ Query initialized: 1656095076961_0000023
✔ Success 🦄 - query completed after 0.50 seconds
[results]

Verification Steps

  1. Query with --config-dir , confirm new model created
  2. Query again with --config-dir , confirm that model is reused
  3. Change any yaml file in config-dir
  4. Query again with --config-dir , confirm new model created

Only Check CLI Updates After 24 Hours Since Last Check

Details

More Detail

Before, we checked for an update on every CLI run. If one existed, we would surface it to the user with a prompt to upgrade.

Now, we stash the timestamp when we check for an update. When we run a CLI command, we check the timestamp before checking for an update and only do so if 24 hours have passed.

· 2 min read

✨ New ✨

Google Sheets UX Improvements

Details

More Detail

We’ve added a number of usability improvements to the Transform Connector for Sheets.

  • We now use metric display names in the metric selection menu
  • We “prettify” dimension names and separated out dimensions by their identifiers
  • We removed the free-form text from the time constraint selection and now provide a fixed menu with operators
  • We partially removed the free form text from the where constraint selection and now provide a prompted menu that allows you to filter with AND/OR operators as well as various equalities. The dimension value input is still a free-form text field.
  • We now specify what dimensions are time dimensions and provide custom filterability with a calendar.
  • We now enter a note into the cell where a selection was made to indicate what the selection was
  • We won’t overwrite data without providing a warning

Verification Steps

Access the Google Sheets Connector by downloading it from the Google Add-Ons store - or if already installed- through the Extensions menu

🐛 Bug Fixes 🐛

Currency Format Example Bug

Details

More Detail

The currency format on the metric metadata settings incorrectly implied that it divides the number by 1000, but it does not.

Verification Steps

Confirm the currency format example displays a number like 12345 as $12,345.00

· One min read

We have nothing new this week! Check back in two weeks.

· One min read

✨ New ✨

Excel Integration

Details

More Detail

You can now get access to your metrics and dimensions in Excel desktop through the Transform Excel Add-In! The add-in is a custom menu which allows you to select metrics you want, slice by dimensions, filter, and other actions that our core APIs support.

Verification Steps

Find the instructions on Excel by accessing our integration page

Read the documentation here!