Create Calculated Measures

The GoodData Demo Workspace comes preloaded with data and measures which you can use to construct insights and dashboards. In this section, you will learn how we created some of the measures in the demo workspace and how to create and save a new measure, and reuse it.

To create or modify existing calculated measures you use the Metric Editor.

Metric Editor is a part of the workspace management tools. The Metric Editor uses different nomenclature for some items with the Analytical Designer. The following table describes the differences:

Analytical Designer and KPI DashboardsMetric Editor
MeasureFact
Calculated Measure

Metric

WorkspaceProject

If you want to create a new calculated measure, use Metrics Editor and create a new metric which will then appear in your Data Catalog section along other measures.

Tutorials in this section are based on data from the GoodData Demo Workspace. However, the principles and practices described here are applicable to all GoodData workspaces.

Why You Should Save Your Calculated Measures

When you build a calculated measure in the Metric Editor, you use the GoodData's own query language called MAQL (MAQL - Analytical Query Language). It allows you to build reusable calculated measures and filters and avoid building one-off SQL queries in a web user interface. MAQL allows you to create calculated measures with a simple expression language, and it also allows you to combine simple expressions into powerful complex calculated measures.

Powered by Atlassian Confluence and Scroll Viewport.