You can add feature requests, ask questions, participate in data challenges, and gain inspiration from fellow ASTRATOnauts.
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.
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
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.
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:
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
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.
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.