# 🍊 Holistics May 2023 Product Updates **URL:** \ **Category:** Monthly Updates\ **Created:** [June 9, 2023, 10:18am UTC](https://community.holistics.io/t/holistics-may-2023-product-updates/1552 "2023-06-09T10:18:21Z")\ **Posts on this page:** 1\ **Page:** 1
**Author:** ![GusNH](https://community.holistics.io/user_avatar/community.holistics.io/gusnh/32/984_2.png) [@GusNH](https://community.holistics.io/u/GusNH)\ **Post date:** [June 9, 2023, 10:18am UTC](https://community.holistics.io/t/holistics-may-2023-product-updates/1552/1 "2023-06-09T10:18:21Z")
|Hi there, It’s Gus from the Growth Team at Holistics. Trust you’re doing well. This month, we’ve brewed some exhilarating tweaks and updates and I can’t wait to tell you about them. So without further ado, let’s dive headfirst into this buffet of analytics deliciousness! 🙂 ## Community Highlights Let’s take a glance at some interesting community posts we’ve handpicked for you: - Feature Suggestion: **[Support definition of HTML data type/format in AML](https://community2.holistics.io/t/support-definition-of-html-data-type-format-in-aml/1539)** by @SterlingParamore - Tips and hack: **[A workaround for the dashboard auto-refresh feature](https://community2.holistics.io/t/a-workaround-for-the-dashboard-auto-refresh-feature/699)** by @anthonytd ## [Beta Closed & Official Release] Timezone Settings Drum roll, please…because thrilled as we are to announce the official release of the **Organization Timezone** feature, following a successful Beta program! Thank you for sending us all your insightful comments and thoughts - and we’ve been putting those to work! We have plans to tackle other use cases, including _dashboard-level timezone settings_ and the ability to _skip timezone conversions for specific fields_. Stay tuned! For more information and detailed instructions, please refer to our public documentation: **[Timezone Settings | Holistics Docs](https://docs.holistics.io/docs/datetimes/timezones)** ![](https://community.holistics.io/uploads/default/original/1X/67296f81ed1081b6a05da7d2f5055fc7d10258f9.png) ## [Launched] Relationship Diagram for Holistics As Code The highly-requested Relationship Diagram for Holistics As-code (Holistics 4.0) is finally here. Going forward, you have the option to work with your relationships in the Diagram view beside the usual List view. _(It’s like choosing between a hearty medium-rare steak and a creamy and cheerful lemon cheesecake - having one is good, but having both is even better!)_ [https://cdn.holistics.io/product-newsletter/may23/er-view-final.mp4](https://cdn.holistics.io/product-newsletter/may23/er-view-final.mp4) ## [Coming soon] Analytics Query Language (AQL) Excited to share that we’ve been tinkering and toiling in the depth of our tech lab for our brand-new **Analytics Query Language - AQL.** With AQL, you have a more powerful and flexible way of querying data for various analytics use cases: - **Cross-model calculation** - Perform calculations across multiple models without having to merge the data via SQL Model manually. - **Nested Aggregation** - Create more complex calculations by nesting functions and aggregations within each other. - **Add filtering in an AQL Expression** - Filter your data at the query level rather than having to do it in a separate step. - **Support Date/Time Intelligence Functions** - Analyze your data over time using powerful date/time intelligence functions. And this is just the tip of the iceberg. We’re confident that AQL will make your analytics workflow smoother than a buttered penguin on an ice slide. (imagine that!) For example, with AQL, you can perform **Subgroup Calculations** flexibly and easily without having to create SQL (or transform) Models. Like this: [https://cdn.holistics.io/product-newsletter/may23/aql-demo-final.mp4](https://cdn.holistics.io/product-newsletter/may23/aql-demo-final.mp4) Here’s the sample syntax: ```auto sum(order_items.quantity) * 1.0 / eval(sum(order_items.quantity),exclude(users.age_group)) ``` If you want to join our beta, check out our official community post: **[[Upcoming] Our brand new Analytics Query Language, AQL!](https://community2.holistics.io/t/upcoming-our-brand-new-analytics-query-language-aql/1533)** Also, please share some of your use cases that would benefit from AQL. As always, we appreciate your support and feedback. 🙂 ## [Coming Soon] New Table with Improved Performance In our quest to make you an experience that’s _less “ho-hum” and more “'holy guacamole!”_ - we’re rolling out our souped-up, upgraded table feature for _better performance and vastly improved loading times._ In all of our tests, the new table exhibited superior performance in terms of rendering data, FPS (Frames Per Second), and CPU usage compared to Handson-table (you’d swear we just put your table on a diet and sent it to the Olympics!) **Here’s an example:** - Rendering table: New Table - 00:00;27 vs Old Table - 00:05;00 - Cross-filtering: New Table - 00:00;22 vs Old Table - 00:02;20 [https://cdn.holistics.io/product-newsletter/may23/new-table.mp4](https://cdn.holistics.io/product-newsletter/may23/new-table.mp4) ## [Launched] API to Update Data Source Fresh out of the oven: API for Updating Data Source!! 🥳 More details here, if this is something you’re interested in: [Data Sources API Package | Holistics Docs](https://docs.holistics.io/api/v2#tag/Data-Sources). ![](https://community.holistics.io/uploads/default/original/2X/8/8af12c1dd7da2ab6f7a427e8e30c93428ea4d176.jpeg) ## [Launched] API Package for User Management We have upgraded our Users APIs with much more power, such as _delete_, _restore_, _resend invites,_ and more! Now it’s ready for you to take the workflow automation of User Management to a whole new level! 👆 Check it out at [Users API Package | Holistics Docs](https://docs.holistics.io/api/v2#tag/Users). ![](https://community.holistics.io/uploads/default/original/2X/4/4f1fc7464de47c08fbb29581c8569995347e9c04.jpeg) ## [Coming Soon] Better Keyboard Experience Imagine running a marathon in flip-flops. It can be done - but at what cost? An efficient keyboard is like a pair of top-notch running shoes - it just makes the journey more bearable, especially when you’re sprinting through heaps of data. This is why we’ll be introducing a new array of exciting features to help you keyboard-sprinting through data - _instead of flip-flopping through it 🙂_ We’ll be rolling out the following features: - 🎨 Command Palette - 🔄 Unified Command Palette & Search experience - ⌨ [Upcoming] Keyboard Shortcuts ![](https://community.holistics.io/uploads/default/original/2X/d/d7a8b25269bd70360a83f0204103759ee92ded78.jpeg) ![](https://community.holistics.io/uploads/default/original/2X/6/64973c8cd59aad7bbbb6232a4f491107d29e0221.gif) ## May UX Updates: New flow for applying conditions, better reporting experience, and more! In May, our team delivered 10 updates to give you a more Holistic(s) experience - check it out here: [May UX Round-Up: 10 UX Updates You Might Notice](https://community2.holistics.io/t/may-ux-roundup/1543). ## A Meme A Day Keep Troubles Away "Imagine building reports for every data request in the ultra-high-resolution 23-million-pixel display. With a unique dual-chip design, every English-to-SQL job now feels less dreadful than ever. _All for just $3499!!"_ ![](https://community.holistics.io/uploads/default/original/2X/9/972aaa49750c9e6b9fac2fdd11f5fe322f25111c.png) _P/S: Holistics Monthly Product Updates are sent to all Holistics users. However, if you’re forwarded this email and want to get more updates from our Product team, [join our newsletter](https://form.jotform.com/230372117102440)_ That’s all for this month! Stay safe everyone, see you next month!