select *
Updates

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

Published on
March 29, 2021
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 the newest data block, you can merge your tables using four types of horizontal joins:

  1. Inner join: return records that only have matching values in both tables
  2. Left join: return all records front he left table, and matching values in both tables
  3. Right join: return all records from the right table, and matching values in both tables
  4. Full outer join: return all records when there is a match in either left or right table

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!

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

March 29, 2021

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 the newest data block, you can merge your tables using four types of horizontal joins:

  1. Inner join: return records that only have matching values in both tables
  2. Left join: return all records front he left table, and matching values in both tables
  3. Right join: return all records from the right table, and matching values in both tables
  4. Full outer join: return all records when there is a match in either left or right table

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!

Try Intersect Labs Today

This is your gateway to the magical land of Intersect Labs, where we help you improve your data processes.
Book a Demo