Lightdash updates
Lightdash updates

๐Ÿ‘ฏ Double Dash




You can now easily duplicate any dashboard, and it's even easier to delete them!

โ“ Do you want to iterate on a dashboard without making changes to the original? Or perhaps you want to show the same dashboard in multiple spaces without having to painstakingly recreate it? Well now this is possible in Lightdash!

Whether you're in the dashboard, or you're looking at the list of dashboards, from the action menu, you can easily duplicate the dashboard. It will create it within the same space but it's easy to move it to any other one in the project. And if you get trigger happy with the duplication, there's also a delete button in the action menu.

Kapture 2022-08-18 at 18.20.35.gif

๐Ÿช„ If 42 is the answer, then what is the question?




You can now view the underlying data for any value in a chart or table!

๐Ÿ”ฌ Have you ever looked at a chart and spotted a number that you want to know more about? Well, as of the latest Lightdash release, this is now possible from within the table explorer, or from a dashboard.

All you need to do is hover over the value you're curious about, click into it, and select "View underlying data" from the context menu. You'll be shown the underlying data that makes up that individual data point in a nice handy table.

๐Ÿ”ญ Still curious? Well from the underlying data, you can also select "Explore from here" to be taken to the table explorer with the current field selections and filters applied.

Kapture 2022-08-18 at 17.28.37.gif

๐Ÿ”Ž Looking for something?




You can now search across charts, dashboards, metrics, dimensions and even spaces!

๐Ÿ“š With users across the business and the data team all creating content (because it's so darn easy to with Lightdash!), finding the right thing can become tricky. That's why we recently released Spaces and it's why we're now adding Search.

๐Ÿ“— Thats right, you can now search across nearly all your Lightdash content using the new search box - and it even comes with a handy keyboard shortcut for when the mouse is having a bad day.

Kapture 2022-08-03 at 18.16.42lo.gif

Read more about exploring your content in Lightdash.

๐ŸŽ The Ace of Spaces




You can now organise your charts + dashboards into spaces!

๐Ÿง˜ So many of our users were keen for some space - so now you can breathe easy with Spaces in Lightdash. You can use Spaces to organise your charts + dashboards, for example, you could have a Sales space where all the Sales related dashboards and charts are kept for that team.

Kapture 2022-08-01 at 18.19.12.gif

๐Ÿš› We've put all your existing charts + dashboards into a space to start with, but you can create more spaces and easily move them between each space using the three-dot menu. You can read more about spaces in the docs.

๐Ÿ”’ And there's much more on the roadmap for Spaces, next up: Space Permissions!

๐Ÿงน De-clutter your sidebar




Grouping metrics and dimensions in the sidebar is now possible in Lightdash via some easy configuration in your dbt model's .yml file!

To resolve Issue #1851, using the group_label property, you can group related metrics and dimensions together in whatever way you wish. Collect all those profit related metrics in one place, and maybe stick all the date related dimensions together? Or group by theme and keep all averages together? We love making it easy for the data team to make it easy for the data consumers.

Read more about how this works in the reference sheets for metrics and dimensions and you can check out Issue #2685 for more planned changes to the sidebar UI!


๐Ÿฝ Brushing up on our table manners




Table chart types now scroll as many results as needed, with sticky headers, column totals, some visual improvements and the ability to download as .csv directly from the dashboard view!

As per milestone #44, all of these features are now available in Lightdash so that we can all enjoy cleaner tables that are even easier to export.

Kapture 2022-07-13 at 17.30.35.gif

โ†•๏ธ See it. Calculate it. Sorted.




You can now sort by table calculation in both the results pane, and in table chart types (Issue #431).

And we're definitely not ashamed to be the first analytics tool ever to take inspiration from the British Transport Police in announcing an improvement to table calculations.

Kapture 2022-07-12 at 18.31.09.gif

Check out our docs to learn more about what you can do with table calculations in Lightdash.

๐Ÿฅž Mixed charts have never been so stacked ๐Ÿ˜




You can now stack the grouped series in a mixed chart type! We promised more chart config, and here it is, thanks to Issue #2524. This doesn't just work with bar and line chart types, it also works with area and scatter types. If you didn't know about mixed charts in Lightdash, check out our docs.

Kapture 2022-07-12 at 17.43.17.gif

And yes, you guessed it, we have plenty more chart config options in the works. If there's anything particular you'd like to see that isn't already covered in our backlog, feel free to submit a feature request.

๐ŸŒŠ You've been hit by... a smooth integral




We've just added Line smoothing and symbol hiding options for your charts. For each series in your line chart, you can get those pesky value markers out of the way and then make your lines so smooth that ๐Ÿš maglev trains will be wanting a piece of the action!


We have plenty more chart config options in the works, so check out our backlog, and feel free to submit a feature request for anything you want to see that's not already covered!

Creating legendary charts ๐Ÿ“ˆ




Vertical legend, no legend, scrollable legend anything is possible with new fine-tuning controls for chart legends and margins.

For charts that simply have too many series, you can make your legend scrollable. Here's the most extreme example we could come up with:

Jul-04-2022 14-43-21.gif

And here's a much more sensible example, showing a vertical legend at the side of the chart:

Screenshot 2022-07-04 at 14.47.04.png