The latest updates from the Intersect Labs team. New features, fixes, upgrades, and more.

March 26, 2021

Integration with Domo, and two new blocks: horizontal join and running total

New

Integration with Domo

If you are looking for ways to extract your data from Domo, and reorganize the data, or do your own analysis of it - you would benefit from our newest integration with Domo.

You can now pull your Domo data in your workspace on Intersect, and integrate it with your data notebooks, in a few clicks.

New

Merge two datasets with horizontal join

In many cases, your data will be stored in different places. You might have your customer data in a Postgres database, and your sales data in Salesforce. We support many integrations that let you pull data from all these sources. However, you also need to be able to merge these tables. From now on, it is very easy to do that with the newest “Horizontal join” block.

With this block, you can merge your tables using four types of joins. In just a few clicks, you’ll have your data merged and ready for analysis.

New

Running total block

Sometimes you want to display the cumulative sum of your values as they grow with time. That’s why we built the “Running total” block on Intersect, that lets you view the total contribution so far of a given measure against time.

For a SDR, the sales manager may have to calculate a running total to keep track of their progress until they reach their quota. For an inventory manager, it may be analyzing a running total to be able to keep track of inventory. With the new “Running total” block you can do this in a couple of clicks!

March 19, 2021

Google sheets integration, filter data by many conditions and unify datetime formats

New

Pull and Write data to Google Sheets

Most of your data is stored in Google Sheets, and you need an easier way to extract and analyze it? We have the solution for you: Google Sheet integration on Intersect!

You can now pull your data from your Google Sheets, and build custom notebooks. You can format your data, create beautiful charts, share it with the rest of the team and more. You can also use this integration to filter and organize your data, so you can send the new tables back to your spreadsheet.


New

Filter data based on multiple conditions

What if you have information about your customer that needs to be filtered not only by state, but also by zip code, browser, or a particular device type? We got you!

With the newest updates on Intersect, you can filter all your tables based on a variety of conditions using only one block. This block supports multiple filters that can be easily applied to the columns of your choice.

New

Unify date/time formats

Sometimes your tables will have date columns that contain a lot of different date and time formats. With the “Unify date/time format” option, you can select from nine format types to unify all your date columns, so that you can perform better analysis.

March 12, 2021

Shopify integration, writing to PostgreSQL and update to the aggregate transform

New

New Shopify integration

With the new Shopify integration, you can pull valuable data from your Shopify store and use it to create custom data apps. Manage inventory, track orders, or build custom sales reports - these are some data apps that you can start implementing today.


New

Writing to PostgreSQL

Two weeks ago, we announced the PostgreSQL integration, which allowed you to connect your Postgres database and pull data directly into your data apps. With Intersect's newest updates, you can now write back to your Postgres tables using a very easy-to-use custom data mapping option.


Improvement

Updated aggregate transform: Find first and last record

The aggregate transform has two new options "Find first and last record". Using these options, you can retrieve the first or the last record in a given column for a group.