Introduction

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.

Releases

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

Back to Top


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.

Back to Top


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

Back to Top


2.15 - 20 July 2022

Title Editing

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.

Back to Top


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.

Back to Top


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.

Bug fixes

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

Back to Top


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

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 bold and the font size is larger

  • New light gray divider below column headings

  • Column widths 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.

Back to Top


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 option, with a selected format to display a combination of dimensions (for example, select 'Month Year' with just the 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:

  • snowflake instance

  • database

  • credentials

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 :

  • workbook name,

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

Back to Top


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.

Screenshot shows a line chart with a vertical line used as a reference between current data and forecasted trendline on the right.

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.

The screen shot shows that area (Neighbourhood) is used Area across the top, and two dimensions: bedrooms and bed type are displayed on the left-hand side.

Back to Top


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.

Back to Top


2.8.0 - 11 April 2022

Trend lines for forecasting

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.

You can also show the Regression Equation, and select its display position.

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.

Back to Top


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.

Back to Top


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.

Back to Top


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.

Back to Top

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

Back to Top

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.

Back to Top

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.

Back to Top

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

Back to Top

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.

Back to Top

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.

Back to Top

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.

Back to Top

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.

Back to Top

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.

Back to Top

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.

Back to Top

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.

Back to Top

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.

Back to Top

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.

Back to Top

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.

Back to Top

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.

Filter

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

Animation shows how to apply filters to your data visualizations.

Back to Top


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.

Screenshot of login page showing you can use your LinkedIn account or your email address.

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.

Screenshot of the Properties panel in the workbook shows your data source as Demo Data.

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.

Animation shows the steps to invite other people in the Administration settings.

Back to Top

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.

Did this answer your question?