The fields that you see in your dimensions
and metrics
are created by the people maintaining your Lightdash project. But, you can create new custom dimensions or metrics for quick calculations and binning on the fly. On this page, we’ll explain what custom dimensions and metrics are and how to use them.
metrics
available if you open the same Table to build a new chart. Metrics written to your dbt project (or YAML metrics) are reusable by everyone in your project and will always show up in the side bar of available metrics for a Table. We recommend writing back custom metrics that you’re using/creating frequently so they become reusable, governed and available for everyone else to build from.
To create a custom metric:
options
menuCount Distinct
)custom metrics
space in your sidebar.
options
menu and hit Remove custom metric
options
menubin
optioncustom dimensions
space in your sidebar.
orders
table and create a custom dimension that categorizes my orders’ totals into three categories: low
, medium
, and high
.
You can click on the button to add a custom dimension on the sidebar: