Lightdash updates lightdash.com

New

You can set allowed email domains in Lightdash - letting anyone from your team join without needing an invite.

As a reminder, Lightdash lets you have unlimited users in your workspace, so no more rationing out BI tool licenses! To make it even easier to join, as an admin, you can set a list of allowed email domains who can join your workspace without an explicit invite link. When they sign up for Lightdash, they'll be offered to join your workspace.

Read more on how to set this up in our docs.

New

You can now set up scheduled reports to be delivered via email or Slack at your desired schedule!

Ever wanted to automate that KPI dashboard so it went out to your whole team every Monday morning? Ever wanted to send a customer a report on their usage every month?

With scheduled deliveries in Lightdash, now you can! This feature lets you send a dashboard or saved chart (as an image, or a .csv) to people via email or Slack - even to those who don't have an account in your Lightdash instance.

You can set up schedule deliveries to be sent via Slack or email and you can send individual charts or an entire dashboard. You can set up as many scheduled deliveries to a saved chart or dashboard as you like, and if you make any changes to the content, the reports will be updated accordingly.

To try it out, click on the three-dot menu in the top-right corner of your chart or dashboard, then click on scheduled deliveries.

New

You can now pin charts and dashboards to your project homepage.

You can now get your whole team focused on that KPI dashboard! All you need to do is select the more actions menu on a chart or dashboard (on the project homepage, or in a space), and then select "Pin to homepage". On refresh, that item will now be pinned for everyone that has the relevant permissions to see it.

We have plenty of improvements coming to this feature to make it easier to use and also allow pinning of Spaces… watch this 'space'!

New

Charts and Dashboards now show their overall number of views!

Further to our new Usage Analytics feature, now you can see how popular each chart and dashboard is, both in the header on every individual chart and dashboard, along with on your project homepage in the chart and dashboard listings.

This feature is really useful for understanding which content is most important, plus it can be used to help clean up unpopular content!

For charts, the view count is incremented every time someone views a chart both on its own, or as part of a dashboard. Note that the view count starts either from when the chart/dashboard was created OR from when we released this feature (whichever is newer)!

Read more about Usage Analytics in our docs.

New

You can now see the key usage statistics for internal use of your Lightdash project! If you've ever wondered:

• What's the overall breakdown of users across viewers, editors and admins?
• How many users run a query once a week?
• Who runs the most queries?
• Who makes the most changes to content?

Then Usage Analytics is the place for you. You'll find answers to the questions above, and more. This can be helpful to understand internal BI adoption, along with the value provided over time. To get there, just head over to your "Project Settings" and within "Project Management" you'll find the "Usage Analytics" tab.

In upcoming releases, we'll add the number of views and updates for every chart and dashboard to help you understand the most (and least 💀) useful content.

Read more in the docs.

New

We now support Percentile metric types.

This new metric type generates the given percentile of the values in the given field. You could use it to create an easy median, or, say an upper quartile.

The percentile metric can be used on any numeric dimension or, for custom SQL, any valid SQL expression that gives a numeric table column. See it explained further (with an example you can copy!) in the docs.

In the example below, the median_price metric is created by taking the 50th percentile of the item_price dimension…

New

You can now apply conditional formatting to values in table charts.

Sometimes it’s helpful to highlight certain values in your tables when they meet a specific condition. You can set up conditional formatting rules by going to the Configure tab on the table chart and then selecting the "Conditional formatting" tab.

Read more in the docs.

New

We now support sharing charts and dashboards via Slack with a handy preview.

All you need to do is head to the Settings in your Lightdash instance, and find the new Slack menu. When you select "Add to Slack", and add Lightdash to your Slack Organization.

Then, when sharing a Lightdash URL within your Slack Org, you'll be presented with the title of the chart/dashboard, description and even a full image preview of its very latest state. There's even an "Open in Lightdash" button that will take you straight there.

Read more in our docs.

New

You can drill into a metric in your chart or results table to better understand a point in your chart. Selecting drill by lets you group your metric by a dimension, like the total revenue segmented by (or grouped by) product type.

You can read more about drill-by in the docs here.

New

Add reference lines to your charts with just the click of a button!

You can use reference lines to set targets, track your goals, or point out important thresholds in your charts.

Read more about it in the docs here.