All Astrato key feature releases are listed below.
Check out the Astrato Galaxy (our community of ASTRATOnauts) to connect with as we evolve together. You can add feature requests, ask questions, participate in data challenges, and gain inspiration from fellow ASTRATOnauts.
If you need help from our Support team, please click the chat icon in the bottom right corner of your screen.
1.2 | 1.3 | 1.4 | 1.5 | 1.6 | 1.7 | 1.8 | 1.9 | 1.10 | 1.11 | 1.12.0 | 2.0 | 2.1 | 2.2 | 2.3 | 2.4 | 2.5 | 2.6 | 2.7 | 2.8 | 2.9 | 2.10 | 2.11 | 2.12 | 2.13 | 2.14 | 2.15 | 2.16 | 2.17 | 2.18 | 2.19 | 2.20 | 2.21 | 2.22 | 2.23 | 2.24 | 2.25 | 2.26 | 2.27 | 2.28
2.28 - 17 January 2023
Astrato's Custom Report allows your users to explore live data with confidence. This can reduce ad-hoc requests to BI and data teams, as well as streamline report building by exploring your data warehouse directly.
It's easy to set up; on a new worksheet, add the Custom Report object and allow your users to select from the predefined dimensions and measures in your workbook.
Update Embed links content with sorting and filtering
As a Lobby visitor in the Embed section, you can sort and search for embedded links.
Actions: Math Operators
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.
Actions: OnFilterInField Event
The event triggers when a Filter has been applied or is pending in a field.
2.27 - 17 January 2023
Copy and Paste objects between workbooks
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.
Actions: OnAny Filter Event
Trigger actions when a Filter is either pending or applied.
2.26 - 19 December 2022
Date filter options - predefined periods
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.
Data field selection improvements
The new design in the property panel includes icons for each data type and collapsible menus for each table section.
Administration - Snowflake Consumption app installation
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.
2.25 - 12 December 2022
Time filter for Custom Measures
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.
Astrato's Data Engine - joins
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.
Font options added to objects
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.
Workbook Editor - Object selection and placement made easier
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.
Consumption Licensing - view usage as credits or minutes
Astrato Enterprise users can view their license consumption by minutes in addition to credit blocks.
In addition to Snowflake and PostgreSQL, Astrato supports Dremio Cloud.
2.24 - 23 November 2022
Actions - New Event: Before the workbook opens
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.
New Table Mini charts in the Visual representation options
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.
Search the list of users by name or email
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.
Data Object - Date 'Group as' options
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 then to select the Format you prefer. A Custom format option is also available.
Tick the Null values box to view dates that are missing.
Embed - detailed sorting and searching
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.
2.23 - 7 November 2022
Licensing and Usage
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):
Data Source - more details visible
More details about each data source are displayed when viewing your data sources. This includes:
Data Source Name,
# of Data Views connected to the Data Source,
Last Modified Date.
2.22 - 26 October 2022
Update data limits in charts
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:
Line - 3,000
Filter - 30,000
Bar - 1,000
Heatmap - 2,000
Scatter - 15,000
Gauge / Pie chart - 100
Sort by measures or dimensions without needing to add them to the visualization. More analytical power, without the extra code.
Filter bar update - add new filters
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.
Option to 'ignore global filters'
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.
2.21 - 7 October 2022
Actions - no coding drag and drop
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.
Export as - CSV, XLSX, PDF, or PNG to print
Use either the 'Export as' or the 'Object > Copy to clipboard' to create output that you can print from Astrato.
Legends showing up even on small charts
Legends always show on charts even if you make them very small.
Brushing and Selection - Visually link charts to their table data using color. Apply unique color to a dimension to show relationships across data objects.
Color opacity - New easy-access opacity setting for color swatches. The opacity percentage is shown in the properties panel. An example is to use this feature to adjust the color on a scatter chart, visualizing the density of the points on a scatter chart.
2.20 - 26 September 2022
Google BigQuery - data source
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.
Custom Measures - aggregate expressions and more ...
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.
Date group or Timestamp
Instantly create a chart (e.g. timestamp and value = month or hour, day of the week, etc.).
Axis bands on charts
Highlight the chart itself. Assign color bands and name them (e.g. benchmarks).
Web-safe fonts - We now offer a choice of web-safe fonts.
Text shadow formatting - Improve the visibility of text on lighter backgrounds.
2.19 - 12 September 2022
Continuous Axis option to view gaps in temporal data points
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.
Heatmap - rectangle preset
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.
2.18 - 30 August 2022
Enable highlight-brushing on a table (excludes pivot)
Hovering or clicking on a value (in a table or filter), highlights the same value(s) on all the charts of your workbook.
Enable highlights on visualizations by hovering on a chart legend
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.
2.17 - 17 August 2022
Date groups have more format options
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.
Updates to your table with drop-down filters
Without adding any other data objects to your workbook, you can set filters in your table.
Within your table, click on a row, or use the filter dropdown to view and add or remove filter options from your table.
Progress bar style enhancements
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.
2.16 - 1 August 2022
New rules define limits for aspect ratio when manually changed
Limit custom aspect ratio - new rules define limits for aspect ratio when manually changed, so that:
the width will never be greater than 4 times as wide as the height, and the
height will never be greater than 4 times as high as the width.
Formatting improvements to tables, bar, and combo charts
All table progress bars are aligned
Select rounded ends for the bar charts and with stacked bar charts
Add rounded borders and padding options to the combo chart
2.15 - 20 July 2022
New Title options make it easier to add context to objects, with a new discrete menu for managing title content.
Scatter plot trend lines through points
Improvements to the scatter chart styles as well as the addition of a trend line through points on the scatter chart.
Direct data labels
For sparklines or charts where the axis is smaller, you can now show labels at the end of a line chart.
2.14 - 20 July 2022
Filter bar enhanced with editable fields to simplify and speed up analysis
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.
Layers - choose between sheet layers and object layers
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.
Date group presets
New date selections offer presets of dates to simplify date selection for all objects. Presets include: presets quarter, day of the week, and certain holidays.
Pivot table - dimension limits to improve performance
To improve performance, there is now a limit of 7 dimensions in a pivot table, with any combination of Row and Column headers.
Improved performance of data connections to Snowflake
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.
2.13 - 21 June 2022
Filters: easy to check the number of filters you've applied
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 ...
2.12 - 7 June 2022
Astrato supports Snowflake integrations using Okta for role-level security
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.
Custom color palette for charts helps you align with your brand, event, or theme
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, simply click on the double row of dots on the left, to drag and drop the color to its new position.
Filters - tab added to the Object properties panel
The object properties panel now has a Filter tab, this consolidates the options for Chart and for Measures filters, so you can amend filters faster.
Measure Filter - selection improvements, use the (+) plus sign beside a filter object to add more measure filters
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.
Improved default styles to improve differentiation
New and improved default styles make table content look better and easier to differentiate from the rest of the data by making:
Column headings are bold and the font size is larger
New light gray divider below column headings
Column widths are evenly spaced, making better use of the white space so data is easier to read and use.
Pivot Table labels - show or hide
Each measure in the properties panel has an option to display or hide the measure label. If there is only one measure the label is hidden by default. Read more about using Tables.
2.11 - 23 May 2022
Astrato Embeds: Filtering embedded source data
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.
Enhanced style formatting for text objects
You now have options to format the style of text objects with:
line and letter spacing
background formatting options - including images, background blur, and opacity
border options - color and radius
Dimensions: Group dates and timestamps
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).
Data Engine: Warning displays when a user creates a duplicate data connection
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’.
Workbook Lobby: Improved search options
Within the lobby users can now search for a specific :
filter by a data connection
sort their list of workbooks by: name, creation date, updated date, Last opened date
Workbook Demos and data views: refresh to always have the most up-to-date versions
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.
Workbook Editor: More control of your Workbook Sheets
Now you can design your Workbooks with a:
specific sheet size to keep it consistent for all users
responsive sheet size for more flexibility, to adjust the worksheet size based on the screen size
Locked aspect at sheet level, not just at Workbook level.
2.10 - 10 May 2022
Trendline error message if there is a null or negative value in the data
A new warning message displays if a user attempts to create an exponential trendline if their data contains zero or negative values.
Using Line Charts for Linear or Exponential Forecasting
Features linked to using a Line Chart, for linear or exponential forecasting include:
A vertical reference line displays to highlight where the forecast data starts
Each forecast has a label
It projects the linear or exponential trendline using defined reference/training data points
It also has the following constraints:
Forecasting is only possible on dates (includes years as an integer format)
A forecast must be linked to per measure. It is also possible to forecast on multi-line charts that are split by dimension, providing there is only one measure.
Please see the new page in our Data section to learn more: Advanced Analytics - Forecasting.
Pivot Table displays multiple data dimensions, with added visual style options
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.
2.9.0 - 25 April 2022
Astrato Embeds - Creators can generate restricted links
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.
Display more data points on Line and Scatter charts
Increased the number of data chart points displayed;
Line Charts 200 to 800 points
Scatter Chart 200 to 600 points
Users have the option to select which data points are visible within the number displayed.
2.8.0 - 11 April 2022
Enable a trend line on your bar, line, or scatter chart to indicate the general course or tendency of points based on your calculations.
Regression trend types include: linear, exponential, polynomial, logarithmic, power series, and moving averages.
Formatting style options include: color, line style, opacity, and thickness.
Data Filters with extra 'filters' built-in
Updates to the data filters include:
Predictive search options highlight the top-most value returned
Visualization using a bar graph indicates the prevalence of the data values being filtered
Unsupported Browsers - warning for users logging in
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.
2.7.0 - 30 March 2022
Astrato Community link
The Astrato Galaxy (our Community of Astrato users) is now available as a quick link once you log in to Astrato.
Google signup consent
We’ve updated the login screens, to remove the data consent request from Google.
Only Google account users need to provide data consent when using Google Drive or Google Sheets as a data source from within the Data View Editor.
Astrato Embeds *please see the update in Release 2.9
The Embed feature in Astrato (your Administrator must enable the feature) lets you take content from a published workbook and allows you to 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 every day - CRM, HubSpot, Confluence, or publicly on your website or in a SaaS product.
2.6.0 - 19 March 2022
Smoother transitions as data changes
Changes to animations and data points on all charts look smoother as data changes are made and refreshed.
PostgreSQL connections as a data source
In addition to Snowflake, and Google Sheets, Astrato now supports PostgreSQL data connections which appear as an option in the Data View Editor.
2.5.0 - 02 March 2022
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.
2.4.0 - 21 February 2021
Workbook Updates - updates in changes to the flow for creating and publishing a workbook (example for creating a workbook shown here).
2.3.0 - 4 February 2022
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.
2.2.0 - January 2022
Workbook Editor Tooltip - Are you terrible with names? We've added tooltip to the controls in the workbook editor to help you out.
2.1.0 - 15 December 2021
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).
2.0.0 - 2 December 2021
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.
1.12.0 - 23 November 2021
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.
1.11.0 - 10 November 2021
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.
1.10.0 - 29 October 2021
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.
1.9.0 - 13 October 2021
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.
1.8.0 - 05 October 2021
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.
1.7.0 - 15 September 2021
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.
1.6.0 - 31 August 2021
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.
1.5.0 - 17 August 2021
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.
1.4.0 - 04 August 2021
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.
1.3.0 - 22 July 2021
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.
Editing Field Names
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.
1.2.0 - 9 July 2021
Signup and Login options
You can now use your LinkedIn account or your email address to sign up to Astrato and log in to the site.
Demo data check
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.
Invite users to Astrato
In the Administration settings for People, click the Invite Users button to add email addresses to generate and send Astrato user invitations.
Still haven't found what you're looking for?
Visit the Astrato Galaxy (our community of ASTRATOnauts) to see if someone else has asked a similar question, or click on the chat icon (on the right side of your screen) to chat with a member of our team.