ℹ️ For support, click on the icon on the bottom right. See historical releases

24 July 2024 | 18_July_2024 |11 July 2024 | 26 June 2024 | 24 June 2024 | 4 June 2024 | 29 May 2024 | 21 May 2024 | 16 May 2024 | 10 May 2024 | 29 Apr 2024 | 17 Apr 2024 | 4 Apr 2024 | 27 Mar 2024 | 25 Mar 2024 | 19 Mar 2024 | 12 Mar 2024 | 22 Feb 2024 | 16 Feb 2024 | 14 Feb 2024 | 07 Feb 2024 | 05 Feb 2024 | 25 Jan 2024 | 19 Jan 2024 | 15 Jan 2024 | 12 Jan 2024 | 03 Jan 2024 | 18 Dec 2023 | 15 Dec 2023 | 11 Dec 2023 | 05 Dec 2023 | 21 Nov 2023

More calculations to support self-service analytics, Easily create measure the shows advanced calculations such as:

For measures aggregations that support string values (listagg, max, min, any_value), we now support the use of strings in conditional coloring.

No more broken images - add a fallback URL to specify the next best image when there is one missing (or no longer valid).

Astrato's Data apps just became even more powerful with the addition of a stored procedure action block.

Using this action opens up new use cases:

Adding writeback functionality to a data analytics app provides several significant benefits,
to name a few:

Bookmarks speed the time for insight for users by saving commonly used filters and reports.

The new bookmark object makes the bookmark list more accessible, allowing users to save their preferred display and share it with others.

Actions enable creators to build guided analytics data apps for end-users, automating users' data exploration and insights.
The new actions enable date actions such as range selection and finding the latest data available; using these actions to build time makes data exploration simpler and faster.

Changing dynamically the levels of details presented in a Map object enhances the user's natural way of thinking and focusing on data insights.
As the user zooms in to an area of interest, the level of display changes, and new and more detailed insights can be uncovered.

More charts now contain label backdrops, improving label visibility and association with the related data point.

Label backdrops are available on the following charts: 🆕 Bar, Scatter, Line.

Benchmarking just became effortless! Use axis bands to create a richer data-driven experience and get instant visual feedback when updating targets and benchmarks.

Manage the level of access of different users to a data-view (semantic model)
Control who can contribute and consume the data in the model to supply end users with analytics-ready data and simplify Self-Service analytics.

The pixel-perfect dashboard design has just become simple with the new group properties. These settings will enhance builders' control of group design and reduce the number of objects needed to design dashboards. Groups now have new properties that allow setting a background, border, and other properties to the group.

Accumulated growth uncovers insight on a larger set of inputs and reduces the impact of outliers to expose changes in growth trends in important measures.

Creating a measure for accumulated growth usually requires good knowledge of SQL writing, but in Astrato, it requires only a few mouse clicks.

Polygon maps are valuable tools for visualizing and analyzing geographical data across various business applications.

Key use cases include:

These applications allow businesses to transform complex spatial data into actionable insights, supporting more informed decision-making by revealing patterns, trends, and relationships tied to specific geographic areas.

A new centralized access control for data connections, data-views, and collections.
The new access control service includes these features:

A new and easy way to select a range of numeric values or dates and focus on existing values inside a range.
With this new feature, data exploration is simpler and faster, and dashboards are cleaner with fewer static filter objects on the screen and more exploration options for users.

Have you ever wanted to create an animated chart? With the new fetch dimension block it's easy to fetch all possible/selected/not selected values from a field. The output of the block can be used in loops or for advanced filter use cases or creating cyclic reports to name a few.

Reports now support up to 250 pages with high resolution with a DPI factor 2 for crisp, printable reports.

With the addition of parameters you can now reuse the same report in different schedules. Add string, number or boolean parameters to your report definition block and those becomes available in the scheduler or the Send and Open report blocks.

Send report and open report blocks have options to use a custom filename, leave blank for the default, name of the report with a timestamp at the end.

Send report block have options for the Email body and supports the PDF to be encrypted with an optional password.

By incorporating mini charts with scroll bars, you ensure that your visualizations remain clear, navigable, and insightful even when dealing with extensive dimension values.

Combo charts are valuable assets in data analytics. They provide a versatile and powerful way to combine different data visualizations.

They enable deeper insights, efficient data presentation, and enhanced storytelling, making them an essential tool for analysts and decision-makers.

With this new setting, you can display a combo chart vertically to make ranking charts easier to read.

Showing the Others record using the TopN feature helps users see the full data context. They can see the significance of the entities' tail ends.

With this new setting, you can set the other record sorting position.

The new version of the Date Picker allows users to navigate between years and months using the new controls easily.
Focusing on a certain range of dates is now simple and easy.

The new line shape has a setting for a vertical line; this new setting fits the line to the vertical space while disregarding the width of the shape.
This new option will improve the design of data stories and guided analytics dashboards.

drill-down and drill-through functionalities provide a comprehensive framework for data analysis:

With the five new actions, building different use cases of drill-through and drill-down with a complete no-code experience is simple and easy.

The new waterfall chart covers the use cases when there is a need to visualize individual entities' contribution to a KPI's overall results, for example:

Custom Labels for dimensions and measures allow the label to change dynamically according to users' interactions in an app.
Common use case for custom labels:

A new design option to control the display of long texts allows you to opt for an ellipsis mode and define a static number of rows for the text display.
Or opt for a responsive display that automatically adapts the text size and number of rows.

Ellipsis mode is the default option for all new text objects.

The Input Box (the first version of the input form) will be deprecated from this version forward.
Instead, multiple Atomic Input objects replace the input box.
All existing input boxes will continue to work; there will be no option to create new input boxes.

With this new option to limit the visible domain and add a scroll bar to the Dot plot, Bar-, Combo- and Line chart, the chart can tell a more focused and detailed story without losing the context of the entire dataset.

Bar chart example with scroll bar.

In analytics, the term "Top N" refers to the highest-ranking or performing items in a given set according to some measurable criteria. "N" stands for a numerical value that you specify when you want to limit your analysis to a certain number of top items. This is commonly used in business intelligence and data analysis to identify and focus on the most significant data points out of a larger dataset.
For instance, here are a few examples of how "Top N" might be used:

The "Top N" analysis is useful for prioritizing actions, allocating resources, or focusing on areas that have the most significant impact on the overall performance of a business or system. It’s also a common feature in reporting and data visualization tools, where you can dynamically filter dashboards or reports to display only the top performers based on the selected metric.

Embed now support exporting data and images/PDF via the context menu! 🥳

ℹ️ to enable export on existing embeds, please see our support article for more guidance

Pivot tables are among the most powerful data exploration tools, enabling users to slice and dice through data and uncover insights.

Introducing the pivot table into the custom report now enables users to easily add and replace dimensions and measure through their exploration, taking data exploration to the next level.

Measures and dimension groups in the custom report assist end-users in finding the relevant dimensions and measures to their business questions, speeding up and making data exploration more efficient and simple.
​

Astrato's Data apps just became even more powerful with the addition of a stored procedure action block.

Using this action opens up new use cases:

There are many more use cases to take advantage of this new feature.

The AI Inisigts objects now support these types of visualizations:
Sankey, Dot Plot, Word Cloud, Waterfall.
Using AI insights helps users uncover hidden insights in the above visualizations. It can also increase users' data literacy by training them to read the above types of visualizations.

Our new dot plot visualization is great for uncovering high-level and detailed insights in one chart.
The dot plot supports these use cases:

Compare the distribution of users by age and gender for products, showing the overall distributions and the individual user value for all of your users.
​ Read the documentation

Tables layout in the semantic view can be saved and retrieved.

So whether you prefer star schema or tree, you can arrange the tables in your preferred way.

​

Our new heat map layer is here, as our 4th map layer - extending geospatial analytics. Our heat map is highgly customisable, enabling color customisation, multiple ways to adjust scale and intensity to match the meaning of your data, creating a familiar map experience for all of your users. Read the documentation

Advanced calculations now have descriptions in tooltips for each component, making familiarisation effortless. We've renamed a couple of components to make it easier for you. Thank you all for the early feedback!

Enhanced labeling has arrived at the line and scatter chart 🙌

We all know we can't label every data point, otherwise we'd not be able a thing, they'd all overlap! We've introduced super smart labels that will never overlap. Understand the shape and scale of your data at a glance with our smart labels without relying on aligning with axes, gridlines, or tooltips. - great for scheduled reporting!

We have a new unified approach to searching across various elements, including tables, schemas, data views, workbooks, connections, and user information. This functionality spans both frontend and backend operations, facilitating efficient navigation and data manipulation within our system. Our search uses pushdown SQL, which runs ultrafast, super flexible and always up to date. Find exactly what you are looking for, searching from hundreds to even billions of rows.

The example below - you can try it out here on our gallery by adding a new filter. Condition Description

To learn more about searching in filters, check this article.

Ideal for citizen developers, our new designer role offers access to create and edit workbooks without the ability to manage data connections and views.

Let your creativity flow, working on unchanging governed data, using already created dimensions and measures.

Gartner: A citizen developer is an employee who creates application capabilities for consumption by themselves or others, using tools that are not actively forbidden by IT or business units. A citizen developer is a persona, not a title or targeted role. They report to a business unit or function other than IT.

We're excited to announce a significant update to our bookmarks feature! With the new Bookmarks Panel, users now have the ability to organise their bookmarks more efficiently using a folder structure.

Creating and Organizing Bookmarks:

This update is designed to make bookmark management more intuitive and structured, allowing you to navigate your saved sites with ease.

in-chart 📊 advanced calculations in your analytics:
📆 Period on Period (# or %) for comparative analytics.
📈 Moving Averages for powerful trend analysis, filtering out the noise in the data
📶 Running/Accumulating Total - transform monthly sales into a visible YTD total visualization.
Implemented with just a click in the UI by any business user: no scripting Astrato writes the SQL for you.

To learn more about advanced Chart calculation, check out this article.
​

The experience working with variables just got so much better. Enhancements include:

The new frame properties panel consolidates all the common properties of visualization in one place, making it easier and quicker to customize the visualization display, including new properties such as precision size and position.

To learn more about the frame properties panel, check out this article.

Titles and subtitles are important parts of the story a visualization tells.
With the frame properties panel's introduction, all visualizations in Astrato now support titles and subtitles.

Action blocks can now be copied between workbooks; this new feature will speed up data app development and reduce repetitive tasks.

Double click the object or group in the layers panel to quickly rename it.

In this release we added new capabilities to lots of the action blocks, see below on what have change.

Invert block is now the Not block

The invert block has a new label Not to make action chains more readable. The Not block changes the boolean input, if the value is true to false and if the value is false to true.

Variables blocks

The get and set variable blocks now except a block that outputs a string value for the variable name input. This makes it possible to reference variables by name, to support more advanced use cases.

SQL blocks

The SQL blocks have been updated with new labels to improve readability. The schema input has been removed from the Execute SQL block.

The Execute SQL blocks now except a block that outputs a string value for the variable name input. This makes it possible to reference variables by name, to support more advanced use cases.

The Write-back block

The write-back block now except a block that outputs a string value for the Field name input. This makes it possible to reference fields by name, to support more advanced use cases. The block has also got an new distinct color to improve readability and set it apart from other blocks.

Aggregate block

The Aggregate have improved labels for better readability.

Report blocks

The Report blocks has a new distinct color to improve readability and set it apart from other blocks. The open report block have new capabilities.

Use applied filters - If set to true the current applied filters will be passed to the report when it's generated. With this Astrato now support On demand report generations and truly dynamic cyclic reporting.

Max resolution (px) - Use this setting to control the height and width of the report. Depending on the aspect ratio of the sheet, the max resolution will be applied to the height if the aspect ratio is higher than wide, or the width if the aspect ratio is wider than high. If no aspect ratio is set on the sheet, A4 Landscape will be used.

DPI factor - Use 2 to double the pixel count when the report needs to be printed on paper. This affects the size of the report and the time to generate the report.

Our new Sankey chart gives users a view of data flow between dimensions.
Sankey chart insights identify the significance of a path that connects all the dimensions in the chart.

Sankey chart common use cases are:

When a workbook is deleted, it can only be viewed in the "removed" tab of the user who originally created it. If someone other than the creator deletes the workbook, they won't see it in their "removed" tab. Additionally, if the creator has left the tenant, they won't see the deleted workbook, but if they return to the tenant before it's hard deleted, they will still be able to view it.

​

Variables can now be used to drive reference lines.

💡 Use case: Data driven reference lines

Variables in Astrato are extremely powerful, even more so when combined with actions and visualizations, enabling new ways of dynamic data storytelling. In under 60 seconds, see how we use variables as part of our own Astrato workbooks.

We have improved the workbook editor experience by making object management and identification easier. This will make identifying objects for use in Actions and Astrato AI Insights, and more, as we continue to grow the capabilities in the product.

Embeds are now even easier to manage, with expiry enabled and a description to describe each use case.

ℹ Expiry and description cna be updated at any time, including for pre-existing links.

Our new map object has layer based visuals, with support for various geo-data input types.

Our new Waterfall Chart enables many use cases for analyzing the flow from a starting measure to an end measure.
Some use cases are:

You can now add workbook directly to your workspace, from our data apps gallery.

It is now possible for owners to self-manage the transfer of ownership of an Astrato workspace to another user.

For more details on how to use a Word Cloud visualization check out this article

Loader animation added to embedded objects, sheets and workbooks. This is the existing loader animation which appears in native objects/workbooks.

Fetch dimension, reads in values from a given dimension, to help you make truly data-driven, guided analytics dashboard and data apps.

This action block loops through a given field, and filters on each value, to generate a report.

Scheduled dashboard reporting isn't just a relic of the past; it's the espresso shot in your data-driven morning. Imagine you're running a 24/7 operation. Real-time dashboards are great, but what you need is a snapshot at specific intervals to see trends, anomalies, or even the calm before the storm.

One custom report, for many use cases. Data sets introduce the option of having different sets of dimensions, measures and filters, all available in a single custom report object!

Additional information:

A whole dashboard can be easily analyzed using Insights Describe. This can also be added to the sheet using the Insights Describe object.

Simplify charting with effortless titles! We generate titles, subtitles, and footers for your charts based on the SQL query used in the visualization. Save time for analysis and deep work. Update, store, or disable titles as needed.

Groups can be used for managing access to:

You can now integrate Azure for SSO and SCIM provisioning, manage users and groups, and configure enterprise applications. True enterprise user provisioning for Astrato.

Learn more in Enabling SCIM (Active Directory) for Astrato

Set a Static filter on the source tables in your semantic view. Focus users on the relevant part of the your source data without the need to create a view. Limit the dataset size by applying filter on larger volume tables.

Compare field values directly within measures. Ideal for identifying underperforming products or service level discrepancies.

Answer a broader range of data questions such as:

​

Actions can now be repeated to iterate through lists, opening up many more use cases and reducing the number of repeated action blocks.

In our Get [Category] block we have added the ability to change object properties including:

🚀 Printed exports are now produced faster, across all file types (image and PDF).

Welcoming a new control object - the slider makes it easier than ever for you to drive interactions as an end user/viewer.

A slider can be used to update parameters that are using in custom SQL code, used in ML models, or even as part of writeback.

Pivot tables can now stay fully expanded - keeping all of your data in view, all the time.

You can now change the width of the very first column by dragging the header divider as you can with other columns. We have also added property to set the min-width of the first column.

We've added a new limiting property to the properties panel of data objects. You can now specify a row limit for the visualization as well as the data export.

Now, when users hover over a truncated value in any table, a tooltip will appear displaying the complete value.

When publishing a workbook, we have made it even leaner by loading only the resources your browser needs - super efficient.

Complex workbooks load considerably faster, with up to 4x faster load times observed on multi-sheet workbooks.

A first in BI! Users can build and design dashboards before connecting data, by by adding manual mockup data sets that create a specific desired visualization that more closely represents your use case.

Insights democratizes analytical understanding, catering to all users, whether they're builders or analytics consumers. From interpreting charts and tables to elucidating industry-specific metrics, Insights saves you hours of research while instantaneously making sense of any data.

Generative AI is supporting Astrato in transforming the landscape of analytics, enabling anyone to harness the power of data.

Keep showing the context in your visualizations, by toggling "show effect of global filters" on in the filter section (ensure "ignore global filters" is enabled first as shown below).

A new type of dimension is built from a list of fields from various tables.
The new dimension can be used in all visualization, allowing users to change the display of multiple charts in one click, making Astrato workbooks even more interactive.

Row-level measures now support filters, extending the range of measures created in Astrato no code measures dialogue.

Workbook's source dataview can be changed to another dataview.

This feature enables moving workbooks between environments and data sources.
When changing the dataview, a list will appear if there are some missing items.

Conditional coloring is now available on the line chart, when a second dimension is in use on the line chart.

Titles are now available on the number object. ℹ Make sure the object is appropriately size to display a menu

Table progress bars (available on straight table and expandable table) can now be further customized by changing position as well as using a dynamic scale, which uses the largest value to determine the top end of the scale.

When limiting filters, you can use all defined dimensions from the Data View, or select fields manually. This will limit the field offered in the filter bar, to ensure a more guided end user experience.

​

With this release we have added Databricks as a new connection option. This expands and complements the existing data source connections with a new option for users.

New type of dimension, The new dimension allows user to create a calculated dimension that groups numeric values into equal range groups.

With this new type of dimensions, user will be able to easily see insights about distributions and identify the groups to focus on.

Tables in the Administration are of Astrato now have the ability to be sorted, filtered, and change columns width to make them more readable, as part of the upgrade of this section

The button for Join suggestions is now more visible and easy to find, rather than being positioned in the top menu of the DVE

You will now see that Workbooks and Collections can be viewed as lists rather than a grid, allowing more detailed information on the screen at once

🚀 We are excited to share that we have made significant performance improvements by streamlining the initial load time for workbooks. By (1) eliminating unnecessary components per object, (2) re-using loaded resources, and (3) reducing the number of requests, you can now enjoy a faster and smoother experience.

After a result is calculated, the resultant values are then filtered. This is performed using 'HAVING' in SQL. ℹ Custom measures are not yet supported. You can now automatically filter results following a calculation, using result filters.

When a User selects a Group, instead of a blank property panel you will now receive a message reminding them that Property Panels are only available for individual items

With this update, users can now leverage bucketing dimensions to apply more precise filtering. Instead of relying solely on sliders, users can easily filter data by specific buckets, providing greater flexibility and control over data analysis.

The export of a sheet or an object now respects all theme settings.

To improve SSO set-up processes, it is now possible to view your direct SSO login link

Measures can now be easily duplicated and modified, further enabling more complex analysis, having identical measures and applying different filters to each of the measures. In the example below, we demonstrate Porsche’s average horsepower vs the average of all cars in our records. This is also represented in the SQL query.

Better performance, only loading data needed for display on screen.

The table header (row) can easily be hidden using the new toggle section, located in the style tab at the bottom of the header section.

The table now includes an option to set a fixed row height, which can be set to a pixel row height of your choosing. When this option is disabled, the default/automatic row height is chosen.

New option in measures filters to select the operator between any two filters,
And adding brackets in the filter blocks to define the right combination of filters.
This new option allows the measure to answer broader business questions.
All in an easy-to-use no-code experience.

The new sidebar of the Data screen provides users access from the left panel to all the items they've created.
This new sidebar allows users to create and edit any item while keeping the content of the data layer always visible.

The new sidebar will improve the ease and efficiency of building the Data Layer
​

The Astrato Data Engine can create join suggestions if your data enters the Define stage without any joins. Click the View Join Suggestion button on the toolbar to allow the Astrato Data Engine to generate the list of join suggestions.

From the list displayed, you can apply all joins suggestions or review them one at a time. The Joins suggestion button is always visible, so you can run the request at any time.

Please note: if the database is extensive or the data view has a lot of tables, requesting joins suggestions can take time.

Workbooks are, by default, shown as tiles with an image, but they can be viewed as a list. Click on the icons beside the Search Workbooks field to move between your workbook's tiled or list views.

Click on the column headings to sort the list by: Data Connection type, Workbook name, Description, Date created, Last opened, or Type.

In the toolbar's Graphics section, you can use the text object to enter static text or select a string from your list of Variables to the field in the properties panel.

Images can be updated using base64 and image URLs.

Using a Variable allows you to update the content in multiple sheets in your workbook with a single change. If you use an Action block to update your variable, you’ll never need to type in static text again.

Use our new Text area control with any long-form text content, and add comments, context, and procedural steps you’ve created as string Variables.

As with all our text options, you can enter plain text or a SQL query if desired. And you can combine the Text area element with Actions to create interactive dashboards and data apps.

Use toggle (show/hide or enable/disable) and checkbox elements to add interactivity to your dashboards or as part of an input form in a data app. Style format choices include outlined and filled, so they're not just a great feature; they help make your dashboards and data apps look good too.

Visualizations now support theming, including categorical color palettes, font and axis styling.

The default styles for the charts have been updated. When placing new objects on the canvas, the style has been updated to improve visual appeal.

The date picker can now be fully expanded, for instant access to selecting data and simply visualisation of dates that are present in your data.

Back to Top

Combining filters and measures as part of data analysis can occasionally result in unexpected null results. Astrato’s data tip displays a high-level description of why the query resulted in the issue. Click on the data tip to view suggested resolutions.

Please note: This feature applies to joined tables with arrows in the same direction.

A new addition to the Demo Workbooks is the option to view an Astrato Tutorial built as an Astrato workbook.

Please ask your Administrator to update the Demo data to add this new walkthrough to get started with Astrato.

You can now update your existing Dremio connection rather than deleting and adding new connections to your data source. Time-limited PATs for Dremio can be updated without breaking existing data connections.

Back to Top

Scroll down to view the Totals section and slide the toggle to the right to show the totals.

A new row displays above the data provides the totals of all the measures in your table.

Previously you could only create Custom Measures within the DVE; you can now create them within your workbook.

Click on Visuals, click Data, click Measures, and click the button Create measure.

Back to Top

In addition to Snowflake, PostgreSQL, and Dremio, you can create data connections to Amazon Redshift.

You can now view your Dimensions and Measures directly from the data selection pane in the Data View Editor (DVE). Click on the eye icon beside the list of your Dimensions or Measures to view the details. From the list that displays, click the box to select the fields to edit.

With the Apply filters block, you could always add filters to a field - however, there may be a use case where you want to toggle or clear filters for a specific field using actions.

With this release, the Replace filters block allows you to replace existing filters within a field with a new set of filters.

You can print objects, groups, or sheets directly from within an Action flow. Pair with hidden sheets to design print-optimized sheets that can be printed with the click of a button on the visible worksheet.

This action block allows you to clear filters within a dimension or field. It’s useful when you want to reset a specific field and not the entire filtering state.

Back to Top