Lightdash updates
Lightdash updates

Share all the things! ๐Ÿ”—




Share anything in Lightdash by copy & pasting the URL. Or if you want to save a few clicks, just look out for the all new link icon.

You'll see this is the newly-designed toolbar on your saved charts but look out for it appearing around the rest of Lightdash:

Screenshot 2022-05-17 at 14.55.51.png

New view-mode for charts ๐Ÿ“บ




Focus and geek-out on your beautiful chart with view-mode, a full-width view of your chart without all the editing tools.

Need to tweak the chart? Choose from "Explore from here" or "Edit chart" to get your tools back and start perfecting that analysis ๐Ÿ‘Œ


Oh and we also made the toolbox resizable! This is the first in a series of upcoming changes to improve your quality of life while doing your bread-and-butter: analysing data and creating charts!

Better number formats ๐Ÿงพ




$1,342.11 looks a lot better than 1342.11 - am I right?!

We've improved formatting by:

  • Applying custom formatting to big number and tables tiles
  • Applying custom formatting to chart tooltips
  • Adding comma separators all over the app
  • Right aligning numbers in all tables ๐Ÿ™๐Ÿฝ

Now get out there and start customising numbers with the round and format tags.

Searching your charts ๐Ÿ’ฌ




Type words. See charts. We've added a new search bar to make it much easier to find relevant charts in Lightdash.

You'll thank us next time you're in an exec meeting and everyone turns to youโ€ฆ "show us the numbers" ๐Ÿ‘”

Screenshot 2022-05-06 at 09.12.21.png

Calculate running totals ๐Ÿงฎ




Running totals and all your favourite vanity metrics are now possible using table calculations in the Lightdash UI

Katie's started a library of Table Calculation SQL Templates including how to calculate:

  • % of total
  • % of previous value
  • % change over period
  • Row rank
  • Running totals

To create your own table calculation, just hit "+ Table calculation"

Screenshot 2022-05-06 at 08.57.09.png

Compile your project faster ๐ŸŽ




Compiling and loading your dbt project into Lightdash is faster than ever. How can you trust us you ask? Well Lightdash also tells you how long you've been waiting.

We've got many more improvements coming to refresh times, so keep an eye on that stopwatch ๐Ÿ‘€


Who broke my dashboard? ๐Ÿฅธ




See who last edited your dashboard. Charts and dashboards now show when the chart was updated and the person that most recently updated it.

Just try not to be too mean when you blame somebody for that broken dashboard.

Screenshot 2022-04-22 at 16.52.33.png

Improved field search ๐Ÿ”Ž




Finding the right field in a big explore just got easier. We fixed a bug so that search results bring relevant fields right to the top of the sidebar.

Now you just need to come up with sensible field names ๐Ÿ˜‰

Apr-22-2022 16-57-42.gif

Duplicate charts and dashboards




Stand on the shoulders of giants! Now you can take somebody else's chart or dashboard and duplicate it. It's always better to start with something rather than nothing

Screenshot 2022-04-19 at 15.21.34.png

New formatting options ๐Ÿค‘




Format dimensions and metrics with currencies, percentages, and more.

One of our most requested features was to represent numbers such as $1.23 or 73.5%, this is now possible using the new round and format options in your metric definitions.

Try adding format and round to your metrics or check the docs for even more options.

    type: sum
    format: usd
    round: 2

The new format will render on charts, dashboards, in tables, and on axes labels. And it just looks so good!