With our AQL (Analytics Query Language), building complex metrics is easier, but it can still take a few steps to create, test, and refine an AQL field.
We get itโthat's why we created a new AQL editor that lets you build metrics directly from the Reporting page. Weโve also added some handy tweaks like better code suggestions, field searching, and improved error handling.
With the new AQL editor, you can also promote your metrics from Visualization settings to your Dataset code, and reuse them anytime, anywhere.
Another small improvement, but guaranteed to make your exploration experience much more pleasant: Now, you can easily reverse the stack order with just a click of the "Reverse Stack" toggle.
Aggregate Awareness optimizes query performance by automatically using the right pre-aggregates (transformed by tools like dbt, Airflow, or BI like Holistics, etc.), avoiding the need to always query the raw data.
With Canvas Dashboard, you can build the most visually stunning dashboard in the world, but no one will know if every dashboard visit is a game of โspin the loading wheelโ.
Dashboards should be both fast and beautiful, we get it, so weโve brought Job Monitoring and Job Performance Analytics to Canvas Dashboards.
Now you can spot the slowest reports in your workspace, see which Canvas dashboards are dragging their feet, check if your Holistics Job Workers are overwhelmed, and make necessary optimizations to ensure your dashboards are fast enough to actually be admired.
Tired of scrolling to check if your filters are mapped to the right reportโs fields? Weโve got your back! Weโve added a nifty count indicator to show you at a glance how many reports are mapped.
Weโve made another round of improvements to how fast dashboards open in Holistics. Now, from the moment you click a link until all the widgets pop up (minus the result data), everything moves quicker.
If you're into the nitty-gritty details of the optimizations weโve made, check out this community post.
Now you can pin important dashboards to everyone's homepage. A small feature but it makes everyone's life a lot simpler. No more digging through layers of menus or searching endlessly!
P/s: This is especially handy when your boss wants to rub it in everyone's face that revenue is tanking, and everyone needs to work ridiculously harder.
Just rename your Revenue dashboard to 'The Ship is Sinking' and pin it to the homepage for maximum impact!