Integration with Domo, and two new blocks: horizontal join and running total
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.
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.
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!
Google sheets integration, filter data by many conditions and unify datetime formats
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.
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.
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.
Shopify integration, writing to PostgreSQL and update to the aggregate transform
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.
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.
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.