An analyst is building an AI/BI dashboard and wants to create a custom metric that calculates profit margin as (revenue - cost) / revenue directly within the dashboard, without modifying the underlying Unity Catalog table. Which feature should they use?

Question

Accepted Answer

B. Define a custom calculation in the dashboard's dataset using a calculated field. Custom calculations in Databricks AI/BI dashboards allow analysts to create calculated fields (such as derived metrics) on top of existing datasets within the dashboard context, without modifying the underlying Unity Catalog tables. Adding a column to the UC table would require DDL changes and modify the shared asset. Stored procedures are not the right tool for dashboard-level derived metrics. Creating a new managed table adds unnecessary data duplication.

An analyst is building an AI/BI dashboard and wants to create a custom metric that calculates profit margin as (revenue - cost) / revenue directly within the dashboard, without modifying the underlying Unity Catalog table. Which feature should they use?

Related Questions

Discussion