Spotlight is a suite of features designed to put Metrics front and center. It simplifies data exploration, making it easy for business users to focus on metrics without dealing with complex tables or time dimensions.
.yml
to simplify the process for users. See how
.yml
. This includes joins See how
.yml
files.
lightdash.config.yml
in the root of your dbt project.
See this video for an example on how to set this up:
Step-by-step guide
lightdash.config.yml
file:show
or hide
.If you don’t set this, the default visibility will be show
, so all metrics will be visible in the catalog by default (but other settings like user attributes will still apply).show
for all metrics in your project. You can also set this to hide
if you prefer to hide metrics by default and then override this on a per-model/metric basis.
event_count
metric in the catalog, even though the events model is hidden.categories
field to your lightdash.config.yml
file.
Here’s a video showing how to set this up:
Step-by-step guide
lightdash.config.yml
file:categories
field to your models .yml
file.revenue
category to all metrics in the events model.
If you want to add another category to a specific metric, you can do so by adding the categories
field to the metric’s .yml
file. And remember, you can only add categories that have been defined in the lightdash.config.yml
file.
marketing
category to the event_count
metric:
So in your lightdash.config.yml
file, you need to have another category. Let’s call it marketing
and add it to the event_count
metric, like so:marketing
category to the event_count
metric:
event_count
metric will have both the marketing
and revenue
categories, it’s cumulative.
event_count
metric in the catalog with both the marketing
and revenue
categories and you can use this to filter your metrics in the catalog..yml
files.
event date
with day granularity in the last 30 days
event date
with month granularity, instead of the default day granularity applied to the table
.yml
: Metrics with a default time dimension specified in the .yml
file will always appear.
Action | Project Admin | Project Developer | Project Editor | Project Interactive Viewer | Project Viewer |
---|---|---|---|---|---|
Browse the ‘Metrics catalog’ | |||||
Add/edit /delete ‘Categories’ | |||||
Open the ‘Metrics Explorer’ |