Skip to main content
samantha_braastad
Contributor ⭐️⭐️⭐️⭐️⭐️
October 4, 2018
New Idea

Allow for multiple MDA lookups between various MDA tables

  • October 4, 2018
  • 3 replies
  • 56 views
We have multiple data sources that are pulled into the MDA tables to track customer usage information. When reviewing the data, it would be ideal to create a single report that pulls from more then one lookup table at a time so that a single table can contain data points from 3+ data sources. 

For example, we receive the following data files on our customers: 
  1. User profile data/access level
  2. User logins
  3. User usage
The unique identifier in each report is the users email address. I would like to build a single report that provides the user profile information, an aggregation of logins over a given time period, and an aggregation of their key usage behaviors. Because I can only link the email to one other MDA table, I am unable to get all three datapoints into a single report.  

    3 replies

    bill_davis
    Contributor ⭐️⭐️⭐️
    October 4, 2018
    I have cobbled together a massive spreadsheet that captures multiple pieces of data like this, and builds one MDA Object 

    The ability to do a Join on more than one MDA object in reporting is severely overdue.

    dan_ahrens
    Expert ⭐️⭐️⭐️
    October 5, 2018
    Good news Bill and Samantha! We are working on solving for this use case in our reporting engine. It's essentially similar functionality to our Bionic Rules where you can bring in more than one object to create a report off of. Still in development and design, but targeting early 2019. 🙂
    VP of Customer Success at Forcepoint
    phani_kumar
    Gainsight Employee ⭐️⭐️
    February 12, 2020

    Hi Samantha.

    Recently we released a new module which is DD(Data Designer) with this feature you can create a report using all your different source objects.