Release 96: Saturday, November 9, 2013

Hide me by wrapping with <div style="display:none;"> </div> or by adding display:none to the style attribute of div id="incrementals-toc" 

New updates since release 96:

What's New: Release 96.1

New MAQL Rounding and Truncation Functions

The new rounding and truncation functions are the latest MAQL extensions that have been added to GoodData’s data query language since the release of the GoodData Extensible Analytics Engine (XAE). Previously it was possible to carry out surface level rounding with Custom Number Formatting, affecting how values were displayed in a report. Now rounding and truncation can be incorporated within a MAQL expression that represents a metric’s definition.

ROUND( )

With the rounding function ROUND( ) you can round an input to the nearest integer or add a second parameter to specify the number of decimal places to which the input should be rounded. ROUND( ) accepts any constant, fact, metric, or metric expression as an input. The second parameter, if included, should be an integer, although real numbers are supported for input.

Syntax:

• ROUND(input)
• ROUND(input, decimal_places)

Examples:

• ROUND(12.2) returns 12
• ROUND(12.7) returns 13
• ROUND(12.257, 2) returns 12.26
• ROUND(12.257, -1) returns 10

FLOOR( ) and CEILING( )

As an alternative to ROUND( ), the new FLOOR( ) and CEILING( ) functions allow you to strictly round mixed numbers down or up, respectively, to the nearest integer. FLOOR( ) and CEILING( ) accept any constant, fact, metric, or metric expression as an input. 

Syntax:

• FLOOR(input)

• CEILING(input)

Example:

• FLOOR(12.77) returns 12
• CEILING(12.22) returns 13

TRUNC( )

The truncate function works in the same way as the rounding function except for a subtle difference in the output. Rather than round to the nearest integer by default, TRUNC( ) simply removes any decimal place values, leaving the whole number place values unaffected. When truncating to a certain number of decimal places, additional decimal place values are removed and the final decimal place value remains unrounded. TRUNC( ) accepts inputs in the form of any constant, fact, metric, or metric expression. The second parameter, if included, should be an integer, although real numbers are supported for input.

Syntax:

• TRUNC(input)
• TRUNC(input, decimal_places)

Example:

• TRUNC(126.54782) returns 126
• TRUNC(126.54782, 2) returns 126.54
• TRUNC(126.54782, -2) returns 100

Improved Glossary in the Custom Metric Editor

In the Custom Metric Editor, the glossary of MAQL expressions and their associated syntax snippets has been reorganized to reflect the latest extensions to our query language. Content updates include revised explanations of existing expressions, in addition to those included in this release. The glossary is now organized into the following categories:

• Aggregation

• Numeric

• Granularity

• Logical

• Filters

Updated glossary in Custom Metric Editor

For more information, see the MAQL Reference Guide.

Australian Regions Now Available in Geo Charts

With this release, GoodData now supports Australian states, by name or ISO code, in Geo charts.

Supported geo attribute labels with new Australian regions

More info: Preparing Data for Geo Charts

What's New: Release 96.2

Median Aggregation Function Added to the User Interface

The new Median function, which has been available since release 95, now appears in the simple and custom metric editors, where it can be selected for use in metrics. In the Simple Metric Editor, you can find Median in the dropdown containing operations that can be used to aggregate metrics.

Median in the Simple Metric Editor

In the Custom Metric Editor, Median appears in the glossary of MAQL expressions. From there, you can select the Median function's linked name to add it directly into your custom metric's defintion.

Median in the Custom Metric Editor

For more information on the Median function, see the Release 95 Notes.

Report Directory Selections Are Now Saved Between Visits

The selections a user makes in a project's Report Directory are now saved between visits to the page, even if a user logs out of GoodData or exits the browser. Saved selections may include any selected report folders or tags, and the last selected value in the Group by dropdown. Selections are saved on a per user and project by project basis.

Selected report tags

Selected report folder

Last selection in the Group by dropdown

What's New: Release 96.3

Hide a dashboard report's title

It is now possible to hide the title of a report appearing on a GoodData dashboard. This could be useful for aesthetic reasons or when a report’s significance is evident due to its context.

To hide a report’s title, editors and administrators can enter Edit Mode, select a report, use the gear icon that appears to open the report’s configuration settings, and open to the Style tab to set Report Title to hidden.

Hiding a report's title

Other Recent Updates

In the weeks following release 95, several new features were added to the platform. Updates have been appended to the release 95 notes:

• New pushpins in geo charts
• Time and datestamps added to scheduled email filenames
• Czech districts now available in geo charts
• Download CloudConnect processes from the platform
• Change ETL graph to use in process schedules through the DLA

On the Horizon

GoodData is committed to rolling out new, innovative features. Here's what we've been hard at work on:

• New options for exporting raw report data to CSV
• New MAQL percentile function

Thanks for reading up on the latest updates to the GoodData platform. Check back soon for new features to be unveiled in the weeks ahead! You can also review other recently released features as described in the Release 95 Notes.