What's New in 22R2.1

The Nitro 22R2.1 release includes several new features.

Our release notes offer brief, high-level descriptions of enhancements and new features. Configuration is available by selecting the feature name.

Features

Nitro Explorer

New Jinja Macros

  • The Jinja dataset macro allows users to reference both virtual and physical datasets, as well as their attached calculated columns and metrics. For example:

    SELECT * FROM {{ dataset(42, include_metrics=True, groupby=["ds", "category"]) }} LIMIT 10

  • The where_in filter provides for a better experience defining multiple values. For example, in a WHERE clause:

    SELECT * FROM some_table

    WHERE

    action IN {{ filter_values('action_type')|where_in }}

User Visible and Behavior Changes

Most new functionality requires some configuration, however users are able to use the following functionality immediately. Select the thumbnail to view a larger image.

Description Before After
Users can switch between visualization types when working with a chart in Explorer, while retaining their selected metrics and dimensions. n/a
Users can change the orientation of a Time-series Bar Chart visualization in Explorer from vertical to horizontal.
The Table visualization in Explorer supports drag and drop for column rearrangement, making it easier to customize. n/a n/a
The Mixed Chart visualization in Explorer supports a non-time-series (generic) x-axis.
The Mixed Chart visualization in Explorer supports the display of both queries.
The Mixed Chart visualization in Explorer supports Advanced Analytics. n/a n/a
Users can filter datasets in the Datasets list view in Explorer by certification status.
Users can access the results panels for a chart directly in a Dashboard in Explorer. n/a