status
, to split orders by their status
, we may want to know the “Total number of orders” or the “Total sales” of the orders. These calculations are metrics:
main
if that’s your style 🤠) and add a metric to one of your dbt models.
We’d suggest starting out simple, like a count
for a primary key in your table.
For example:
lightdash preview
lightdash preview
comes in handy.
Developer previews are temporary Lightdash projects where you can safely experiment with your metrics, dimensions and charts without affecting your production project.
So, let’s spin up a developer preview and check out our changes. In your terminal, run the commands:
cmd
+ click
to open the preview link from your terminal. Once you’re in Lightdash go to Explore
—> Tables
, then click on the model you just updated to see your new metric and play around with it.
meta
tag of your columns, under metrics
:
main
or master
).
Once they’ve been merged or if you’re just working off of main
(rebel 😏), you can deploy your changes.
Once you’ve merged your changes, you’ll want to deploy them to production. To do this, just run these commands in your terminal from your dbt project:
dbt_khindson.my_model_names
), then you’ll need to pass the production target in your lightdash deploy
command. Something like: lightdash deploy --target prod
.dimensions
and metrics
are created by the people maintaining your Lightdash project.
But, if there’s something missing from this list of metrics, you can use custom metrics
to add some on-the-fly calculations while you’re exploring.
To read more about custom metrics, take a look at how to create custom fields.