Allow for multiple MDA lookups between various MDA tables

  • 4
  • Idea
  • Updated 2 weeks ago
  • Under Consideration
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.  
Photo of Samantha Braastad

Samantha Braastad, Champion

  • 7,768 Points 5k badge 2x thumb

Posted 2 weeks ago

  • 4
Photo of Bill Davis

Bill Davis

  • 456 Points 250 badge 2x thumb
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.

Photo of Dan Ahrens

Dan Ahrens, Official Rep

  • 25,920 Points 20k badge 2x thumb
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. :)