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.29 | 2.30 | 2.31 | 2.32 | 2.33 | 2.34 | 2.35 | 2.36 | 2.37
1.8 - 22 May 2023
Visuals: Enable continuous axis for date/number dimension type
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.
Workbook Editor: Filter Object - added pagination for results
When using the Filter object, and the limit is reached to load results, pagination displays so you can click through to the set of results on the next page instead of scrolling through the results.
Filter bar: Introduce date picker
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.
2.37 - 22 May 2023
Actions: Split Text
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.
DVE: Measure with row-level calculation
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.
DVE: Create an Inline table and paste data
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).
Admin: Manage a hybrid model of license seats and consumption-based
From the License & Usage section in Administration, you can now manage a hybrid model of license seats and consumption-based for your users.
Admin: Access Control for improved governance by member
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.
Workbook Editor: Click on Logo to update
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.
1.7 - 9 May 2023
Workbook Editor: Control - Text Input
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.
2.36 - 9 May 2023
DVE: Add custom formatting for the outputs of your custom measures
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.
Admin: Set a Default view for each user role
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.
Admin: General settings - Allow Creators to upload shared media
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.
Actions: General - Get [Category]
We've added a Get [Category] block with the new General section. This action block gets the current context values, including:
Current user's [email, name, or profile image URL].
Date and time - based on ISO8601 [Today's date, Today's Date and Time].
Workbook data source [Workbook ID, Name, Data source type].
Active sheet name [Sheet ID or Name].
You could add the block in an IF statement to check if the active sheet is [Name], then perform an action.
Actions: Right-click to Add a comment
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.
Viz-1.6 - 24 April 2023
Control: Button has Quick Styles
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.
2.35 - 24 April 2023
DVE: Join quality checks on user-selected pairs
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.
Actions: Wait block
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.
Action: Using a string variable in the Filter outcome
Use the existing Apply Filter block to enter any type of string variable that outputs a dynamically filtered outcome.
Viz-1.5 - 11 April 2023
Properties panel: Filter bar - Add option to hide the "new filter" button
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.
2.34 - 11 April 2023
DVE: Duplicate tables from the table context menu
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.
Data Explorer: View the SQL expression when you create a measure
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.
DVE: Calculator added to add numeric values without adding a field or aggregation
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.
DVE: Manage your data in the table without leaving the DVE
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.
Actions: Variables - use Ternary operators for inline statements
Use the new Ternary block to have inline conditional statements for your inputs without duplicating them using IF and IF/ELSE statements.
Viz-1.4 - 4 April 2023
Visuals: Bar Charts - Histogram visual added
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.
Data Engine: Query Profile Insights
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.
Workbook Editor: The last tab used in the properties panel stays open
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.
Image Object: Media gallery & styles
The image object now supports adding images from the Gallery. You can adjust image display properties including: opacity, saturation, blur, and shadow.
Visuals: Added Pie/Donut chart borders
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.
2.33 - 27 March 2023
Workbook Editor: Gallery for image upload and reuse
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.
Upload the image by browsing your file folders or drag and drop the file.
The image preview displays; type the file name.
To keep your files organized, add a new folder, or save it to a folder you already have.
Click Add to Media Gallery to upload the image.
Workbook Editor: Graphics - Image options include 'Add from Gallery'
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:
Image source from the Gallery or a URL
Media window to change the image in the frame.
Adjust the image size in the frame to: fill, resize to fit, or cover (the image expands to fill the frame).
Use the Adjust options to add a shadow or the sliders to change the Opacity, Saturation, or Blur.
Administration: Media area to manage images across workbooks and your tenant
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.
Astrato: Section name visible as the browser tab name
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.
Actions: Logic/Conditions - Writeback block
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.
Actions: Logical - And / Or
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.
DVE: Source table name displays with field name
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.
DVE: Two clicks to duplicate custom measures
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.
DVE: Filters - Option of 'In list' as a filter added
You can now apply a filter for an item that is either IN or NOT from a list.
Layers: improvements to layout and search
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).
Workbook Editor: design uplift of right-click menu
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.
Viz-1.3 - 14 March 2023
Filters: Slider object to select ranges
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
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:
Customizable range and step size: You can adjust the minimum and maximum values of the slider to suit your data and adjust the step size for finer or coarser control.
Distribution bars: The slider can help display frequency like a histogram (as well as other measures) to show the volume of data available before making a selection, to reduce queries to the connected data source.
Smooth animation and responsiveness: The slider smoothly animates to reflect your input, and the dashboard instantly updates as you adjust the range.
Multiple sliders for complex filtering: You can add multiple range sliders to your dashboard to filter data based on multiple criteria simultaneously.
The filter bar now includes the slider by default when numerical or date fields are added.
Control: Button - new style and icon options
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:
Icon: The button can display an icon on the left of the button label. Enable the icon and choose from a wide variety of icons. The icon color is configurable for both the default and hover states.
Default style: Enable and configure a drop shadow for the button’s default state. When enabled, it’s possible to configure the color, the offset, and the blur of the drop shadow.
Hover style: We have enabled settings to configure the look of the button when the mouse cursor hovers over the button. Settings include text color, background color, icon color, border, and drop shadow.
Click animation color: Configure the color of the click animation to fit with your brand colors.
Combo chart - data labels for bars
Data labels on Bar charts are now available for our Combo chart too.
2.32 - 13 March 2023
DVE: Interaction improvements
Continuing our efforts to improve the ease of interacting with your data in the Data View Explorer (DVE), we've added the following:
Fewer steps for navigation - There's no need to click the Data Explorer tab, as you can now click the option to Edit table added to the context menu (above Preview table).
Tooltips on the DVE action bar - hover over the icon to view a tooltip briefly describing its function.
Descriptive error and warning messages - include error text if a combination of filters returns no records, and a warning displays to confirm you want to Remove all joins.
Animation on the blank canvas shows the steps to add custom columns, dimensions and measures in the DVE.
Actions: Invert - Boolean
Use the INVERT action blook 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.
Actions: Get and Set Object Properties
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).
2.31 - 27 February 2023
Workbook Editor: Toolbar and panel redesign
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.
Visuals - Icons are monochrome, so the details are easier to see and improve the differentiation of the list of data objects.
Filters - Dynamic filters.
Controls - Button, Input form.
Graphics - Text, Shapes, Image (URL).
Advanced tools for analysis and interaction
Layers - adding and managing layers of objects.
Variables - creating number, string, or Boolean variables.
Actions - create advanced actions using our no-code blocks.
Added new Graphics article
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.
Workbook Editor: Navigation style updates
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.
Data: Data View Editor (DVE) layout and joins redesign
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.
DVE: filtering dimensions and measures in the Data Explorer
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.
Lobby: My drafts as default
When you have a draft workbook, the My drafts tab becomes the default tab in the Astrato lobby to access your content faster.
Actions: Full-Screen view editor and improved navigation
You now have a nearly infinite workspace provided to build your actions. The action bar also has new options including:
Option to 'Fit to screen' that scales and adjusts the zoom automatically so you can see where everything is on your canvas.
Viz-1.2 - 27 February 2023
Properties panel: Search field added above list of date ranges
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:
Pre-defined “calculated dates” by clicking Date Range at the top of the list presented (e.g. Last 30 days, Previous year, Yesterday).
List of boolean options (e.g. equals, greater than, is null/empty).
Properties panel: Added chart filter count on the Filter tab
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+.
Properties panel: Radius icon refined
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:
Text object: Graphics > Text box > Layout > + Border
Button: Controls > Button > Style > Border
Filter: Filter > Style > Object > Border
Viz-1.1 - 15 February 2023
Workbook Editor: Include table and original field names
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.
Workbook Editor: Cell selection in a 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.
2.30 - 13 February 2023
Data: Connect to Google BigQuery with JWT
We’ve added authentication support for non-Google account-linked usernames and passwords. Key benefits:
Non-domain users can view data that are unique to them (for example, for OEM use)
Using a service account to manage public-facing dashboards is possible.
Actions: Execute SQL
Use the SQL blocks to create string variables that bring back a value or trigger further downstream processes.
DVE: Export to CSV
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.
DVE: View Query Insight in the Data Explorer
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.
DVE: Drag and drop to change column positions
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.
Viz-1.0 - 03 February 2023
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 brushing and point selection
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.
Property Panel: Filter styles on objects and progress bar added
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.
Table Conditional Coloring
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.
Highlight cells or rows that fall above or below certain thresholds (e.g., budget limits, performance benchmarks).
Color-code cells based on categories or groups (e.g., different product lines, regions).
Apply different colors to cells or rows based on the magnitude of their values (e.g., red for low values, and green for high values).
Workbook Editor: Table minimum column width
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.
Predefined periods renamed to Date Range
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.
2.29 - 30 January 2023
Actions: String (Text) Operators
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:
replacing or joining string values
manage text formatting
Workbook Editor: Sheet layout template for Custom Report
New template option for Custom Report (self-service) in the Sheet layout options makes it quick and easy to start building your custom report.
2.28 - 17 January 2023
Workbook Editor: Custom Report
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.
Administration: Update Embed links content with sorting and filtering
You can sort and search for embedded links as a Lobby visitor in the Embed section.
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
Workbook Editor: 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
Data View Editor: 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.
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
Data View Editor: 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.
Data View Editor: 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.
Property panel: 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.
Administration: Consumption Licensing - view usage as credits or minutes
Astrato Enterprise users can view their license consumption by minutes in addition to credit blocks.
Data: Dremio Cloud
Astrato supports data connections to 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.
Charts: 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.
Administration: 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.
Charts: 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 select the format you prefer. A Custom format option is also available.
Tick the Null values box to view dates that are missing.
Adminstration: 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).
Administration: Managing Users and Teams
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.
Data: 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 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
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.
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 and 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 date presets 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, 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 Measures filters so that 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 can 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 only one measure exists.
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 can 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
Using Snowflake's Time Travel feature with Astrato
Time Travel enables accessing historical data at any point within a defined period. Includes data that has been edited or deleted.
Astrato Community link added
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 must 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 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.
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.
Data: 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.
Toolbar: Filters easier to find
To improve the visibility of the Filters feature, it’s now just below the data objects selection.
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.