Roadmap

Coming Soon: Advanced Analysis

Feature Requests Integration Requests Visualization Requests Metric Requests Benchmark Groups Coming Soon: Advanced Analysis

Voters 21

  • Avatar
  • Avatar
  • Avatar
  • Avatar
  • Avatar
  • Avatar
  • M
  • + 15 voters
  • S
  • I
  • P
  • Avatar
  • Avatar
  • Avatar
  • Avatar
  • Avatar
  • Avatar
  • Avatar
  • Avatar
  • Avatar
  • Avatar
  • Avatar
21

Merging / Blending / Joining data (cross object)

Avatar
 Emil (Databox)

DESCRIPTION: Ability to combine, blend or join data from different sources, objects, tables and visualize all this in a user-friendly way.

Users would:

  1. First choose a Data Source or Dataset they want to merge with another Data Source or Dataset
  2. Align the two sources by selecting a unique identifier (column available in both sources)
  3. Select what columns you’d want to merge
  4. Specify how you want the columns to be merged: a) Include only first match (no new rows are created) or include all matches (create new rows for each match) b) Exclude rows that do not match (Inner Join), include rows for unmatched values from primary source (Left Join), or include rows for unmatched values from secondary source (Right Join).

It will also be possible to export data from Datasets.

USE CASE: Combine data from different data sets / tables like Customers from Source 1 and Orders from Source 2. Use unique identifiers to match rows and then visualize what customer placed which order, calculate conversions, and track the customer journey across different systems.

LET US KNOW WHAT YOU THINK!: We might develop this feature in the future. We encourage you to upvote it if you find it valuable and leave a comment with feedback and insight into what objectives you feel this feature could help you with. Getting more feedback upfront will help us better align the feature with our users' needs.

DISCLAIMER: The image mockup shared in this post is for illustrative purposes only and does not represent the final product. The final version of the product may differ from the mockup.

  • 2024/07/29 -
A

Activity Newest / Oldest

Avatar

Dawn Smith

Please implement this. I've been talking with support trying to figure out how to do just this, when I stumbled upon this. So I guess I can't do it yet... but I have several use-cases for it and it's a feature from Looker Studio that we used quite a bit.

Avatar

Emil (Databox)

Status changed to: Under review

Avatar

Gary Magnone

highly anticipated so I can build tables with multiple custom metrics with consolidated rows.