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.

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

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.

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

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.

💡 Use themes to synchronise your brand styles across multiple workbooks. Design once and repeat.

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

A continuous axis is now available for numerical fields (integers, decimals) in addition to dates.

Select your graph on the Data tab of the Properties panel; in the Dimensions section, click the box beside Enable continuous axis.

Also added to the Filter bar, the date picker is now the default option for filtering date fields in Astrato. It can be added to a sheet as an object, found in the filter section.

Back to Top

The Split text blocks allow you to further manipulate text to be used as inputs into other blocks or as part of control statements. Examples of where the Split Text block is useful include: picking out a year from a date field or the domain name from an email address.

A user should be able to create measures that combine aggregation and row-level calculation. For example, Sum (Sales/exchange rate), and use fields from different tables.

In the data explorer, you can create an inline table and paste in data to easily create mapping and reference tables.

Please note: the number of cells is limited to 100 cells (that is, 1x100, 2x50, or 10x10).

From the License & Usage section in Administration, you can now manage a hybrid model of license seats and consumption-based for your users.

We’ve added code-based entry management to role types. With Astrato, we take the first security layer from the data source, and now you can add a second layer to manage more granular levels of controlling access.

When you add a new data connection, you can add Members from your users' list into a secure second layer, narrowing the data views that each user is presented. That is, the list of data views for each user is filtered in alignment with the improved governance.

By default, a space displays in the Navigation bar for you to add a logo. Click on it to open the Media Gallery and upload an image.

Back to Top

As part of updating the Input control options, we're adding individual (atomic) control inputs to select from. The first to be released is the updated Text Input form.

You can manipulate string variable values used with the Actions Writeback block and create interactive dashboard actions.

Back to Top

Add custom formatting for the outputs of your custom measures. Create your custom format with comma separators, decimal places, etc., in the most useful format for your team.

When you create a measure, click the Custom format button at the end of the list of format options. Enter your custom format in the field, and click Apply to save it or Cancel to enter a different format.

An Administrator can select the area of Astrato that displays after login by user role type.

An example of the use would be to have all Viewers open at the view of the list of Workbooks or Collections.

Administrators can allow users with the Creator role to upload media available to other users.

The option is available in the Administration section, under System Settings, General. Slide the toggle to the right to enable the option to allow Creators to upload shared media.

We've added a Get [Category] block with the new General section. This action block gets the current context values, including:

You could add the block in an IF statement to check if the active sheet is [Name], then perform an action.

Right-click on the Actions canvas, and select the option to Add Comment. Add a comment as a title or label for groups of Action flows, or a comment to describe your action flows.
​
The other options with the Right-click menu are: Undo, Redo, Clean up Blocks, and Delete [all] Blocks.

Back to Top

Use Quick styles for buttons; select from six template styles with font and color options.

To view the complete list of style options, scroll down the properties panel to view the options under the Default, Hover and Click sections in the properties panel.

Back to Top

Astrato’s data engine displays Joins suggestions based on checks for content pairs. If tables have been added, or table names and contents haven’t been named as well as they should, our Join quality checks now provides more detailed feedback on pairs you’ve selected to use as joins.

Drag one table on top of the other to initiate the detailed search. We search all the fields to offer you joins suggestions. The checks provide feedback with amber or green circles beside the potential joins. You can then choose the suggestion that best matches your needs.

Please note: this feature doesn’t cover situations where you want to use multiple fields to connect tables.

With the new Wait block, you can pause action execution for a set number of seconds.

This can be useful if you are waiting for your database to perform an operation based on, for example, an Execute SQL block before you can proceed with your action flow.

Use the existing Apply Filter block to enter any type of string variable that outputs a dynamically filtered outcome.

Back to Top

The option to show or hide a filter bar per sheet is a new option added to the filter options on the Properties Panel. As it applies per sheet, you can show or hide the Filter bar when you want to.
​
Click on the Filter bar to display its properties, and add a checkmark to show the Filter bar on that sheet.

Back to Top

Duplicate tables to avoid a many-to-one issue for a single table. This helps when you need to duplicate a generic dimension table (e.g., date (order date, ship date), country (customer, employee, product shipped from).

Click the context menu (three vertical dots on the table header) to view the Duplicate table option.

When creating a custom measure, click the View SQL button to view the SQL expression. We’ve also added a horizontal line as a separator between the fields of each table so it's easier to see which table a field belongs to.

You can now create a measure using only numerical values, as a calculator has been added to the DVE. There’s no need to add a field/aggregation; simply add the numeric values to create the measure directly.

Manage your data in the table without leaving the DVE using the preview of the table. You can edit field names and add custom fields without switching to a different tab.

Use the new Ternary block to have inline conditional statements for your inputs without duplicating them using IF and IF/ELSE statements.

Before:

Now:

Back to Top

Histogram visualizations provide a clearer understanding of numerical data that are part of a continuous distribution (e.g. age groups, hours in a day); helping you identify important insights that may be hidden within a single category.

Use histograms of individual categories to compare with a bar chart of the data as a whole, to improve your understanding of your data.

You’ll find all chart objects in the Visuals area of the toolbar. The Histogram chart is in the Bar chart section.

We’re constantly working to improve our data objects and visuals to help you identify key trends and patterns in your data; please join us in our Astrato community to learn more.

To help users increase query efficiency, Snowflake recently introduced a new table function, GET_QUERY_OPERATOR_STATS, which returns statistics about individual operators within a query.

Our data Query Profile Insights feature provides these insights with no coding required. Simply right-click on a chart, and scroll down to Data Query insights to view the results of checks for these common query inefficiencies: Cartesian, Union, Memory, or Pruning.

Although the Data tab in the properties panel remains the default when a new object is created, when you switch to a different object, the last tab on the properties panel you were working with now remains visible (where possible).

This should help when using the Style tab and applying changes across your charts. Now the tab you used last remains open, even when you select a different object.

The image object now supports adding images from the Gallery. You can adjust image display properties including: opacity, saturation, blur, and shadow.

Border colors can now be added to pie charts. Style tip: setting the border to white, and adjusting the width creates a virtual gap between segments in pie and donut charts to highlight segments in your chart.

Back to Top

The Gallery is a new section on the toolbar for you to upload media for use in your Workbook. The image file types allowed are JPEG, JPG and PNG. The file size maximum is 9 Mb.

From the Graphics section of the toolbar, select Image. From the frame, click Add from the Gallery. The Style tab opens with the Image and Adjust sections. Use the Image options to select the:

Use the Adjust options to add a shadow or the sliders to change the Opacity, Saturation, or Blur.

Administrator and Owner roles can view all images added to workbooks in an Astrato tenant. Also, all images uploaded directly to the Media section (e.g., company brand icons) are available as shared images from within the Gallery of all workbooks in the tenant.

All media asset management permissions (view, create, edit, and delete) can be performed from this area.

When using Astrato, the section name is visible on the browser tab, so even if you have many browser tabs open, you know which browser tab or window is the one you want.

Create action flows that write back values to your database. With the new Writeback block, select any table defined within your workbook's data view, and add the columns and values you would like to write to the database. You can add a Button click to trigger the action.

Using the Logical And / Or action block lets you perform logical operations as part of a conditional.

Use the flexibility of "and" and "or" operators to create custom automated workflows with complex conditions for your Actions.

When you create a copy of a table and change its name, we now display the name of the source table. This is visible in the Preview table header, the Edit table screen, and when you hover over a table header in the table schema or over a table name in a selected period.

From the list of your custom Measures in the DVE, click on the context menu (three dots), and click Duplicate.

Adjust the measure as required - for example, its filters, predefined dates, and operators; and save it with a new name and description for use across the workbook.

You can now apply a filter for an item that is either IN or NOT from a list.

The Layers menu has been updated to improve the clarity of icons and spacing of items displayed. You can also click on the square to dock or allow the menu to hover (1) and move around as needed.

Click the magnifying glass at the top to Search through the list of items, or click All items to sort the list (2).

Improved spacing, re-order of options, and new iconography have been added to the design of the right-click object context menus (cut, copy, paste, export, etc.).

Depending on the object, you have the option to: copy, duplicate, cut, paste, delete, lock group, arrange, show in layers, view the Data query insights, and export to CSV or XLSX.

Back to Top

We're excited to announce the release of our new range Slider object to filter values in your dashboard. Easily drag the slider's handles to select a range of values for a numeric or date field and instantly see the corresponding data filtered in your dashboard. In SQL, we select BeETWEEN.

Add the slider by navigating to the Filters section and clicking or dragging the Slider object icon onto the sheet.

Some key features of the range slider object include:

The filter bar now includes the slider by default when numerical or date fields are added.

At Astrato, we build for our customers; in this release, we’ve added three feature requests from our Community page to improve the styling possibilities of the Button control.

Some key features of the new styling settings include:

Data labels on Bar charts are now available for our Combo chart too.

Continuing our efforts to improve the ease of interacting with your data in the Data View Explorer (DVE), we've added the following:

Use the INVERT action block to invert a boolean value. This allows you to have tidier show/hide action flows, as you don’t need to create a complex IF statement to control the visibility of objects to check whether a variable is true or not; now, you can easily toggle the visibility of an object.

This becomes very powerful when combined with the new object action blocks GET and SET.

Before:

Now:

GET and SET the properties of an object's visibility using this new action block.

Previously the visibility of objects was controlled by assigning them to a boolean variable. Now you can control both the boolean value and the visibility of an object directly from an action (as in the example above).

Back to Top

We’ve redesigned the Astrato toolbar and its panel as part of customer feedback.

There's a Search field at the top when the panel expands so that you can search directly. We’ve split them into two broad categories - design, and advanced tools for analysis and interaction.

Design

Advanced tools for analysis and interaction

As part of redesigning the toolbar, we’ve added the article Using Graphics in the Workbook Editor with instructions on style, formatting, and layout for text boxes, shapes, and images.

We’ve removed the extra color band at the top of the workbook, so it looks less busy, and you have a bigger canvas to design your dashboards.

Our data engine now delivers the schema view in a clean tree structure. Tables with joins are arranged at the top. All other tables are arranged in a grid sorted by the time they were added to the data view. Tables without joins also have a lighter color to differentiate them further.

When a user applies the ‘suggested joins,’ we apply the best layout for your tables in the data view.

If you prefer to arrange your tables differently (for example, in a star with the main table in the middle), Astrato can save your arrangement.

Please note: If you remove or add tables, we can’t load your saved schema; the default schema will display.

In the data explorer, you can now filter by the values of the measures.

Clicking the filter icon at the top of the column automatically displays the range for that column. Select the values manually or use the slider to filter the data in the column.

When you have a draft workbook, the My drafts tab becomes the default tab in the Astrato lobby to access your content faster.

You now have a nearly infinite workspace provided to build your actions. The action bar also has new options including:

Back to Top

For dates and strings filters, a new combobox (Search and a list of values) has been added.

On the Object styling options, click the Filter tab, and click Chart to add a filter. You can use the Search field to find the value in the column, or select from the:

When you add a chart, filter a badge displays on the tab with a count number. If there are more than nine filters added, it shows 9+.

We’ve refined the icon to clarify what part of the object is affected by changing the number in the field. You can adjust the radius of the border/corner between 0-100.

This border option can be applied to the text, button, and filter objects. Use the following paths from the toolbar options:

Back to Top

On the Data tab, we’ve added context to display the original table and field name in both the Measures and Dimensions sections.

This information provides context when working with data across multiple tables to avoid the correct field name being added from the wrong table.

You can now select a cell in a table instead of the whole row.

A click in the cell selects it, highlighting other linked visualizations. This works in both directions, so you can more quickly and accurately select individual cells within a row.

Back to Top

We’ve added authentication support for non-Google account-linked usernames and passwords. Key benefits:

Use the SQL blocks to create string variables that bring back a value or trigger further downstream processes.

When using the Data Explorer functions in the Data View Editor, you can now export files to CSV in addition to XLSX format for download. This provides users with more flexibility to view data in multiple editors.

When using the Data View Editor's Data Explorer functions, click the View Query Insights button to view the SQL query details displayed with markup.

When using the Data Explorer functions in the Data View Editor, you can rearrange the order of your columns to make viewing the data you’re interested in easier.

Simply click on the column header you want to move and drag and drop the column to its new position.

Back to Top

Users can select across a sequential (numerical or time-based) axis to find more information. This feature applies to Bar, Line, and Combo charts.

All values on the dimension axis within the sequence are selected. This is enabled in Preview mode and on published workbooks.

Scatter charts have a new brushing method; draw a ‘lasso’ (circle) around data points to select them, or draw a line across the points you wish to select.

Our update to Filter styles allows you to apply the same formatting styles (font type, size, and background color) to all instances of the object within your workbook (or worksheet/s).

Consistent styles help create a more cohesive and visually appealing presentation of your data app. It also makes it easier to identify and distinguish different Filter objects within your workbooks quickly.

It’s also useful if you’ve used a dark background on your dashboard. It’s part of our commitment to helping you make beautiful dashboards.

Highlight specific cells or rows based on values present in the data. Table conditional coloring makes it easier to quickly identify your data's trends, patterns, and outliers. This can be particularly useful when working with large datasets or making sense of complex data relationships.

When you select your table object, the layout option for columns includes options for Auto-width or Fixed width and a new input box to specify the minimum width. You can change the minimum width in auto mode; the default is 70 pixels.

We've also enabled horizontal scrolling, so there's no need to set very narrow columns in your table.

In the property panel, Data tab, we’ve renamed predefined periods to “date range” and moved it to the top of the list of operators and Boolean expressions.

Back to Top

We’ve added text operators to our list of no-code Actions options. Simply drag and drop the text blocks to build your dynamic Actions.

Block functions include:

New template option for Custom Report (self-service) in the Sheet layout options makes it quick and easy to start building your custom report.

Back to Top

Astrato's Custom Report allows your users to explore live data with confidence. This can reduce ad-hoc requests to BI and data teams and streamline report building by exploring your data warehouse directly.

It's easy to set up; add the Custom Report object on a new worksheet and allow your users to select from the predefined dimensions and measures in your workbook.

You can sort and search for embedded links as a Lobby visitor in the Embed section.

We’ve added math operators to our list of no-code Actions options. Simply drag and drop the math blocks you need and type in your variables.

We support large numbers and Snowflake number formats.

The event triggers when a Filter has been applied or is pending in a field.

Back to Top

Selecting objects is easier, and copying and pasting are possible between workbooks.

The object retains its connection to the data view, and before it’s pasted into the new workbook, we check whether the data connection is the same.

If it’s not the same, we paste the object in a preview state without the dimensions and measures from the original workbook. The rest of the object’s properties are included with the copy.

Trigger actions when a Filter is either pending or applied.

We've listed on a page the predefined periods to filter data for past and current dates. The same options are used across our Custom Measures filters, the workbook with measures, and the chart filters in the property panel.

The new design in the property panel includes icons for each data type and collapsible menus for each table section.

Administrators can add the Snowflake consumption app to their organization’s list of workbooks.

The app displays the Snowflake consumption linked to the defined Snowflake data connection when you set up the app.

Please note - All users given access to a workbook must have permission to view the data; the error message “Your data query is invalid” displays on the workbook.

Back to Top

When creating a custom measure, you can now select from predefined time ranges (e.g., YTD, Last 7 days, Previous month) when using Date as a measure. We’ve organized the list of time ranges by those generally used more often.

We've added information about Astrato's Data Engine and how it helps to avoid common BI mistakes like Fan Traps. The article also details the key features of join quality that can improve your BI outcomes.

When editing a table, text object, number object, or filter, you can apply a font style directly from the property panel. The list of fonts available in Astrato includes web-safe fonts and some Google fonts.

When editing your workbook, it's now easier to rotate, select and move objects in groups.

We've also improved the helper grid settings to include options to 'snap' objects to the grid, in addition to the helpful layout guides that show alignment and add padding (white space) between your objects.

Astrato Enterprise users can view their license consumption by minutes in addition to credit blocks.

Astrato supports data connections to Dremio Cloud.

Back to Top

We've added a new Action trigger event- 'Before workbook opens'. You can use this new trigger to apply a Navigation action, for example, to select a specific sheet within your workbook to display first.

From the Data tab, in the property panel under Columns, use the Visual representation slider to add mini charts sparklines, and bars on each table row, for a given measure. Gain extra insight without needing any more than a table.

When mini charts are added, the Style tab displays the formatting options, where you can apply styles to each of your mini charts.

If several charts are added to the table (from various measure columns) we display these options in the dropdown for the user to select.

In the Administration section, click Users to view the complete list of users. Type a user's name or email in the Search field to find them quickly.

When selecting a Date as a Dimension, you can use either the Default format or select Grouped as.

Selecting ‘Grouped as’ allows you to select from options such as ‘Month Year’ and select the format you prefer. A Custom format option is also available.

Tick the Null values box to view dates that are missing.

From the Admin options, if you use Embeds, and have permission to view them, there are detailed sorting and searching options to help you manage your Embedded links.

The options are: Created by, Date, Name, Permission type, Requirements, Sort, Specific user, Type (Object, group, sheet), Workbook name, and Workbook used.

Back to Top

License and Usage is the new section for Enterprise-level customers to organize their users and assign them to teams, with each team assigned the most appropriate licensing model.

Consumption-based licensing usage is measured using credits that are monitored per user and by a team.

The Administration area allows Owners and Administrators to change the license type, create teams, and view and allocate the credits to a user or a team.

Explore the new License & Usage page here (requires Admin access).

The options for managing Users and Teams are visible in the Administration area of Astrato.

There's no need to import users into Astrato. From the sidebar, click Invite Users to add Users or Teams. When users accept their invitation and log in to Astrato, their account status changes from Pending to Active.

Please note: the User section and the list of users are visible to all user roles; however, the Teams option and the bulk of Administration functions are not.

More details about each data source are displayed when viewing your data sources. This includes:

Click here to explore your data source
​
​Back to Top

Charts can display more data points. There's no change to the Table, as it just adds more pages. Data point limits for the following charts are now:

Sort by measures or dimensions without needing to add them to the visualization. More analytical power, without the extra code.

Any filter can be added to the workbook using the add New filter button located in the filter bar. No need to clutter workbooks with dropdowns and filter boxes, explore and add easily.

We now have options in data objects to ignore the global filter state - a great way to do a comparative analysis between overall data vs a filtered dataset.

Back to Top

Use the Actions feature to add interactions and logic functions to your workbook - all without writing any code.

Simply drag and drop the actions you want to perform visual changes to your data, or add interactive actions that modify the worksheet or navigation.

Use the 'Export as' or the 'Object > Copy to clipboard' to create output that you can print from Astrato.

Legends always show on charts even if you make them very small.

Back to Top

In addition to Snowflake, and PostgreSQL Astrato supports Google BigQuery data connections.

Using the Data Explorer, quickly look at the data to confirm the quality and completeness of the dataset before you start building your visualizations.

Create the metrics that suit your business using orders of operation with multiple fields, aggregation, and filters- no coding required.

Create new column measures using this feature to extend the tables in your data source with any 'last-mile' dashboard changes - all in a no-code UI.

Create new fields using text strings, with functions such as concatenate, replace and trim to tidy your data. There are also options for date and calculation functions.

Pick a value directly from the chart filters.

Instantly create a chart (e.g. timestamp and value = month or hour, day of the week, etc.).

Highlight the chart itself. Assign color bands and name them (e.g. benchmarks).

Back to Top

The new checkbox option for ‘Continuous Axis’ in the Properties Panel offers the option to view gaps in time between data points in your temporal data. Temporal data includes dates or time formats.

In the toolbar, in the Data Objects section, a new rectangular version of the Heatmap is offered as a preset in addition to the circular preset.

Back to Top

Hovering or clicking on a value (in a table or filter) highlights the same value(s) on all the charts of your workbook.

Hovering or clicking on a value in a chart with a categorical legend highlights the same value(s) on the other visualizations in your workbook.

Back to Top

There’s no need to use extra columns or calculations with the further enhancements in date groups. For example, a heatmap can be created simply using two fields, one date field and one measure.

You can set filters in your table without adding other data objects to your workbook.

Within your table, click on a row, or use the filter dropdown to view and add or remove filter options from your table.

Major style enhancements to the existing progress bar visualization.

These can be used with progress/gauge charts. Changes include adjusting the bar radius and padding.

Back to Top

Limit custom aspect ratio - new rules define limits for aspect ratio when manually changed so that:

Back to Top

New Title options make it easier to add context to objects, with a new discrete menu for managing title content.

Improvements to the scatter chart styles and the addition of a trend line through points on the scatter chart.

For sparklines or charts where the axis is smaller, you can now show labels at the end of a line chart.

Back to Top

The filter bar visible at the top of the worksheet is now enhanced with editable fields to simplify and speed up data analysis for you and the teams you share your data with. The drop-down lists have a check mark beside the filters applied to the data object.

Select the filters you want, and a checkmark displays which filters are active on the data object.

Workbook editor ‘Sheets’ are now named ‘Layers’. This change also improves the efficiency of selecting and managing your workbook sheet layers when clicking on ‘Layers’ immediately displays the object layers for the current sheet.

New date selections offer date presets to simplify date selection for all objects. Presets include: presets quarter, day of the week, and certain holidays.

To improve performance, there is now a limit of 7 dimensions in a pivot table with any combination of Row and Column headers.

We've implemented a new approach when creating a new data connection to display a list of databases the user can access. Astrato now only performs the more extended check for writeback permissions only if the user selects to enable writeback on the data connection.

Back to Top

Beside each Measure Filter, a number displays beside the title to indicate the count of all the measures that have filters applied.

We do our best to avoid them, but now and again, we have a few to squish ...

Back to Top

Organizations using an Okta integration for Single Sign-On (SSO) with Snowflake can enable Enterprise Authentication within Astrato.

Admins don’t need to worry about creating service accounts or new accounts to build data connections to Snowflake.

The credentials are passed through authentication into Snowflake based on a role-level security setup. This means that users logged into the same Workbook see only the data appropriate for their role.

Create a custom color palette to style and color your charts to align with your brand, event, or theme.

Type a comma-separated list of the HEX codes for a maximum of 13 colors, and simply drag and drop your list of colors into the custom palette. Use the form to add two extra numbers in your HEX code to affect the opacity of each color.

To reorder the color in your custom palette, click on the double row of dots on the left, to drag and drop the color to its new position.

The object properties panel now has a Filter tab; this consolidates the options for Chart and Measures filters so that you can amend filters faster.

Each Measure filter has a plus sign (+) beside it; click the + to add more filters to an object. Select the field, operator, and value. Once completed, click the Apply button to confirm. Repeat the process with additional measure filters.

New and improved default styles make table content look better and easier to differentiate from the rest of the data by making:

Each measure in the properties panel can display or hide the measure label. If there is only one measure, the label is hidden by default. Read more about using Tables.

Back to Top

You can apply a filter (as a parameter) to the view of the source data on an embedded sheet, thereby restricting the scope of the visible data.

Use this feature to produce contextual embeds, this highlights the data that's most relevant to where you've embedded the data. Read more about Astrato Embeds.

You now have options to format the style of text objects with:

In the Data tab, within the Dimension options, use the Group as an option, with a selected format to display a combination of dimensions (for example, select 'Month Year' with just one click).

Supporting central management of your data by encouraging users to create 'data views' instead of creating duplicate copies of source data - a warning displays when a user attempts to create a duplicate data connection if they use the same:

The message offers the option to either ‘Create a data view using the existing data connections’ or 'to add the new data source’.

Within the lobby, users can now search for a specific :

Admins can now refresh the demo assets available to users, ensuring that users have the most up-to-date versions of workbooks or data views.

Now you can design your Workbooks with a:

Back to Top

A new warning message displays if a user attempts to create an exponential trendline if their data contains zero or negative values.

Features linked to using a Line Chart for linear or exponential forecasting include:

It also has the following constraints:

Please see the new page in our Data section to learn more: Advanced Analytics - Forecasting.

Astrato’s new pivot table elevates our existing table features, with more grouped dimension values that aggregate across the top and the left-hand side.

The pivot table enables users to display a dimension across the top, to create a grid-like table visualization. You can now view cross-sections of data with first and second-layer data filters.

The example shows Column data linked to Area - with Neighbourhood as the first filter, with Availability and Price per night as the second layer. Row data includes both bedrooms and bed types.

In addition, visual styles and color to display conditional formatting let you tell more than one story - without any coding or change to source data. In the example below a progress bar (based on a fixed amount) makes comparing availability easier. And the color-linked conditional formatting highlights price ranges.

Read more about Tables.

Back to Top

All Creators can generate Embed links within their data and share the link with other Astrato users in their company (that is, if they’re in the same domain).

This function for Creators does not need to be enabled by Astrato Administrators.

Increased the number of data chart points displayed;

Users can select which data points are visible within the number displayed.

Back to Top

Enable a trend line on your bar, line, or scatter chart to indicate the general course or tendency of points based on your calculations.

Updates to the data filters include:

A warning message displays for users logging in using an unsupported browser.

The list of supported browsers (Google Chrome (Desktop), Microsoft Edge (Desktop), Mozilla Firefox (Desktop)) is offered so all users understand our testing and support parameters.

Back to Top

Time Travel enables accessing historical data at any point within a defined period. Includes data that has been edited or deleted.

The Astrato Galaxy (our Community of Astrato users) is now available as a quick link once you log in to Astrato.

We’ve updated the login screens to remove the data consent request from Google.

Only Google account users must provide data consent when using Google Drive or Google Sheets as a data source from within the Data View Editor.

The Embed feature in Astrato (your Administrator must enable this feature to share Embedded links outside your company domain) lets you take content from a published workbook and embed it in other web-based material.

The content retains its interactivity and connection to the live source data meaning you have a single source of truth for your analytics wherever they’re used.

Share key live content from the business applications your team uses daily - CRM, HubSpot, Confluence, or publicly on your website or in a SaaS product.

Back to Top

Changes to animations and data points on all charts look smoother as data changes are made and refreshed.

In addition to Snowflake, and Google Sheets, Astrato now supports PostgreSQL data connections which appear as an option in the Data View Editor.

To improve the visibility of the Filters feature, it’s now just below the data objects selection.

Back to Top

Custom Data - add custom data in the data view editor using an SQL query or CSV file upload.

Sheet Object Layers - options to manage data objects from the Sheets menu.

Back to Top

Workbook Updates - updates in changes to the flow for creating and publishing a workbook (example for creating a workbook shown here).

Back to Top

Create Dimensions and Measures directly from the table - Right-click on a field and add it as a dimension or measure.

Connected Workbooks - Select from the list of workbooks already connected to a data view to open them from the data view editor.

Snowflake Manual Configuration - Now you can choose a manual configuration option to connect a Snowflake instance.

Back to Top

Workbook Editor Tooltip - Are you terrible with names? We've added tooltip to the controls in the workbook editor to help you out.

Back to Top

Workbook Editor - The header in the workbook editor now contains a link to the data view you're using to create the workbook.

Enterprise Authentication - OKTA - Astrato now supports enterprise authentication for Open ID Connect (OKTA).

Back to Top

Demo Data Assets - Astrato now contains some example published workbooks and a data connection to get you started when you first log in.

Enterprise Authentication - Google Workspace - Astrato now supports enterprise authentication for Google Workspace.

Back to Top

Bar Chart Gradient - You can now apply colors to a bar chart with a gradient shading.

Demo Data Read-Only Resources - If you're a user logging in to your workspace for the first time, you'll see some published workbooks and a data connection with example data views. We've included these examples to help you get started creating your own workbooks.

Back to Top

Reverse / Limit - The properties panel now has controls which can reverse the color scheme in your data object, and also apply limitations to the data displayed.

Templates - The templates section has been updated, with the Popular tab being d be renamed Astrato Defaults and My Templates changed to Workbook Templates.

Back to Top

Auto-Refresh - workbooks now have an auto-refresh function where you can choose your own refresh rate.

Spaghetti Joins - Adding joins in your data view just got even easier with the joins suggestions feature, which lists all the possible joins you can add, and shows the joins you've already created. Link up your data in just a few clicks.

Back to Top

Stacks of Tooltip - If you're using a stacked bar chart or line chart, you'll be able to display the total in tooltip.

Alphabetical Sorting of Joins - When you add a join, the table and field data is now shown in alphabetical order.

Preview then Review - The Preview function for a workbook now opens in a new tab, making it easy to check the workbook, then publish or return to the draft.

Back to Top

Hit the Bars - Add an extra visual touch to your bar charts by enabling the Translucent bars setting.

DVE Chat Show - If you're working with the Data View Editor and need to ask us a question, you can hit the Intercom chat button right then and there. No more going back to the lobby!

Measure for Measure - And you can now display pie chart labels as percentages if you select Measure only.

Back to Top

No Google? No problem! - As well as using your Google and LinkedIn accounts, you can create your own login and password for your Astrato account.

Keep it Strong - To make sure your details stay secure, we've also implemented conditions for password strength.

DVE Drag Race - In the Data View Editor, you can now drag the panel divider to increase the size of the left sidebar which lists your source data.

Back to Top

Coming soon! - In the toolbar, you can now see icons for objects we're working on introducing in the near future.

Movers and Shakers - The Lock and Group icons have been moved into the action bar, and the Save Template control has been moved to the context menu (open on right-click).

Get Groups Moving - You can also use drag and drop to select and group objects, move them around the sheet, or re-size them.

Back to Top

Object Resize - Resize an object in the content pane by dragging the edges in any direction. This works for bar charts, line charts, scatter charts and combo charts. Try it and see!

Custom Axis Height - Set a customized axis height for your charts in the properties panel Object settings. Choose to start at 0, and set maximum and/or minimum values for displaying objects.

Gauge Target Settings - Gauge data objects now have updated target settings, where you can choose between, automatic, manual and data options.

Back to Top

Table Word Wrap - If you’re using a table, word wrap is now automatically enabled. You can display up to 445 characters in a cell, and enable a row height limit, and choose to show a maximum number of lines. You’ll always see complete lines, no cut-off text or partial displays. If you disable word wrap, the text is truncated. Remember Pokemon? Yes, we thought you might.

Bar Chart Grouped Bar- If you’re creating a bar chart with 2 dimensions and 1 measure, you can now switch between grouped and stacked bars. You can add multiple measures as well.

Line Chart Multi-Line - If you’re building a visualization with 2 dimensions, you’re now able to use a line chart to display multiple lines, and switch between stacked and overlaying options.

Back to Top

Joins - The Data View Editor now supports full outer joins to create connected visualizations and dashboards across multiple tables for an associative analytics experience. They're defined on any field of the same type, and won't lead to loops or circular joins - we'll always take the short path.

Use the Data View Editor to edit field names.

You can now apply filters to your data visualizations that go across two tables for a true associative experience.

Back to Top

You can now use your LinkedIn account or your email address to sign up to Astrato and log in to the site.

From the Properties panel in your workbook, select the Data tab to confirm the source of the chart data. A yellow label with the words Demo data is displayed.

In the Administration settings for People, click the Invite Users button to add email addresses to generate and send Astrato user invitations.

Back to Top