Merge results from two Datasets to one

Hi all,

As far as I know there is no way to merge two Holistics datasets on a common key. Is this something the team have considered adding?

A common question from colleagues at different departments are on the format:

  1. What is the proportion of filtered data to total data?
  2. What are the counts of filtered data compared to counts of unfiltered data over time?

User difficulty without requested feature:
Two separate widgets would need to be created separately side-to-side making it harder to directly compare data since it’s not in the same visualisation.

Developer difficulties to prepare desired dataset:
Likely need to create derived SQL-tables in Holistics, or create additional tables in our Data warehouse and import to Holistics. This is cumbersome and only a matter of time before another colleague asks for another set of filtered dataset which needs to be prepared.

A feature to merge two Dataset results in Holistics would allow for a self-service approach. Similar functionality found in Google’s Looker docs

If this is solved already I’d be thankful if you could point me in the right direction on how to approach it. :pray:

“Merged Results” could also help address the drill-across issue, as long we were able to build metrics on top of the merged results.