Create Calculated Measures using Arithmetic Functions
Analytical Designer now allows you to create new calculated measures directly in your insights.
Use items from the Measures section and basic arithmetic functions to create new measures for your current insight.
For example, you can create measures to display:
- Your total revenue over the last two years (revenue this year + revenue last year)
- Increase of your revenue since last year (revenue this year - revenue last year)
- Your gross margin (gross profit / net sales)
- Revenue from one product (price per unit x volume sold)
- Change in your revenue (% change year over year)
Learn more:
Create Calculated Measures in Insights
Export Insights from Analytical Designer
If you need to analyze data from you insights in other applications, you can now export insights from Analytical Designer to XLSX files (with merged or unmerged cells) or CSV files.
Learn more:
Export insights
Updated Lists of U.S. States and U.S. Counties for Geo Charts
We have updated the CSV files listing the U.S. states and the U.S. counties that are used for configuring data for geo regions in GoodData geo charts.
The list of U.S. states now includes territories such as Puerto Rico, American Samoa, Virgin Islands, and others. The list of U.S. counties has been updated accordingly to include the counties of the newly added territories, if available.
Learn more:
Setting up Data for Geo Charts
Login in User Details for Data Warehouse Users
When retrieving a list of users for a Data Warehouse instance via the API or the gray pages, you can now see the login information for each user.
{
"users": {
"items": [
{
"user": {
"role": "admin",
"profile": "/gdc/account/profile/jqv...w0z",
"login": "john@gooddata.com",
"links": {
"self": "/gdc/datawarehouse/instances/wfc...047/users/jqv...w0z",
"parent": "/gdc/datawarehouse/instances/wfc...047/users"
}
}
}
],
"paging": { },
"links": {
"self" : "/gdc/datawarehouse/instances/wfc...047/users",
"parent" : "/gdc/datawarehouse/instances/wfc...047"
}
}
}
This helps you easily identify a user without navigating to their profile and back.
Learn more:
API for listing users for a Data Warehouse instance
List users for a Data Warehouse instance via the gray pages
REMINDER: Deprecation and Upcoming End-of-life: Project Templates
The project templates are deprecated and will stop working on May 15, 2019.
How will this affect you?
If you are using the project templates, they will stop working on May 15, 2019. Any request to create a new project that includes a project template will fail.
How can you get prepared?
Check whether you are using the project templates. If you are using them, start using Life Cycle Management (LCM) instead as soon as possible. LCM allows you to configure and control multiple workspaces through master workspaces.
ACTION REQUIRED!
Make sure that you either adopt LCM or update your solution to run without the project templates before the end-of-life, May 15, 2019.
Learn more:
- For more information about LCM, see Managing Projects via Life Cycle Management or contact your Account Manager.
- For more information about the project template deprecation, see Project Templates.
- For information about all deprecated features, see Deprecated Features.