Skip to main content
All CollectionsGetting Started
πŸ†• Astrato Release Notes
πŸ†• Astrato Release Notes

Feature releases & customer facing improvements for Astrato

Piers Batchelor avatar
Written by Piers Batchelor
Updated yesterday

Release Index

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

2.79 - 18 July 2024

Stored Procedure Action Blocks For Big Query

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:

  • Loading relevant external data on the fly and combining it with internal data to uncover new insights.

  • Write back data and then call on AI models to analyze and store the new data.

  • Refreshing data when a stored procedure is needed

Writeback For Big Query

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

  1. Improved data accuracy and timeliness:

    • Users can correct errors or update information in real-time

    • Reduces lag between insight discovery and data updates

  2. Enhanced user engagement:

    • Transforms passive data consumption into active interaction

    • Increases user investment in data quality and analysis outcomes

  3. Streamlined workflows:

    • Eliminates the need to switch between analytics and data entry systems

    • Reduces data transfer errors and inefficiencies

  4. Faster decision-making:

    • Enables immediate action based on insights

    • Supports agile business processes and rapid response to market changes

  5. Collaborative analysis:

    • Facilitates team input and shared decision-making

    • Allows for the capture of diverse perspectives and expertise

2.78 - 11 July 2024

Bookmarks Object

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.

Date Action Blocks

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.

Example: Select the date range and update the drill-through dimension

Map- Zoomed Controlled Layer Display.

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.

Labeling enhancements: Backdrop

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.

Variable Support: Axis Bands

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

Data-view Manage Access

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.

Group Container Properties

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.

Advanced Calculation- Accumulated Growth

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.

2.77.1 - 26 June 2024

πŸ†• Shape (Polygon) Layer in The Map Object

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

Key use cases include:

  • Market analysis

  • Site selection

  • Risk assessment

  • Customer segmentation

  • Competitive analysis

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.

2.77 - 24 June 2024

πŸ†• Centralized Access Control

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

  • A user can ask for access to the underlined data-view of workbooks that he tries to open with a few simple mouse clicks.

  • Centralized access requests management and alerts for requests for Astrato tenant admins.

    Easily approve or reject requests.

  • Grant access to either Astrato roles, Groups, or Specific users.
    The same dialog is used to manage access to all assets.

  • Please note that all new assets are created with access granted only to the asset creator and the tenant admins.

Convert the Selected Range of Values to Individual Values

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.

2.76.1 - 4 June 2024

πŸ†• Fetch dimension action block

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.

Report parameters and improvements

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.

2.76 - 29 May 2024

πŸ†• Mini Chart Scroll In Line Chart

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 Chart Vertical Display

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.

2.75.2 - 21 May 2024

Top N Sorting

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.

Improved Date Picker

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.

Improved Vertical Line

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.

2.75.1 - 16 May 2024

πŸ†• Drill-through Actions

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

  • Multidimensional Insights: Users can gain insights from multiple dimensions and perspectives, starting from broad overviews to in-depth details and related contextual information.

  • Increased Flexibility: These functionalities provide the flexibility to navigate data in a way that aligns with specific analytical needs, improving the efficiency and effectiveness of the data analysis process.

  • Scalable Analysis: They support scalable analysis, accommodating both high-level executives who need summary views and analysts who require detailed data exploration.

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.

  • - This trigger can run a set of actions when the active field in a drill-through dimension is changed.
    For example, update a custom label with the active field name, navigate to another sheet, show and hide charts, etc.

  • - This action gets the active field in a drill-through dimension; the field is represented in this format: Table Name.Field Name

  • - This action sets a new active field in the drill-through dimension. When used with the a get variable action, the input can be static by selecting a value from the dropdown menu or dynamic by using a variable.

  • - This action changes the active field of a drill-through dimension to the next field in the list.
    This action won't have any effect when the active field is the last field in the dimension.
    It's useful when building drill-down charts

  • - This action changes the active field of a drill-through dimension to the previous field in the list.
    This action won't have any effect when the active field is the first field in the dimension.
    It's useful when building drill-down charts.

2.75 - 10 May 2024

πŸ†• Cumulative Waterfall Chart

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:

  1. Budget Allocation: Waterfall charts can be used to track budget allocations for a project, showing how funds are distributed across different categories, such as labor, materials, equipment, and overhead costs.

  2. Sales Performance: Waterfall charts can illustrate changes in sales revenue over time or across different products or regions, showing the contributions from factors such as price changes, volume changes, discounts, and returns.

  3. Cost Breakdown: Waterfall charts can break down total costs into individual components, showing how each cost item contributes to the overall cost structure.

Dynamic Custom Labels in Visualizations

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:

  • The dimension label changes according to the active field in a drill-through dimension.

  • The dimensions label indicates a filter that is applied in the chart.

  • The measure label indicates the time period of the measure; for example, instead of current year-to-date, it is 2024 year-to-date, and it changes dynamically when a year changes.

New Default Display for Text Object

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.

Input Box Deprecatation

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.

2.73.1 - 29 Apr 2024

πŸ†• Axis scroll support for Dot plot, Bar-, Combo- and Line chart

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.

2.73 - 17 Apr 2024

πŸ†• Top N Analytics

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:

  1. Top 10 Best-Selling Products: This would refer to the 10 products that have sold the most units over a certain period.

  2. Top 5 Most Visited Pages on a Website: This would indicate the five pages that receive the most traffic.

  3. Top 3 Regions in Sales: This might identify the three geographic regions that contribute the most to a company's sales revenue.

  4. Top 20% of Customers: This could be used to describe the customers who are responsible for the top 20% of a company's sales or profits, a principle also known as the Pareto principle or the 80/20 rule.

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.

Exporting from embeds

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

2.71 - 4 Apr 2024

πŸ†• Pivot Table in Custom Report

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.

Dimensions and Measures Groups in Custom Report.

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.

πŸ†• Stored Procedure Action Blocks

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:

  • Loading relevant external data on the fly and combining it with internal data to uncover new insights.

  • Write back data and then call on AI models to analyze and store the new data.

  • Refreshing data when a stored procedure is needed

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

2.70 - 27 Mar 2024

AI Insight Object Support More Visualizations

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.

New Actions

  • Exit Sheet - define a list of actions to be performed when leaving a specific sheet.

  • In data apps and writeback it's important to separate if a value have changed or not. To help with that we are releasing new action blocks to help with that task.

    • Null - Use to writeback Null value

    • Empty to Null - Convert empty values to Null

    • Null to default - Outputs value unless it's Null, then it outputs the default input value

  • Cast string to number - convert strings to numbers ​

  • Get\Set Sheets Property - get a sheet property or change it via actions, current available properties: Visibility and Title

2.69 - 25 Mar 2024

πŸ†• Dot Plot chart

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

Save Tables Layout

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.


2.68.18a - 19 Mar 2024

πŸ†• Map Visualization: Heat map Layer

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

2.68.18 - 12 Mar 2024

Advanced calculations: Enhanced user experience and description

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!

πŸ†• Smart data labels for the scatter and line chart

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!

πŸ†• Searching in Filters

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.

πŸ†• New user role: Designer

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.

ℹ️ The new designer role can be accessed from the admin section

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.

πŸ†• Bookmarks: Introducing the Enhanced Bookmarks Panel

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:

  • When adding or editing a bookmark, simply use the "Folder" field to specify the folder where you'd like to place the bookmark.

  • To create a subfolder within a folder, use the "/" symbol. For example, entering "Work/Projects" in the Folder field will create a "Projects" subfolder under "Work".

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

2.66 - 22 Feb 2024

πŸ†• Advanced Chart Calculation

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.

Improved Variable Panel

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

  • Filter to a specific variable type.

  • Improved variable search.

  • New filter creation improved the experience.

2.65 - 16 Feb 2024

πŸ†• Frame Properties Panel

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 in all visualizations

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.

Copy Actions Between Workbooks

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

2.64.1 - 14 Feb 2024

Quick rename object

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

Action blocks updates

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

β„Ή Changes & Deprecations for Action blocks

Some blocks (get/set variable, write-back, execute sql, call stored procedure, open report) have been deprecated as of February 2024, these will need to be replaced by the new blocks with new capabilities, by April 2024.

How to update deprecated blocks

  1. Add the new version of the block to the action workspace

  2. Configure it the same as the block to be updated

  3. Move the new block above the deprecated block in the block chain

  4. Remove the deprecated block

  5. Repeat for all deprecated blocks

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.

2.63.1 - 07 Feb 2024

πŸ†• Sankey Chart

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:

  • Energy Flow Diagrams

  • Material Flow Analysis

  • Cost Allocation Diagrams

  • Supply Chain and Logistics

  • Website Traffic Flow

  • Population Migration

  • Carbon Footprint Analysis

β„Ή Changes & Deprecations for Action blocks

Some blocks (used to get/set object properties) have been deprecated as of February 2024 (initial release 13th March 2023), these will need to be updated to the new blocks defined in the article below, by April 2024.

πŸ†• Access removed workbooks

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.

  • When restoring a workbook, previous embed links will need to be re-created

  • If the data view is removed, recovery of the workbook will not be possible.

  • If a report was scheduled on a workbook that has later been removed, it will fail


2.62.7 - 05 Feb 2024

Workbook Editor: Reference lines variable input

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.

2.60 - 25 Jan 2024

Workbook Editor: Object/Layer naming

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.

  • New Naming System: Objects will have unique default names (e.g., "Filter1," "Filter2").

  • Distinct Naming Rule: Objects can be renamed to the same name, however these will be made unique, by the system adding a unique number at the end.

  • Copying Objects: Duplicated objects will receive additional numbers at the end to make the name

  • You will notice: Automatic update to all object names for seamless transition - nothing for you to do.

Embedded Analytics: Embed Expiration and Description

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.

πŸ†• Map Object

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

πŸ†• Waterfall Chart

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

  • Analyzing financial statements

  • Budget usage tracking

Workbook Import/Export: Add from Gallery

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

Please note: Import and export options are now available to users in the lobby. This exports workbook properties, field names and some queries. No data connection details, or data from the CDW, will be exported.

2.59 - 19 Jan 2024

Transfer ownership of Astrato Workspace/Tenant

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

2.58.3 - 15 Jan 2024

πŸ†• Conditional Measure

  • Conditional measures allow for checking a condition fulfillment on aggregated values.

  • Some use cases for this new type of measure are comparing actual to target on category level when targets are set at the product level.
    Compared to values that are stored in different tables

  • Creating and editing Conditional measures is simple and intuitive and is done with a no-code wizard that guides users through editing and building a measure.

  • For more information check out this article.

πŸ†• Parameters in Measures

  • Parameters in measures convert measure to a dynamic calculation that end-users can change, either by actions or input controls.

  • Parameters in measure enable these use cases: what-if scenarios, multi-currency display, and dynamic range periods. comparison, compare individual entities to the whole population average, and more.

  • Creating and working with parameters in measures is done with a complete no-code experience.

  • For more information check out this article.

2.58 - 12 Jan 2024

πŸ†• Word cloud Vizualization

  • Word-cloud visualization is good for showing the whole data points and highlighting the most important data point

    Some use cases for Word cloud are the most common words in social media analytics,
    Search results for products.

  • Astrato's Word cloud is simple to build and modify.

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

2.55 - 03 Jan 2024

Embedded analytics: Loader animation

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

2.54 - 18 Dec 2023

New Data Selection Panel - Semantic View

  • The new select panel works 50% faster than the previous one.

  • Select tables quicker.

  • Support any number of schemas and tables.

Bug Fixes

  • Table Limit: setting a table limit in the properties panel is now reflected in the table.
    (This setting is only recommended to be used when using a straight table)

  • Global filters support in combination with "Full Outer Join":
    Global filters are now applied to visualizations that have the show all from a dimension activated.

2.53 - 15 Dec 2023

Actions: Fetch Dimension

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 reporting

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.

  • Generate reports in Astrato, on-demand

  • Schedule emailed PDF reports for on-the-go analytics

2.52 - 11 Dec 2023

Measure Axis Brushing and Filtering

  • Filter your data by defining a range on the measuring axis and answering business questions like focusing on customers with less than three orders.

  • Supported only on Bar Chart, Combo Chart, and Line Chart.

Change the data-view for a workbook

  • Changing the data-view for a workbook to move from different environments, for example, from Development to Production.

  • Get the summary of the difference between the source and target data-views, including measures, dimensions, fields, and tables.

Bug Fixes

  • Duplicating a published workbook resulted in errors in visualizations.

  • Show the impact of global filtering in a chart when the ignore global filtering is disabled.

2.51 - 05 Dec 2023

Change the data connection for a data-view

  • Changing the data connection for a data-view to move from different environments, for example, from Development to Production.

  • Get a different summary if there are missing fields in the Target environment.

Bug Fixes

  • Weekday in dynamic range filters.

  • Deletion of a media gallery object doesn't sync with reference objects.

2.49 - 21 Nov 2023

Workbook Objects: Pivot Table - Improved row expand, reordering

  • Dragging and reordering: Reordering dimensions apply for both Pivot and expandable table, using the chips in the table

  • Expand and collapse: now improved for pivot and expandable table

  • Auto column width: Cells in the pivot fit to screen as best as possible. Scrolling is used where necessary, depending on the min width set.

Workbook Objects: Custom report - data sets

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:

  • Defer layout settings have been moved to the data sets, instead of the previous global setting.

  • Other properties have changed placement, and we added the ability to change the Font and font style.

  • Dimensions and measures can be used in different data sets.

AI Insights: Analyze whole dashboard

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

Workbook: AI Title Generation

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.

User management: Groups

Groups can be used for managing access to:

  • Data Connections

  • Workbook Collections

Enterprise Authentication: Azure SCIM

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

Data View Editor: Semantic layer Static Filters

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.

Data View Editor: Field Comparison Filter

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

Answer a broader range of data questions such as:

  • Show sales only when sale price is lower than list price - to identify lagging products.

  • Show orders only is delivered date is earlier or equal promised date - find service level


Actions: Lists & loops

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

2.48.6 - 7 Nov 2023

Actions: Get/Set [Category] - Set object properties

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

  • titles (title, subtitle, footer)

  • position

  • margin

  • padding

  • border (type, width)

Export/Printing: Performance improvement

πŸš€ Printed exports are now produced faster, across all file types (image and PDF).

Viz-1.16 - 24 Oct 2023

Workbook: Slider control

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.

Workbook: Pivot Tables expansion

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

Workbook: Pivot Tables column sizing

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.

Workbook: Data objects export limit

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.

Workbook: Tooltips for Table/Pivot/Expandable Tables

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

2.46 - 5 October 2023

Workbook: Performance boost - published workbooks πŸš€βš‘

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.

Workbook: Introducing Design-first approach, with manual data

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.

  • 🎨 DESIGN FIRST | Prototype dashboards before connecting live data. Agile, over waterfall dashboard development.

  • πŸ‘¨β€πŸ³ BLEND DATA | Blend live data from the cloud, with data from static sources

  • πŸ“š DATA STORIES | Effortless storytelling with infographics

Viz-1.151 - 22 Sep 2023

Workbook: Introducing Astrato Insights

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.

β„Ή Insights can be enabled/disabled by your Astrato admin in system settings. Learn more here.

Viz-1.15 - 15 Sep 2023

Workbook: Filtering enhancements

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).

2.44 - 29 Aug 2023

DVE & Workbook: Drill-Through Dimension

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.

DVE: Filter in Row-level measures

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

Workbook: Change Dataview

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.

Viz-1.14 - 29 Aug 2023

Workbook: Line chart conditional coloring

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

Workbook: Number object titles

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

Viz-1.13 - 21 Aug 2023

Workbook: New format and settings for table progress bars

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.

Workbook: Filter bar - limit fields available to filter on

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.


2.43 - 16 Aug 2023

Databricks: New data connection available

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.

DVE: Width buckets

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.

Administration: Table improvements

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

2.42 - 31 July 2023

DVE: Layout Improvements

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

Workbooks and Collections: List View

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

2.41 - 01 Aug 2023

Workbook: Reduce initial load time (Performance boost)

πŸš€ 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.

Workbook: Result filters

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.

Workbook: Improvements to guidance on Group Property Panels

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

Data view editor: Filter bucketing dimension in the Data Explorer

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.

Workbook - Export to PDF\Image includes theme settings

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

Authentication: Direct Login link for SSO

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

Viz-1.11 - 27 July 2023

Workbook: Date picker quick-select

Workbook: Duplicating measures

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.

Workbook: Pivot horizontal paging

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

Workbook: Hide Table header row

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.

Workbook: Table fixed row height option

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.

Workbook: Pivot/Expandable Tables - update subtotal font format to bold

2.41 - 19 July 2023

DVE: Support for "OR" in measures filters

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.

DVE: New Style Sidebar in The DVE

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

2.40 - 05 July 2023

DVE: Control when to view join suggestions

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.

Lobby: View your Workbooks as a list or as tiles

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.

Viz-1.10 - 22 June 2023

Workbook Editor: Graphics - Variable support for text and images

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.

πŸ’‘ This enabled dynamic guided analytics workflows and Data Apps use cases, re-use the same object, allow text & images to change whilst navigating your data.

Workbook Editor: Controls - Text Area element for line breaks and long-form text in Variables

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.

Workbook Editor: Controls - Toggle and Checkbox elements for Boolean variables

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.

Workbook Editor: Theme support & updated object default styles

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.

πŸ’‘ Use themes to synchronise your brand styles across multiple workbooks. Design once and repeat.

Workbook Editor: Date picker expanded mode

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.

2.39 - 22 June 2023

Visuals: show data tips when a chart measure or dimensions displays an unexpected null result.

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.

Administration: Updating Demo data to view the new Astrato Tutorial workbook

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.

Data: Updating time-limited PATs quickly for Dremio data connections

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.

Viz-1.9 - 02 June 2023

Workbook Editor: Table - slide the toggle to show totals of all measures in your table

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.

Workbook Editor: Visuals - Create Custom Measures from the workbook

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.

2.38 - 02 June 2023

Data Connection: Amazon Red Shift

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

DVE: Manage dimensions and measures directly in the data selection pane.

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.

Actions: Replace filters

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.

Actions: Export Objects and Sheets

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.

Actions: Clear Filters in Dimensions/Fields

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.

Did this answer your question?