analytics-dictionary / term / bi & reporting

Calculated field

A calculated field is a new value computed from existing fields inside a BI tool, such as profit margin.

Written by Reflective Data experts · updated Oct 5, 2026

They are convenient but risky: the same calculation can end up defined differently in many dashboards. Moving important calculations into a semantic layer keeps them consistent.

Use calculated fields for quick, local needs.

Dashboard Metric Semantic layer

// how we can help

We build BI and dashboards people actually use, on the tools you have or the right new one. BI & reporting services → · Explore on the platform

Tableau

Tableau is a visual analytics platform known for flexible, interactive visualisations.

power-bi.md

Power BI

Power BI is Microsoft business intelligence platform for modelling data and building reports and dashboards.

olap-cube.md

OLAP cube

An OLAP cube is a pre-aggregated, multidimensional data structure that makes slicing and dicing fast.

ad-hoc-analysis.md

Ad hoc analysis

Ad hoc analysis is a one-off investigation to answer a specific question, rather than a recurring…

looker-studio.md

Looker Studio

Looker Studio, formerly Data Studio, is Google free tool for building interactive reports and dashboards.

scorecard.md

Scorecard

A scorecard is a compact view of a handful of KPIs against targets, often with status…

← full analytics dictionary