Thanks for checking in to see what's new for Release 97! Each week, we publish a new release of the GoodData platform detailing new features, updates, and platform enhancements. Check back soon, as we'll continue to post updates to this article over the weeks ahead.
What's New: Release 97
Release 97 focuses on back-end improvements, infrastructure, and boosting overall platform performance. But if you insist, we'll drop a little hint of what's to come. It's thanks to community input that we've been able to develop the new features we'll be releasing in the weeks ahead. From the entire team at GoodData, thank you for your contributions!
What's New: Release 97.1
New MAQL Percentile Function
The new Percentile function is the latest of a series of extensions made to MAQL, GoodData’s query language for defining custom metrics. PERCENTILE( ) returns the specified percentile out of some set of values. This could be useful for establishing a threshold of acceptance, such as for candidates who score above the 90th percentile on a certification exam, or rewarding sales reps in the top percentile with regard to deals won in the past year.
Defining Percentile with a decimal value:
PERCENTILE(numeric, k)
- where numeric is a fact or metric
- where k is a value between 0 and 1 representing the percentile you want returned specified as a decimal. k accepts constants as inputs. Numeric values must be expressed in the following format: 0.xx
- For metric expressions, you should compute percentiles using syntax similar to the following:
SELECT PERCENTILE((SELECT SUM(fact) BY attribute), 0.25)
Example:
SELECT PERCENTILE(Amount, 0.75)
Defining Percentile with a percentage:
PERCENTILE(numeric, k%)
- where numeric is a fact or metric
- where k% is a number between 0 and 100 representing the percentile you want returned. k accepts constants followed by percent signs as inputs.
- For metric expressions, you should compute percentiles using syntax similar to the following:
SELECT PERCENTILE((SELECT SUM(fact) BY attribute), 25%)
Example:
SELECT PERCENTILE(Amount, 75%)
For more information on using MAQL to define custom metrics, see the MAQL Reference Guide.
What's New: Release 97.2
New option to export "raw" data for report on analysis page and dashboard
In some instances, you may discover that your configured report contains too many attributes or metrics to effectively compute and display. In these situations, you can choose to download the displayed report as raw CSV data, which delivers the selected report as raw values without cross-tabulation. This method allows for faster export of even larger reports. The GoodData Portal places limits on the volume of data that can be displayed in any report.
As an alternative file format, you can choose to download reports as raw CSV data. From the Gear icon next to the report in the dashboard, you can choose to export raw data, which means that the data in the selected report is exported in CSV form without cross-tabulations. Through this method, you can download large volumes of report data for use in non-browser environments.
Below, you can see how a standard report is displayed in the GoodData Portal, as well as example exports to standard CSV and Raw data (CSV) formats:
Export to “CSV”
"Name","18. 1. 2013","Bike - U Vltavy, 25. 3. 2013","Bike - U Vltavy, 29. 3. 2013","Fish Grade" "Name","# Rides 1","# Rides 1","# Rides 1","# Rides 1" "Martin Cacky","1","1","1","" "Roman Stanek","","","","1"
Export to “Raw data (CSV)”
Name,name,"# Rides 1" "Martin Cacky","Bike - U Vltavy, 29. 3. 2013",1 "Martin Cacky","Bike - U Vltavy, 25. 3. 2013",1 "Martin Cacky","18. 1. 2013",1 "Roman Stanek","Fish Grade",1
GoodData logo removed from header of embedded dashboards
When embedded dashboards failed to load because of Single Sign On error, a failure page included an instance of the GoodData logo, which was not appropriate for white-labeled environments. This logo has been removed.
Transparent background now supported for embedded reports
When embedding a GoodData report into your app, you can now set the report background as transparent to achieve more consistent look with your app.
The option to set transparent background is available in the standard Embed configuration dialog accessible from the bottom of the report when it is displayed in the Report Editor page.
New MAQL Standard Deviation Function
With this release, MAQL introduces two standard deviation functions to the library of statistical functions. You can now compute the standard deviation of a given set of values, as represented by a project fact or metric, to help determine the dispersion of data points around the mean of the data set.
Standard deviation is useful for measuring variance within a data set and, in application, confidence in statistical results. For example, in finance, standard deviation is typically used to measure the potential deviation from expected rate of return and serves as a calculation for the volatility of the investment.
Corrected Sample Standard Deviation
STDEV(numeric)
- where numeric is a fact or metric
- where output is generated by taking the square root of [the sum of squared differences from the mean divided by (n - 1)]
Example:
SELECT STDEV(Internal Rate of Return)
Uncorrected Sample Standard Deviation
STDEVP(numeric)
- where numeric is a fact or metric
- where output is generated by taking the square root of [the sum of squared differences from the mean divided by (n)]
NOTE: This version of standard deviation is used if the sample could include a single value (where n=1). This version prevents division by zero errors, which return null values. If n=1, the returned deviation is always zero (0).
Example:
SELECT STDEVP(Internal Rate of Return)
For more information on using MAQL to define custom metrics, see the MAQL Reference Guide.
New Developer Articles
- Explicit Lifting – Learn about a feature of GoodData’s Extensible Analytics Engine that grants you greater flexibility in the way you aggregate metrics in reports.
- GoodData Token Types – Review the types of tokens you can use to authorize projects, use GoodData's APIs, and gain access to the GoodData Platform.
- Setting Up Fluig Single Sign-On – Find out more about the latest SAML Identity Provider supported by GoodData.
- GoodData Java HTTP Client – Check out an interesting use case for implementing functionality on top of the GoodData API with Java (Groovy or Scala).
- Date Attribute Arithmetic – Get up to speed on GoodData's new capabilities for carrying out date arithmetic with date attributes. No need to create date facts just to carry out date computations!
Other Recent Updates
In the weeks following release 96, several new features were added to the platform. All updates have been appended to the Release 96 notes:
- Improved Glossary in the Custom Metric Editor
- Australian Regions Now Available in Geo Charts
- Median Aggregation Function Added to User Interface
- Report Directory Selections Now Saved Between Visits
- Hide a Dashboard Report's Title
- Download ETL Processes Directly into CloudConnect
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!