Release 94 Notes: Saturday, September 7, 2013

Thanks for checking in to see what’s new for Release 94. This release, we bring you two MAQL updates and a usability improvement to Geo charts. Check back in next week for several additional updates you won't want to miss!

New updates since release 94:

Release 94.1

Thursday, September 12, 2013

Release 94.2

Thursday, September 20, 2013

Release 94.3

Thursday, September 26, 2013

Release 94.4

Thursday, October 3, 2013

What's New: Release 94

MAQL Update: Hierarchical Running Totals

Previously, running total functions were only supported by reports with a single date attribute. A new update to MAQL running total functions (RUNSUM, RUNMIN, RUNMAX, RUNAVG) adds support for reports with multiple date attributes of the same dimension.

In the example below, the RUNSUM Leads column shows a cumulative aggregation of a Number of Leads fact, broken across three report attributes: Year, Quarter/Year, and Month (that leads were created).

DP148_2.jpg
Running total aggregation functions like RUNSUM are now supported in multi-attribute reports

The RUNSUM Leads metric can also be modified to group cumulative aggregations within report sub-groups using a WITHIN expression, as exemplified by the metric in the final column above:  

SELECT RUNSUM(# Leads) WITHIN (Year)

MAQL Update: Explicit Lifting

With release 94, we’re introducing the ability to specify the granularity of metrics, such as those that contain date arithmetic calculations. This could be useful in the case where you’d like a metric to return the average support ticket resolution time:

SELECT AVG((SELECT Date(closed) - Date(open) BY TICKET_ID))

or

SELECT AVG((SELECT {This} - Date(closed) BY TICKET_ID))

In this way, the BY keyword allows you to explicitly define the granularity of the arithmetic at the individual ticket level.

Geo Chart Update: Zoom Level Maintained Across Layers

Previously, when switching between Geo chart layers, the map zoom level dynamically adapted to the data displayed on any given map layer. But further usability testing showed that maintaining the default zoom level across multiple layers helps users stay oriented when viewing map data. This finding has been reflected in our latest round of Geo chart improvements.

Backend Improvements

You might not notice them at first glance, but our backend improvements continue to improve performance for the thousands of organizations that rely on GoodData to make critical business decisions every day.

What's New: Release 94.1

CloudConnect Update: Modify Datatype of Facts and Attributes

You can now modify the datatype of facts and attributes in CloudConnect. For example, you could change the datatype of a fact from a two digit decimal to an integer. To make modifications to a given fact or attribute, select its name in a dataset and in the Details sidebar that appears, click the pencil icon that appears by Datatype.

datatype.png
Click the pencil icon to modify the datatype.

Use the dialog that appears to modify the fact or attribute's datatype.

dialog1.png
You can now modify a fact's datatype.

You can also modify datatypes from the Attributes and Facts dialog. Select Show Datatypes and then click a datatype to update its value.

dialog2.png
Update a fact or attribute's datatype from the Attributes and Facts dialog.

For more information on facts, attributes, and datatypes, see the CloudConnect LDM Modeler Guide.

What's New: Release 94.2

New Sorting Capabilities in Line, Area, and Combo Charts

Sorting controls are now supported for line, area, and combo charts – in addition to bar charts – and can be found in the sliding configurations pane.

Sorting allows you to determine the order in which report values appear in a chart. Different sorting options may be available depending on the type of attribute used in a report.

Options for sorting in charts with date attributes

For more information on the new sorting capabilities in charts, see our article Sorting in Line, Area, and Combo Charts.

What's New: Release 94.3

Newly Exposed Embedded Dashboard Event

When GoodData dashboards are embedded in another web application, the dashboards expose certain events, which can be used to pass messages between a dashboard and its parent web page. These can include application state events (e.g. project down for maintenance) as well as user initiated events (e.g. user clicks a link to open an external page).

With this latest release, report export has been added as a newly supported exposed event. This means that when users export a report, this information is passed on to the parent application, which can handle the event in any way you see fit.

For more information see our article Embedded Dashboard Events.

What's New: Release 94.4

Redesigned Report Info Panel

GoodData’s newly redesigned report info panel provides a single unified dialog that you can use to learn more about a report, access a report’s fundamental configurations, or export a report to a variety of formats.

one.jpg
New report info panel icon

When fully expanded, the report info panel displays a report’s name and description, metric(s), and the names of any dashboard filters currently affecting the report.

two.jpg
Information provided about a report

Clicking Edit This Report navigates to a report's fundamental configurations in the Report Editor.

You can also use the Download As... dropdown to export a report in a number of formats. GoodData supports XLS, CSV and PDF file formats for exports, as well as PNGs in the case charts).

three.jpg
Export reports to multiple formats

The new info panel also appears on the drilling dialog. This is especially useful for reminding you which dashboard filters may be affecting the drilling report's computations.

drilling.jpg
The new report info panel on a drilling dialog

Dashboard Filters Now Support 500 Values

Dashboard attribute filters now support up to 500 selectable values, up from the previous limit of 200.

Filters500.jpg
Higher filter value limit

Other Recent Updates

Since the last major release several new features have been added to the platform:

On the Horizon

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

  • Sorting in stacked bar charts will allow users to sort the order of a chart's bars along an axis as well as the order of the stacked layers.
  • Cascading date/variable dashboard filters will allow you to set up parent/child relationships between variable dashboard filters and date dashboard filters. With cascading filters, the values an end user selects in a parent filter intelligently limits the values available for selection in the child.

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 93 Notes.

Have more questions? Submit a request

Comments

  • Avatar
    Dave Nuffer

    Anyway to learn more about Explicit Lifting? Seems cool, but I don't quite understand how to take advantage of it!

  • Avatar
    Winston

    Hi Dave, thanks for your question. We have a blog post coming out shortly that will further expand on this topic. I'll post the link here and forward it to you as soon as it's live!

  • Avatar
    Ramon Cabato

    Was just looking at  Streamlined Single-Value Selection in Dashboard Filters. I don't see the difference between clicking on the check box to the left of the choice and clicking on the ONLY option. Will it "save" the only option for the specific user? THAT would actually be more helpful. 

  • Avatar
    Winston

    Hi Ramon, clicking 'only' is a shortcut that circumvents de-selcting all values before selecting the one value you're interested in filtering. It turns a two step process into a single step process. I'll be forwarding your suggestion on to our product managers, who have been exploring ways to make filters more intelligent by remembering user selections. Thanks!

Powered by Zendesk