📜Product Changelog
Updates to the Arcwise product
2023/12/13
AI Analyst
Added advanced AI Analyst settings to control which tables the AI can see, as well as customization of the system prompt. Go into the Arcwise Admin panel (under "Connections") and open the "Advanced Settings" section in your warehouse connection.
Visualization capabilities are now more consistent, especially with multi-line plots.
Fix a minor overflow issue with AI Analyst result tables.
Improved preview tables across the product (you can now select and copy+paste from the grid like a spreadsheet)
Numeric input filters now display a list of sample values from the database.
[New] Formula hints: the Arcwise Chrome extension can now display tooltips with the column names and types for all Arcwise columns used in a formula.
Fixes to BigQuery SQL generation
[Beta] Added “Import data tabs” feature to the custom SQL editor. This allows you to reference other Arcwise-connected sheets by name in the SQL query (e.g.
SELECT * FROM Sheet1
)
2023/12/11
Improved column formula copilot suggestions
Added additional entrypoints for the AI Analyst (Arcwise menu > "AI Analyst", new action for empty tabs)
Lots of small bugfixes
2023/11/28
[Beta] Support for Stripe and Google Analytics connectors. Configure them in the "Integrations" section of the admin panel.
Internal bugfixes and improvements.
2023/11/21
Added a new flowchart UI where you can visualize the flow of data between Arcwise tabs in your sheet (go to Extensions > Arcwise > Open Flow)
You can now “drill down” into any Arcwise SQL formula to inspect the underlying rows and SQL that match your function’s criteria. Click the Arcwise icon in the formula bar (currently only works for “big data” formulas).
(You may need to update your Arcwise Chrome extension to the latest version)
We’ve added a “Spreadsheets” view to the admin panel, which lets you see all your org’s spreadsheets at a glance. Click into any spreadsheet to examine its connections.
The “Tables” view also shows the number of connected sheets per table. Click into any table to see all of its linked spreadsheets.
Fixed a bug where the formula field’s autocompletion wasn’t working correctly.
2023/11/09
[Beta] Experimental support for connecting to Salesforce & Hubspot entities.
Added support for SUMBY & MINBY column functions, which allow you to calculate the sum & min of groups of rows.
Improved performance of large pivot table previews.
2023/11/03
Fixed an error where long-running data tab updates may time out. We also added a progress indicator for better visibility into what’s going on (which downstream pivots are being refreshed, etc.)
Downstream Arcwise formulas will now be automatically refreshed as well.
AI Analyst: added chat histories. Chat threads are now persistent and you can revisit past threads across sessions.
All chat history is stored locally in your browser - we don’t store any of your data on our backend.
Also added the ability to ‘pop out’ the AI analyst into a popup window.
Access these new features from the dropdown menu at the top-right.
When filtering on columns with thousands of distinct values, the selection dropdown will now dynamically re-fetch its populated values to match the current input.
2023/10/23
Pivot filters now dynamically fetch updated values based on your current input.
Fix FIND() in Postgres formula fields.
2023/10/19
Fixed XLOOKUP for Postgres databases.
AI analyst - fixed errors when conversation gets too long & improved responses for visualization requests.
One-click “Edit SQL” in the sidebar SQL panel. Video demo
Note: The user will be shown a modal that explains that by doing this, they’ll convert their existing connection to a custom SQL connection.
Automatically sets the sheet title to match the connected data name if the sheet title is a default Google Sheets title (e.g. “Sheet1”, “Sheet2”, etc).
2023/10/13
You can now preview changes to connected data tabs before saving (click the “Preview” button next to “Update Query”).
Note: adding or editing formula fields no longer automatically saves until you press “Update Query”. Video demo
[Beta] Use the new “Team” tab in the Connect Data dialog to see your team’s Arcwise-connected spreadsheets at a glance, including all the datasets each spreadsheet is connected to.
Simplified the SQL that Arcwise generates for most data connections (avoiding unnecessary use of CTEs)
2023/10/05
Connect Data
We’ve redesigned the Connect Data flow with all-new search results page & preview pages!
New: you’re also able to see the number of Arcwise sheets connected to any given table, as well as when it was last connected. By default, search results are now ranked by the number of Arcwise connections.
Simplified the generated SQL for most connection types.
Fixed a bug where pivot tabs sometimes indicated spurious unsaved changes.
2023/09/28
Always write Looker looks to the Sheet as "plain table" pivots.
When previewing data, add clearer messaging when only a preview of the dataset will fit in the spreadsheet. Screenshot
Add
DATEVALUE
column function to convert strings to dates.
2023/09/25
(Beta) Added support for XLOOKUP in formula fields. Use the XLOOKUP function with any search column along with a “lookup column” and a “result column” from another Arcwise table.
When writing a formula field, column names matching your current input will now be auto-suggested alongside the function suggestions.
If you have unsaved changes to an Arcwise data or pivot sheet and switch to another sheet tab, you’ll now see a blue banner at the top prompting you to save your changes (rather than instantly discarding the unsaved changes).
Added a settings section to pivot tabs, where you can adjust whether the pivot has totals, is saved as a plain table, or is auto-updated when the source data refreshes.
2023/09/22
Pivot tabs now automatically refresh when the source data tab is refreshed or updated.
[Beta] Added a new option in the Arcwise menu to refresh all Arcwise data and formulas in the current spreadsheet.
2023/09/18
Added a row count to the “connect data” preview window (works when connecting both regular tables and SQL queries).
Screenshots: when connecting table, when previewing a SQL query
Pivot tables
You can now order pivots by values - right-click an aggregation and sort by ascending or descending
You can now easily aggregate by year/quarter/month/week/day for date fields
You can now apply a limit to pivot results - toggle the “Limit results” selector in the bottom left
(Works in conjunction with ordering if you want e.g. the top 10 years by the sum of sales).
SQL editor
Added autocompletion for table names, column names, and keywords
You can now click on tables in the left-side tree view to see their columns as well as a preview of table contents.
2023/09/12
Fix issue where custom SQL query connections were often not respecting the sheet cell limit.
2023/09/09
Looker integration - import Looks by URL
“Connect SQL” has moved inside the “Connect Data” dialog.
Redesigned the “Connect Data” flow to have horizontal tabs for tables, file uploads, and SQL queries (along with a few other very minor changes.)
Allow for a Custom SQL query tab to be changed to an entity connect tab and vice-versa.
Formula field & pivot value formula editors now auto-suggest column names
Added support for additional column formula functions: AND/OR/NOT/INT/VALUE
Pivot tables
The fields section of the Pivot Table modal is now resizable
You can now right-click pivot table fields to remove them
Last updated