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

  • Hover over the Arcwise icon in the formula bar and click “Enable formula hints” to get started.

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

  • Screenshot

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

  • Video demo

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

  • Video walkthrough of the new connect flow

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

  • Video demo

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

  • Video demo: All connected sheets, Video demo: Single connected sheet

  • Find it under Extensions > Arcwise > Refresh all connected Arcwise data and formulas.

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

  • Video demonstration of all the features above

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

  • Video demonstration of new SQL editor

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